How do you measure the performance of a stored procedure?
Answers were Sorted based on User's Feedback
Answer / balaji l
Run the query execution plan if the sp is optimized or not.
Optimize the query if it takes more time. Check the cpu i/o
time usage.
Is This Answer Correct ? | 13 Yes | 7 No |
Answer / jayagopal p.s
Run the sp and check the response time of that sp.If it
takes a long time to response then optimize the query to
reduce the time usage.
Is This Answer Correct ? | 4 Yes | 1 No |
How to create dbo table in sql server?
What is openxml in sql server?
How to find the date and time of last updated table?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is normalization in Database ?
Wht is Stuff in sql ser
What is a linked server in sql server?
What stored by the model? : sql server database administration
Does index speed up select statements?
How to create a store procedure with encryption?
Explain what are partitioned views and distributed partitioned views?
what is package and it uses and how can u call a package