January 22, 2010 at 11:23 pm
Any idea or steps : How to evaluate a SP interms of Perfromance ..
January 24, 2010 at 10:20 pm
Check the execution plan in Management Studio.
Query->Include Actual Execution Plan
Chris
January 24, 2010 at 11:46 pm
Run it and gets its execution characteristics via Profiler (or server-side trace)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply