Through below script you are able to find out Which Connection Is Doing What in SQL Server at current point
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
Performance Tuning :- Find Most Expensive Queries in SQL Server Using DMV
Through below script you will be able to find the most expensive queries in Sql Server:- SELECT top 20
Continue readingIdentify CPU Pressure In SQL Server
Through below Query we can find out CPU Pressure in SQL Server If Signal wait shows 15-18 % then it’s
Continue readingHow To Check TempDB Speed in SQL Server ?
Below script provides you details about TempDB data files and shows how fast TempDB responding to write and read requests
Continue readingHow to Find all waiting tasks currently active or blocked in SQL Server?
We can find out all the waiting tasks or blocked session in SQL server through below script. SELECT blocking.session_id
Continue readingIdentifying Lead blocker With Blocking Chain in SQL Server
This is a very good script to find blocking chain with lead blocker. I got this script from Pinal dave
Continue readingEasiest way to find or Identify Blocking Queries in SQL Server
Through below query you are able to find out blocking on SQL Server. It provides you details information about blocking
Continue readingHow to resolve Error Msg 1834, mdf file cannot be overwritten when restoring a database in SQL Server
Sometimes when you try to restore a database backup in a new database then you will get below error:- we
Continue readingHow to Shrink TempDB Database Without Restart SQL Server Services?
Sometimes we try to Shrink TempDB but it don’t happen then We can Shrink TempDB Database without restart the SQL
Continue readingHow Can You find out Process ID for SQL Server Services?
After the execution of above script you will get information like service status, process Id, last startup time and service
Continue reading