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
- 9912 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
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Explain about sql server login?
Explain sql delete command?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
How to get nth highest salary from employee table.
What are indexes in ms sql server?
What is dbcc?
How to check status of stored procedure in sql server?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What are Row versions of DataRow?
what is a schema in sql server 2005? : Sql server database administration
When cursors are useful?
What does executeupdate return?
Which is better statement or preparedstatement?
What is the difference between cartesian product and cross join?
