Run the query execution plan if the sp is optimized or not. Optimize the

How do you measure the performance of a stored procedure?

Question Posted / balaji l

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

Please Help Members By Posting Answers For Below Questions

Name the different type of indexes in sql?

1013

Why can there be only one clustered index and not more than one?

1042

How to configure and test odbc dsn settings?

1227

How to identify current user in ssrs report?

408

Why use cursor in sql server?

1133

What are the types of database schema? : sql server analysis services, ssas

1193

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1153

Why SQL Agent is used?

1204

How many types of built in functions are there in sql server 2012?

970

Explain go command in sql server?

1090

What is schemabinding a view?

973

Explain about local stored procedure?

1031

How connect excel to sql server?

1054

How can you fetch alternate records from a table?

1015

How to reaname table name without using sp_Rename in sql server..?

1041