How do you troubleshoot SQL Server if its running very slow?
Answers were Sorted based on User's Feedback
Answer / guest
First check the processor and memory usage to see that
processor is not above 80% utilization and memory not above
40-45% utilization then check the disk utilization using
Performance Monitor, Secondly, use SQL Profiler to check for
the users and current SQL activities and jobs running which
might be a problem. Third would be to run UPDATE_STATISTICS
command to update the indexes
Is This Answer Correct ? | 5 Yes | 3 No |
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 |
Explain Capacity planning to create a database? and how to monitor it?
How to use values from other tables in update statements in ms sql server?
Can we use having clause without group by?
Mention the different authentication modes in sql server.
How to get the definition of a view out of the sql server?
What are transactions in sql?
What are sql dirty pages?
Can we check locks in database? If so, how can we do this lock check?
how can we use a composite key for two tables and how can we represent it
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is a constant or literal in ms sql server?
What is 5nf in normalization form?