Clustered SQL Server with High CPU usage

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Clustered SQL Server with High CPU usage

Author

Topic

rikleo2001
Posting Yak Master

185 Posts

Posted - 2008-08-29 : 05:35:40

Hi

I am currently facing HIGH cpu usage on one of the SQL Server, above 50% constant from last 5 days it goes up and down.

Here are configurations
SQL Server 2000 Ent
Clustered
One default instance and 2 Named instance
CPU 8 (Shared for all instances) (Intel Xeon(tm) mp 2.70ghz
Memory 16 GB (Default shared)

Tempdb 7 only with mixture size (between 128 MB to 256 MB) I will looking into adding one more tempdb to mach cpu COUNT.

Here is general output of sysprocesses which are runnable

SPID kpid blocked waittime lastwaittype waitresource
------ ------ ------- ----------- -------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
78 8048 0 0 PAGELATCH_SH 2:6:345
80 7872 0 0 PAGELATCH_UP 2:6:345
88 1204 0 0 PAGELATCH_SH 2:6:345
89 7104 0 0 NETWORKIO
100 6900 0 0 CMEMTHREAD
133 5676 0 0 PAGELATCH_SH 2:6:345
165 4360 0 0 PAGELATCH_EX 2:5:593
172 3932 0 0 PAGELATCH_UP 2:6:345
175 6964 0 0 PAGELATCH_UP 2:6:344
186 7944 0 0 NETWORKIO

I also found few deadlocks which keeps apprearing on differant times (I guess due to high CPU usage)

I checked through profiler and perfmon, but didn't find a valid reason for high CPU usage..
Please help me to resolve this issue..

Many Thanks in advance..

SKR

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2008-09-04 : 14:19:37

Not sure if this is related, but we've been having a similar issue recently. We have a website with a box, where a search can be entered. Behind the scenes we have turbosql running (performing full text search i believe). For some reason, when someone entered a one character word or a number, it caused a spike in CPU for a long time (80%) and some errors in the log. We had to change the stored procedure to just ignore the one character inputs, but have no idea why this is happening.

Also, are there any jobs running during the time you have the CPU spike?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources