December 5, 2011 at 6:44 am
hi ,
how to find that a single procedure using how much memory and CPU to execute the particular procedure on a database.
December 5, 2011 at 6:47 am
Please check its execution plans (Estimated / Actual).
December 5, 2011 at 6:48 am
You may also use SQL Profiler to generate traces.
December 5, 2011 at 6:59 am
Check sys.dm_exec_query_stats, should give you the info you need.
-- Gianluca Sartori
December 6, 2011 at 7:09 am
sp_whoisactive. Amazing freebie you can find on SQLBlog.com. Make sure you find latest version (11.xx last I heard).
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 6, 2011 at 7:13 am
11.03 as of now.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply