June 8, 2009 at 8:40 pm
If someone complains that their process is running slow, how do you find the sql text that they are running?
June 8, 2009 at 8:47 pm
Profiler.
see this link.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 8, 2009 at 9:36 pm
Yep... I agree... profiler. The link that Wayne points to contains just about everything you'll need to know.
Of course, you could always just ask the user what they're running. Sometimes they actually know. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply