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