Stored Procedure Performance

Question

Post reply

Stored Procedure Performance

karthik M

One Orange Chip

Points: 29139
More actions
August 29, 2007 at 10:38 am

#118306

Hi All,
How to measure the performance of a stored procedure. is there any specific methods available ?
Regards
Karthik

karthik

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

Many people lok at the Execution Plan to see what the procedure is doing and measure the time.

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 2

I use SQL Profiler to measure the CPU, DURATION, WRITES and most important, READS.

N 56°04'39.16"
E 12°55'05.25"

John Rowan SSC Guru Points: 56440 More actions · Answer 3

I do a combination of both. Execution plan is important, but so is logical reads. Stored procedure performance is subjective. What are you trying to accomplish?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Vladan SSC-Insane Points: 22072 More actions · Answer 4

Maybe still answering questions from interview?

like here...