MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

All Tags » SQL Server » cache » queue (RSS)

Browse Site by Tags

Showing related tags and posts accross the entire site.

TSQL to get current executing statements - SQL Server 2005

Using SP_WHO or SP_WHO2 is a common way to get list of executing processes currently on the server, within SQL Server 2005 you could take advantage of DMV that lists currently-executing statements. select r.session_id ,status ,substring(qt.text,r.statement_start_offset/2, (case when r.statement_end_offset...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 02-12-2008
Filed under: sql server, dmv, cache, sp_who, cpu, tsql, queue, execution, runnable

Page 1 of 1 (1 items)

Copyright © is the original authors. Blog site is an independent site not sponsored by Microsoft. The Yoda blog server and the Brianna SQL server would like to thank www.ownwebnow.com and www.exchangedefender.com. They wouldn't be here and broadcasting without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Browse Site by Tags

TSQL to get current executing statements - SQL Server 2005