Interested to Buy Any Domain ? << Click Here >> for more details...
What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning
- 3 Answers
- 10062 Views
- TCS, I also Faced
- E-Mail Answers
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
Does partitioning improve performance sql server?
What protocol does sql server use?
What are types of subqueries?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
Where do we use trace frag?
Can I save my report as html, excel or word? : sql server management studio
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Explain syntax for viewing, dropping and disabling triggers?
List some case manipulation functions in sql?
Explain what is sql server english query?
How do you make a trace?
Do you know what is lock escalation?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
How to create a dml trigger using create trigger statements?
What is a recursive stored procedure in sql server?
