--Check if index for the table is being used. SELECT i.index_id, i.name, u.user_seeks, u.user_lookups, u.user_scans FROM...

--Get the owner of all the databases select name, suser_sname(owner_sid) from sys.databases

select * from sysprocesses --if wait type is RESOURCE_SEMAPHORE, it is memory pressure. SELECT * FROM sys.dm_exec_query_resource_semaphor...

---Clean SQL Cache DBCC DROPCLEANBUFFERS go DBCC FREEPROCCACHE go DBCC FREESYSTEMCACHE('ALL')

--Find the waittypes select * from sys.dm_os_wait_stats order by wait_time_ms desc --Clear the counter DBCC SQLPERF...

Following query will give you the lead blocker from the blocking chain in SQL Server. SELECT spid ,sp.STATUS ,loginame =...

1). select * from sys.sysprocesses where status = 'suspended' and spid >10 and hostname <> 'MonitoringServer' order by blocked desc go...