Interested to Buy Any Domain ? << Click Here >> for more details...
How do you troubleshoot SQL Server if its running very slow?
- 2 Answers
- 12243 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
How can you tell if a database object is invalid?
What do you understand by physical_only option in dbcc checkdb?
How the authentication mode can be changed?
Can we write a distributed query and get some data which is located on other server and oracle database?
How to view existing indexes on an given table using sys.indexes?
What is a partition function in sql server?
What is sql server profiler?
What are system databases into sql server (2005/2008)?
Can we write trigger for view?
can you implement data mining in SSRS?
Explain primary key in sql server?
How can I change procedure name in sql server?
What are translations and its use? : sql server analysis services, ssas
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
what is sql server? : Sql server database administration
