Run the sp and check the response time of that sp.If it takes a long time

How do you measure the performance of a stored procedure?

Question Posted / jayagopal p.s

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is subquery? Explain the properties of a subquery?

1035

What are pessimistic lock and optimistic lock?

1141

What do you mean by stored techniques? How would we use it?

1079

How to optimize stored procedures in sql server?

1240

How to get nth highest salary from employee table.

1206

What are the different subsets of sql?

1615

What is conditional split?

1141

How to insert and update data into a table with "insert" and "update" statements?

1042

What is the command used to recompile the stored procedure at run time?

1118

When would you use a before or after trigger?

955

What are sql server procedures?

1035

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

997

How to disable a login name in ms sql server?

1176

What is join query?

938

What is the difference between deallocate cursor and close cursor?

1333