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
- 9869 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
What is buffer cash in sql server?
What is an index in sql?
Explain raiserror in sql server?
Name some of the open source software that you can use in alternative to SSR?
What is collation sensitivity? Explain different types.
Which tools are available to manage SQL Azure databases and servers?
Explain SSRS Architecture?
What is the difference between drop table and truncate table?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
How do I install only the client tools of sql server 2000?
What are three major types of constraints?
How to insert multiple rows with a subquery?
What is implicit cursors?
Can you explain important index characteristics?
What is database isolation in sql server? : sql server database administration
