At first I thought it was just me, but has anyone else noticed that SQL 2005 suffers a performance hit when you install Windows Server 2003 SP2?
Since SP2, memory and hard drive usage has gone through the roof on a number of servers I use. It may just be coincidence... but it seems unlikely.
We are running one of our production clusters on Windows Server 2003 x64 SP2 and SQL Server 2005 x64 SP2 (Build 3159) without any trouble.
We also recently upgrade our development servers to Win2K3 x64 SP2 and SQL Server 2005 x64 SP2 (Build 3175) again without any issues so far.
Which build of SQL Server are you running?
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
|||I think really just coincidence. Can you reccomend is the first step to diagnosing a SQL 2005 server's performance issues?|||Here are a couple of blog posts that might help:
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!526.entry
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!356.entry
|||Nice posts, thanks Glenn.
No comments:
Post a Comment