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 |
Can sql servers linked to other servers?
Explain trigger and its types?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
How to access the deleted record of an event?
Define synonym?
What are the 3 types of schema?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is unpivot?
What is usually the first word in a sql query?
Which are the olap features?
How to transfer Logins from SQL Server 2000 to 2005
diffrence between function and procedure