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...