April 23, 2011 at 10:20 pm
Hi All,
We have a query which contains sub queries, and its taking long time, high resources.
How to find out which query is taking much time and resources ?
I think we can find it through profiler. Is it correct ?
Thank You.
Regards,
Raghavender Chavva
April 23, 2011 at 11:07 pm
Check out your actual execution plan - that should point you to the offenders.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply