What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning
Answer Posted / ravi yanamala
1).Check the indexes,table scans and the statics
2)check whether any stored procedures are recompiles excessively
3)check whether SET NOCOUNT is OFF for any stored procedures or triggers
4)check the query whether written poorly r not.check the database normalization as too much normalization effects performance,check the usage of the cursors and temperory tables.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the report builder?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Does partitioning help performance?
What is function of ROLLUP ?
What is #temp and @table variable in SQL server?
Sql server reporting services vs. Crystal reports.
How can sql server instances be hidden?
Why do you need a sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are entities and relationships?
What is unpivot?
How to create database with physical files specified in ms sql server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Can we write trigger for view?
Do you know what is sql injection?