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
- 9929 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 the difference between executequery () and executeupdate ()?
What are the properties of the transactions?
How to list all stored procedures in the current database using ms sql server?
How does index makes search faster?
How to use subqueries with the exists operators in ms sql server?
What is table-valued sub query?
What are tables in sql server?
Can a rule be bound to any column of any data type?
Difference between aggregate functions of sql?
Explain about temporary stored procedure?
How to remove duplicate rows from table?
What is Federation and Federation Member?
What is data source document?
Do you know how to implement service broker?
Write a SQL query to delete a table?
