Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
naglav
Starting Member
2 Posts |
 Posted - 2002-05-14 : 06:49:57
|
| Hi,Some times my Database server is showing high CPU load (99%). When I check for the number of users, the number is not really much and found that only MSDB database is using more physical io. Could anybody suggest me what are the areas I need to look into?Thanks in advance. |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-14 : 11:20:42
|
| I take it this is an OLTP server, and you are not running any OLAP services on it. A single user can redline the processors just by processing a cube.If you are seeing a high CPU load, you probably have some process or user moving a lot of data. Check the users and application columns during the load (In EM this is under Current Activity). A poorly written query, DTS package, or stored procedure could be the culprate. Also see if you can link it to a particular application. Access users, for instance, occasionally pull down entire tables when a small subset would do.Also check your Process Info to see whether there is blocking during this activity. If there is, that should help isolate the guilty party.If the CPU spike happens on a regular basis, you may want to check your maintenance plans and scheduled jobs to see if one of them could be causing the problem.Odds are, there is a process out there guilty of grabbing a lot more data than it needs, or at least pushing it around in ways that are unnecessary.Happy Hunting. |
 |
|
|
|
|
|
High CPU load