1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How do you measure the performance of a stored procedure?

Question Posted / guest

Answers were Sorted based on User's Feedback



How do you measure the performance of a stored procedure?..

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

How do you measure the performance of a stored procedure?..

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 do you measure the performance of a stored procedure?..

Answer / vb

Execution time is fast

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

What's the maximum size of a row?

4 Answers   IBM,

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

What is a dbms wizard?

0 Answers  

What is optimization and its types?

0 Answers  




what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

Can sql servers linked to other servers like oracle?

0 Answers  

What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,

How to find the second highest salary of an employee?

0 Answers  

How to list all tables in the database using odbc_tables()?

0 Answers  

What is data source object?

0 Answers  

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories