September 25, 2006 at 8:29 am
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.
September 26, 2006 at 9:14 am
Profiler is running by default. Turn of the trace and profiler and the processor time should return to normal.
Joshua Perry
http://www.greenarrow.net
September 27, 2006 at 1:37 am
Hi Joshua,
Thanks for the reply, however we are not running the profiler or trace.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply