Interested to Buy Any Domain ? << Click Here >> for more details...
How do you troubleshoot SQL Server if its running very slow?
- 2 Answers
- 12279 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 are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Please illustrate physical database architecture? : SQL Server Architecture
How do I find the port number for sql server?
What is the correct order of the logical query processing phases?
How to provide default values to function parameters?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is unpivot?
What are the differences between stored procedure and view in sql server?
How to enable tcp/ip protocol on a sql server?
Tell me about pre-defined functions of sql?
How do you make a trace?
ow to bring suspect mode datbase online from scratch
Explain multiserver query
How to get the number of affected rows?
what is a join and explain different types of joins? : Sql server database administration
