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 are the advantages of sql stored procedure?
Why do you need a sql server?
Explain time data type in sal server 2008?
Can you always create a cache of a report?
what are the Prerequisites for Replication?
Explain about local stored procedure?
What are the advantages of partitioning?
What is partition, how will you implement it? : sql server analysis services, ssas
What is replication and database mirroring?
Where the sql logs gets stored? : sql server database administration
How to create percentile function?
How self join is different from outer join?
Differentiate between a having clause and a where clause.
What is a primary key?
How to create a view using data from another view?