Benefits of Using Windows Server 2003 with SQL Server 2000
Published: April 24, 2003
The availability of Microsoft Windows Server™ 2003 introduces a new era of database computing for SQL Server users. Database applications on Windows Server 2003 can reach levels of reliability, security, availability, and scalability previously attainable only on mainframe systems.
The benefits in the table below are available for SQL Server 2000 using Windows Server 2003.
|
Improved CPU load-balancing and scheduling | | • | Better scheduling due to reduced resource lock contention. | | • | Enhances performance for multiprocessor systems (for example, four or more CPUs). |
|
Faster file system and improved input/output (I/O) performance | | • | Faster file allocation, resulting in significant improvements in database storage performance. Learn more about file services on the Windows Server 2003 site. | | • | Availability and performance improvements when using storage devices supporting multipath I/O. | | • | Enhanced storage management features improve performance. Learn more about storage management on the Windows Server 2003 site. |
|
Enhanced performance for Address Windowing Extension (AWE) applications | | • | Applications utilizing larger memory models on 32-bit systems can benefit from faster performance. |
|
Improved support for Fiber Mode | | • | Improvements in Windows Server 2003 Fiber Mode features permit faster application concurrency with SQL Server 2000 when SQL Server 2000 is run in "Fiber Mode." |
|
Integration with Volume Shadow Copy service | | • | Permits database-aware file system backups so that SQL Server and MSDE databases can be backed up at an exact point-in-time. | | • | Provides simplified management for consolidation scenarios where many databases and instances are hosted on one system. | | • | Useful for document, content, and media applications requiring synchronized metadata and content backups. |
For more information on Windows Volume Shadow Copy service, read the Volume Shadow Copy Overview on the TechNet site. |
Support for Intel Hyper-Threading Technology (HTT) | | • | HTT enables significant performance improvements in database operations compared with non-hyper-threaded processors. |
|
SQL Server 2000 Enterprise Edition (64-bit)
SQL Server 2000 (64-bit) is shipping simultaneously with Windows Server 2003 and provides support for very large enterprise workloads. SQL Server 2000 (64-bit) runs on the 64-bit versions of the Windows Server 2003 family. For more information, visit the SQL Server 2000 (64-bit) Product Overview page.
