Higher CPU utilization with SQL Server 2005

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 2005 Forums

SQL Server Administration (2005)

Higher CPU utilization with SQL Server 2005

Author

Topic

arupkumarm
Starting Member

5 Posts

Posted - 2007-01-16 : 05:35:01

HI
I am facing a strange problem with SQL Server 2005 . The CPU utilization with SQL Server 2005 is higer by about 70% comapared to SQL 2000.

In the same kind of Hardware and with the DB server up , I performed the following tests
Declare @i int
Set @i = 10
While @i < 100000
Begin
Insert into arup_emp values(@i,'M',0)

Set @i = @i + 1
end

The CPU utilization average on SQL 2005 was 45% and on SQL 2K it was just 25% , I am seeing a lot of people who seems to be facing this problem but unfortunately not seeing any solution to this.

Can anyone through some light .
Please note that I have tried to also see the MAXDOP options, but get the same results.

Please help.

Thanks
Arup

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2007-01-16 : 07:30:42

Have you got a multi-cpu server? Is SQL only "seeing" one CPU?

arupkumarm
Starting Member

5 Posts

Posted - 2007-01-16 : 08:01:56

Hi
Yes I am on a 4 CPU machine . I have used the MAXDOP option set to zero and tried out the same . But seems like it gives the same result.

Help on this will be much appreciated.
Thanks
Arup

peterlemonjello
Yak Posting Veteran

53 Posts

Posted - 2007-01-16 : 08:55:38

Are statistics up to date?

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2007-01-16 : 08:59:35

Was the SQL Server 2005 database created from scratch? Or was it converted from SQL Server 2000?

If it was converted, is it in 9.0 compatability mode and have the indexes been rebuilt?

I saw similar problems on a converted database. After we put the database in 9.0 compatability mode and rebuilt all the indexes the problem went away.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources