Through Below Script you are able to identify the CPU utilization By per databases in your SQL Server:– WITH CPU_Uses_Per_Db
Continue readingCategory: SQL Server -DBA
SQL Server -DBA, SQL Server Services, who dropped or altered tables,procedures or databases in SQL Server, What in SQL Server
How to check status on Database Shrink Task in SQL Server?
Through Below Query we can check the status of database Shrink Operation :- SELECT percent_complete, start_time, status, command, estimated_completion_time, cpu_time,
Continue readingDifference Between Log Shipping and Database Mirroring
Log Shipping:- It automatically sends transaction log backups from one database On another server. T-Logs are backed up and
Continue readingHow to find out Who dropped login from SQL Server?
Through below script we are able to find out who is culprit for this activity:- ============================================================== DECLARE @enable INT SELECT
Continue readingRecover Database from Suspect Mode in SQL Server
Today morning I observed that one of our logshipped secondary database reached into Suspect mode, I just investigated and found that log
Continue readingWhat MAXDOP setting should be used for SQL Server?
You can run the below query and identify the suitable MAXDOP for your SQL Server then you can set the
Continue readingHow to recover or attached a database which transaction log (.LDF) file is missing or corrupt?
There might be a situation due to some reason the transaction log file is corrupted or removed , But we
Continue readingFind All Logins Having SA(SYSADMIN) Rights to Access SQL SERVER
Through below query we can find out the logins having SYSADMIN Rights:-
Continue readingPerformance Tunning :- How to Find missing indexes on any database in SQL Server Database
— Missing Index Script — Original Author: Pinal Dave SELECT TOP 50 dm_mid.database_id AS DatabaseID, dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact, dm_migs.last_user_seek
Continue readingWhat is Dedicated Admin Connection (DAC)? How to Establish Dedicated Administrator Connection(DAC) in SQL Server ?
Dedicated Admin Connection (DAC):- DAC allows database administrators to perform T-SQL commands to connect to SQL Server instances and to
Continue reading