|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Win Server 2003 SP2 - SQL2k5 Performance ImprovementsI have read that there will be SQL Server 2005 performance improvements in
SP2 for Windows 2003. Does anyone know the specifics on what will be improved? Thanks Hi
Just wondering where this was mentioned? The upgrade from windows 2000 to windows 2003 is advantagous because of the improvements in the underlying file hadling by the OS (I can't remember any quoted percentages but it was a very significant one!), and from http://www.microsoft.com/windowsserver2003/r2/whatsnewinr2.mspx it seems that additional work may have been done in this area, so speculatively that could be one reason amongst others! John Show quote "tcs" wrote: > I have read that there will be SQL Server 2005 performance improvements in > SP2 for Windows 2003. Does anyone know the specifics on what will be > improved? > > Thanks > > The upgrade from windows 2000 to windows 2003 is advantagous because of Right, there may be general improvements to hardware interaction etc., but I > the > improvements in the underlying file hadling by the OS (I can't remember > any > quoted percentages but it was a very significant one!), and from > http://www.microsoft.com/windowsserver2003/r2/whatsnewinr2.mspx it seems > that > additional work may have been done in this area, so speculatively that > could > be one reason amongst others! doubt applying Windows 2003 SP2 alone will have any *noticeable* performance improvements specifically targeted to any version of SQL Server, never mind a specific version... A Where did you read this?
Why would a Windows 2003 service pack address SQL Server performance? Maybe you meant/misread SQL Server 2005 SP2? A Show quote "tcs" <t**@discussions.microsoft.com> wrote in message news:7CE0A91F-459B-4197-A1BC-D977813CF09C@microsoft.com... >I have read that there will be SQL Server 2005 performance improvements in > SP2 for Windows 2003. Does anyone know the specifics on what will be > improved? > > Thanks > You can read the blog here:
http://blogs.technet.com/windowsserver/archive/2006/08/01/444365.aspx Performance improvements for SQL Server Service Pack 2 provides performance improvement for SQL Server 2005 under intensive workloads . These improvements are installed by default upon Service Pack 2 installation Show quote "Aaron Bertrand [SQL Server MVP]" wrote: > Where did you read this? > > Why would a Windows 2003 service pack address SQL Server performance? > > Maybe you meant/misread SQL Server 2005 SP2? > > A > > > "tcs" <t**@discussions.microsoft.com> wrote in message > news:7CE0A91F-459B-4197-A1BC-D977813CF09C@microsoft.com... > >I have read that there will be SQL Server 2005 performance improvements in > > SP2 for Windows 2003. Does anyone know the specifics on what will be > > improved? > > > > Thanks > > > > > > You can read the blog here: Well, unless you have an in with the windows and/or SQL teams, the best > http://blogs.technet.com/windowsserver/archive/2006/08/01/444365.aspx > > Performance improvements for SQL Server > Service Pack 2 provides performance improvement for SQL Server 2005 under > intensive workloads . These improvements are installed by default upon > Service Pack 2 installation you're going to get is speculation. *MY* speculation remains that they improved the way hardware/memory/CPU is utilized, and that this affects SQL Server is not solely intentional. In other words, DB2 or Oracle running on the same server might benefit in the same or similar ways. I will ask my contacts, but it is doubtful any non-NDA information will be repeated here... A From the horse's mouth:
"the change is in winsock API and it is more perceivable on SQL workloads running with > 8 CPUs + multiple NICs. It will not be noticeable/measurable on other configurations." Keep your eyes peeled because it may require more than just Windows Server 2003 Service Pack 2 on its own to have an impact anyway. A  |
|||||||||||||||||||||||
Other interesting topics