The article, http://msdn.microsoft.com/en-u s/library/cc966 413.aspx, has a link to this script center for stored procedure, Track_waitstats _2005. I do not find stored proc, Track_waitstats _2005, here. Any guidance is appreciated. -Jeelani
I found it locates at here http://gallery.technet.microso ft.com/scriptce nter/8c90bd2e-9 def-4f44-bce4-e 5dae4d86f71
Hi Folks, Just the most minor point in that the script is shown as a "VB" script. Clearly it's a T-SQL script. Regards, Greg
Starting with SQL Server 2005 there is no longer guaranteed a session id <= 50 for system processes. It is better to filter user processes using the is_user_process column. (is_user_process = 1)
Which version of SQL Server are you using? (Just curious.) Thanks!