How do you troubleshoot SQL Server if its running very slow?
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
When I delete any data from a table, does the sql server reduce the size of that table?
What is subquery? Explain the properties of a subquery?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Explain a differential backup?
Can you explain important index characteristics?
How much is a sql server license?
What are the different sql server versions?
Does full backup break log chain?
Can we use having clause without group by?
What are the differences between char and varchar in ms sql server?
How will you add a dimension to cube? : sql server analysis services, ssas
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Explain throw statement in sql server 2008?
What is scan table/view and seek table/view when its occurs? : sql server database administration
What is the difference between for xml raw and for xml auto?