How do you measure the performance of a stored procedure?
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 |
Post New Answer View All Answers
What is the osql utility?
What is the difference between getdate and sysdatetime?
How to drop an existing table?
How to call stored procedure using http soap?
How to insert and update data into a table with "insert" and "update" statements?
What is a select query statement in ms sql server?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How can sql server instances be hidden?
What are the lambda triggers?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Explain can SSRS reports Cache results?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
When we should use @@error?
Do you know the cursor types?
What is code near application topology?