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
- 9743 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 distinction amongst delete and truncate?
What is normalization? What number of normalization shapes are there?
What is the use of partition by in sql server?
How to create a new table in a given schema?
What are the difference between clustered and a non-clustered index?
How to throw custom exception in Stored Procedure?
What are the features of Embedded SQL
What is user-defined functions? What are the types of user-defined functions that can be created?
Define Wed Edition in SQL Azure?
What do you understand by integration services in sql server?
How do I find my localdb version?
What is the difference between ddl,dml and dcl commands?
Name 3 ways to get an accurate count of the number of records in a table?
What is sqlservr.exe - process - sql server (sqlex?press)?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
