CPU usage on SQL server
From: Meg (Meg_at_discussions.microsoft.com)
Date: 10/29/04
- Next message: Geoff N. Hiten: "Re: Maybe the Records Are There After All"
- Previous message: John Bishop: "Maybe the Records Are There After All"
- Next in thread: David Gugick: "Re: CPU usage on SQL server"
- Reply: David Gugick: "Re: CPU usage on SQL server"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 29 Oct 2004 07:51:03 -0700
Hi,
I have a quad processor clustered database server that is experiencing
significant performance problems. There are multiple user databases on ther
server, and the issues manifest themselves in different ways. We have had
users unable to save to a database to complete slow down of the whole server.
The issues seem to be more prevalent in the morning, but we have had them
throughout the day as well. In monitoring the CPU usage we noticed that most
of the activity is going through only 1 of the CPU's. CPU 0 can peak at 100%
utilisation, and the other 3 have little or no activity at all. There has
been no changes to any settings and the SQL Server install is pretty
standard. Does anyone have any ideas?
- Next message: Geoff N. Hiten: "Re: Maybe the Records Are There After All"
- Previous message: John Bishop: "Maybe the Records Are There After All"
- Next in thread: David Gugick: "Re: CPU usage on SQL server"
- Reply: David Gugick: "Re: CPU usage on SQL server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
