topic SQL 2005 Ent. Hogging processor time in Windows Server 2003

SQL 2005 Ent. Hogging processor time

Robin Geary — Mon, 25 Sep 2006 10:00:23 GMT

Hi,
We have recently tested upgrading our web service from sql 2000 to 2005 sp1. The upgrade went smoothly enough, however we now have the problem of the sqlserver.exe process taking 90-100 % of the processors time.

We have 6GB available and we are running the enterprise editions of Windows 2003 and SQL 2005.

Machine specs,

DL380 G2, 2 X 2.8 Ghz Zeon, 6GB ram, Raid 5, database partition of 140 GB, Log partition of 35 GB.

Db is 25 GB, Log is 12 GB. Largest table has 32 million rows.

Any help would be greatly appreciated.

Re: SQL 2005 Ent. Hogging processor time

Jon Finley — Mon, 25 Sep 2006 12:08:32 GMT

See if the following article might help you narrow the cause down some:
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

Jon

Re: SQL 2005 Ent. Hogging processor time

Igor Karasik — Mon, 25 Sep 2006 14:13:50 GMT

You can find some useful tips for sql 2005 performance here:
"Lessons learned from upgrading from SQL 2000 to SQL Server 2005 "
http://rentacoder.com/CS/blogs/real_life_it/archive/2006/04/28/477.aspx