What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning
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
How many types of functions are there in sql server?
What is meant by indexing?
please differentiate between delete and truncate?
Is the log file is a part of file group?
What is dbcc updateusage?
How to view existing indexes on an given table using sys.indexes?
Do you think BCNF is better than 2NF & 3NF? Why?
If the job running very slow what is the action you do
How to call a function from a stored procedure in SQL Server ?
Explain about Joins?
What are the requirements for sql server 2016?
What is set nocount on?
Explain SSRS Architecture?
what is normalization? : Sql server database administration
What are the restrictions while creating batches in sql server?