SQLServer slows down after some time
From: Sophie Guo [MSFT] (v-sguo_at_online.microsoft.com)
Date: 01/06/05
- Next message: Henry: "Re: Performance degraded after DBCC DBReindex"
- Previous message: AnthonyThomas: "Re: SHOWCONTIG and Locks"
- In reply to: Stingray: "RE: SQLServer slows down after some time"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 06 Jan 2005 02:21:14 GMT
Hello John,
Thanks for your message.
I truly understand the inconvenience this has brought you. However,
identifying the causes of a performance issue is typically very time
consuming, and you may spend several days evaluating the collected
information. The complexity of the performance analysis is not specific to
a particular database product or operating system. All applications are
subject to performance constraints because of resource, design, or usage
factors.
To troubleshoot this issue, there would be several other things to try and
to check. However, as this is an issue that happens randomly, we may spend
extensive time to narrow it down since random issues are always hard to
troubleshoot.
To help identify and troubleshoot the problem, when the issue occurs,
please perform the following steps:
1. When the issue occurs, check error log to see if there is any related
events.
To view the SQL Server error log
============================
a. Expand a server group, and then expand a server.
b. Expand Management, and then expand SQL Server Logs.
c. Click the SQL Server Log to view. Error log details appear in the
details pane.
2. Temporarily move tempdb to a different hard drive to test.
Please refer to the steps of "Moving tempdb" in the following article:
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=KB;EN-US;224071
If the issue still exists, continue with the steps in the following article
298475 to collect information:
HOW TO: Troubleshoot Application Performance Issues
http://support.microsoft.com/?id=298475
Note If you do not collect this information when the performance problem
occurs, you may have to gather all the information again. This can delay
the troubleshooting process.
The probably cause of the issue is Blocking. I recommend you pay more
attention to the following article:
INF: How to Monitor SQL Server 2000 Blocking
http://support.microsoft.com/kb/271509/EN-US/
If this issue is urgent, please submit a case to contact our Product
Support Service(PSS), and our support professionals will work on with you
closely for a quicker resolution.
I look forward to hearing from you.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
- Next message: Henry: "Re: Performance degraded after DBCC DBReindex"
- Previous message: AnthonyThomas: "Re: SHOWCONTIG and Locks"
- In reply to: Stingray: "RE: SQLServer slows down after some time"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
