Currently using Windows 2000 AS and SQL 2000 EE. Would we get any
performance benefits if we upgrade the OS to Windows 2003 ? If so , what are
the benefits if any with regards to SQL ServerTry this URL
http://www.microsoft.com/sql/techinfo/planning/winsvr2003benefits.asp
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23PaMDpMlDHA.684@.TK2MSFTNGP09.phx.gbl...
> Currently using Windows 2000 AS and SQL 2000 EE. Would we get any
> performance benefits if we upgrade the OS to Windows 2003 ? If so , what
are
> the benefits if any with regards to SQL Server
>|||In article <#PaMDpMlDHA.684@.TK2MSFTNGP09.phx.gbl>, "Hassan" <fatima_ja@.hotmail.com> wrote:
>Currently using Windows 2000 AS and SQL 2000 EE. Would we get any
>performance benefits if we upgrade the OS to Windows 2003 ? If so , what are
>the benefits if any with regards to SQL Server
>
I don't recall exactly where, but there was a review written recently that
indicated an average 20% performance increase just from upgrading an existing
Win2k SQL 2k box to Win2003.
Apparantly, this had to do with VASTLY improved file i/o and network interface
implementation.
Anyone here rmember this review and/or have the link to it?|||Hi,
Here's a list of what is changed:
http://www.sql-server-performance.com/operating_system_tuning_w2003.asp
--
Regards,
Kristofer Gafvert - IIS MVP
http://www.ilopia.com - FAQ & Tutorials for Windows Server 2003, and SQL
Server 2000
Reply to newsgroup only. Remove NEWS if you must reply by email, but please
do not.
Problems with spam and viruses? See
http://www.ilopia.com/security/newsposting.aspx
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23PaMDpMlDHA.684@.TK2MSFTNGP09.phx.gbl...
> Currently using Windows 2000 AS and SQL 2000 EE. Would we get any
> performance benefits if we upgrade the OS to Windows 2003 ? If so , what
are
> the benefits if any with regards to SQL Server
>
没有评论:
发表评论