How do you measure the performance of a stored procedure?
Answer Posted / 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 |
Post New Answer View All Answers
Do you know the policy based administration feature of sql server 2008?
What is surrogate key? : sql server analysis services, ssas
You are doing log shipping due to some reasons it is failing. How you will proceed from there
How to get nth highest salary from employee table.
What is a filestream?
Is mysql the same as sql server?
What is explicit mode in sql server?
What is a result set object returned by odbc_exec()?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What are cursors and when they are useful?
Why people hate cursor?
Do I need a report server to run reports in my application?
What happens if null values are involved in boolean operations?
What are alternate keys?
What is report snapshot in ssrs?