How do you measure the performance of a stored procedure?
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 |
Post New Answer View All Answers
Which autogrowth database setting is good?
Explain datetime2 data type in sal server 2008?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
optimization techinques
What is a subquery in a select query statement in ms sql server?
What are 3 ways to get a count of the number of records in a table?
What do you mean by sql server agent?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How to insert stored procedure result into temporary table?
What is the Disadvantage of indexed sequential file.
How to how to convert numeric expression data types using the convert() function??
Can you explain what is sql server english query?
How will you know when statistics on a table are obsolete?
What is the maximum row of a size?
What is Service Broker in sql server 2012?