How do you troubleshoot SQL Server if its running very slow?
- 2 Answers
- 11218 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / abc
we can check for the cpu utilization from the task manager
and if it above 80% then we have to check the status of
indexes or we can say we have to recreate the statics as
well as indexes.
there are many other factors but in production servers
indexing causes a great performance enhancement.Also we
have to check whether large I/o operations are not
hindering the performance.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the use of RDBMS?
Define self join?
What new data source types were added in ssrs 2014?
How to create user messages with print statements in ms sql server?
What is dirty read?
Is it possible in sql table to have more than one foreign key?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
Explain what is the use of custom fields in report?
What is apply operator in sql?
What do you mean by tablesample?
Explain sql server service broker?
What is the use of custom fields in report?
explain the storage models of olap? : Sql server database administration
What is co-related sub query?
What number sorts of privileges are accessible in sql?
