Interested to Buy Any Domain ? << Click Here >> for more details...
How do you troubleshoot SQL Server if its running very slow?
- 2 Answers
- 12276 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain view in sql server?
Can truncate be rolled back?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Write a sql query to sort on different column name according to the parameters passed in the function?
whats new about truncate in sql server 2008?
Explain different types of lock modes in sql server 2000?
After removing a table from database, what other related objects have to be dropped explicitly?
Explain the etl (extraction, transformation, and loading)?
Explain what you mean by 3 tier architecture.
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is TDS(Tabular Data Stream) Gateway?
What is the use of commit?
What happens if strings are casted into wrong code pages in ms sql server?
What is tempdb database? : SQL Server Architecture
