Kunal RanpuraAug 13, 20194 min5 - Scripts I use every single day1). Script to see what is running in your SQL Server. select * from sys.sysprocesses where status = 'suspended' and spid >10 and hostname...
Kunal RanpuraJul 25, 20191 minQuery to Identify SQL Server Bottlenecks1). select * from sys.sysprocesses where status = 'suspended' and spid >10 and hostname <> 'MonitoringServer' order by blocked desc go...