How do you measure the performance of a stored procedure?
- 3 Answers
- 15272 Views
- Infosys, I also Faced
- E-Mail Answers
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
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
How to view the error log for any specific instance? : sql server database administration
What is side by side migration in sql server?
What happens when unicode strings concatenate with non-unicode strings?
What is importing utility?
Explain the purpose of indexes?
How can a database be repaired?
What is function of master database?
Difference between 2NF &3NF ?
List out some of the requirements to set up a sql server failover cluster?
How to assign new column names in a view?
Does partitioning ssd reduce performance?
Explain about Joins?
What are the hotfixes and patches in sql server?
What happens if null values are involved in string operations?
