Quickly Check SQL Server CPU Pressure Following query results how many threads are waiting to be executed on the server, if there are more than two threads waiting to be executed on a server, then that server can be assumed to have a CPU bottleneck… Read More
Live Insert Counts Without Disturbing Running Transaction There are times long running insert transactions are annoying and we don’t get direct details of running transaction like how many rows inserted and how many are pending. Following query gets estimated rows inserted for the specific table mentioned. SELECT… Read More
Check Active Queries and Related Details Many times DBAs need to check currently active queries on the DB servers and other details like estimated completion time, blockings, query plan, query text, host name, user login details etc. Following query generate such detail for active queries.… Read More
