SQL Srvr 2k on Win2003 upgrade to SP4

[aalmeida]

Folks,

we upgraded some of our servers to SQL SP4 and noticed some increase in the CPU ussage. Does any one know how to fix this issue? did anyone else found any other issues with SP4?

AL Almeida
Senior DBA

http://www.saxotech.com/

"May all those that come behind us, find us faithfull"

 

[mrdenny]

There are come quirks with SP4. Browse the forums, we've discussed a bunch of them. Have you been able to identify which processes are taking the extra CPU power?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[aalmeida]

Yes: sqlsrvr.exe is using 65% of the CPU and prior to the upgrade was using 42% ( the % values are average)

is there a reason and a fix for this? this is having a great impact on server performance.

I dd browse the forums by the way, I just wanted to know more that's all.

AL Almeida
Senior DBA

http://www.saxotech.com/

"May all those that come behind us, find us faithfull"

 

[mrdenny]

What processes within SQL are taking more resources? Any specific queries, processes, jobs, data loads?

You could have fraggmented indexes, query plans that are shot, etc.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[aalmeida]

Yeah, that's a good point. I actually thought of that and had compared the histories before and after and nothing stood out. The only difference in the SQL server was the SP4 instead of SP3.

AL Almeida
Senior DBA

http://www.saxotech.com/

"May all those that come behind us, find us faithfull"

 

[mrdenny]

I haven't seen anything on SP4 where it uses more CPU for no specific reason.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com