Active Queries
This report shows currently running queries. This includes queries that are currently waiting, blocked or actively running.
Enroll Today!
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Contact Info
Stedman Solutions, LLC.PO Box 3175
Ferndale WA 98248
Phone: (360)610-7833
Download this page in PDF format
My Active Queries page always shows “There are no Queries Running for this database”. I’m sure there are, we are running load and performance testing.
What can I look at the determine if something is configured incorrectly? What is deemed an ‘Active Query’?
Sherrie,
Active queries are queries that are currently running for more than 3/4 of a second. I sample the current active queries, wait a moment, then check again. This filters out all those quick queries and only shows the ones that are running for more than just a moment.
I hope this helps clarify.
-Steve Stedman