1 / 12

Expert Tips for SQL Server 2000 Clustering Implementation

Learn the key steps and best practices for setting up a robust SQL Server 2000 cluster on Windows 2000, including hardware recommendations, network setup, and failover testing. This guide covers installation, configuration, and management using Enterprise Manager and Cluster Administrator.

gilbertosmith
Download Presentation

Expert Tips for SQL Server 2000 Clustering Implementation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server 2000 Clustering Dave Fackler

  2. Agenda • Windows 2000 Clustering • SQL Server 2000 Clustering • Implementation Tips

  3. Windows 2000 Clustering • Shared disk approach • Windows 2000 Advanced Server • Two nodes • Four nodes possible with Data Center • Install using Cluster Service • Manage using Cluster Administrator • Resources • Groups

  4. “Standard” Win2K Cluster

  5. SQL Server 2000 Clustering • SQL Server 2000 Enterprise Edition • Install using SQL Server Setup • Create virtual server • Single instance or multi-instance (not active-passive or active-active) • Manage using Enterprise Manager

  6. Single Instance SQL2K Cluster

  7. After Failover

  8. Multi-Instance SQL2K Cluster

  9. Implementation Tips • Plan, plan, plan! • Plan shared disk space • Nothing should go on the Quorum drive • Recommend RAID-1 for Quorum • Recommend RAID-10 (or at least RAID-5) for SQL database files • Recommend RAID-1 for SQL log files • Need at least 2+2+3=7 drives! • Don’t skimp on hardware

  10. Implementation Tips • Plan, plan, plan! • Plan network setup • Public network IP addresses for cluster nodes, the cluster itself, and each SQL Virtual Server • Private network for cluster nodes • WINS and DNS services running • Create service accounts beforehand • Don’t forget MSDTC setup

  11. Implementation Tips • Test, test, test! • Cluster failover • Hardware failures • Network cards and cables • Shared disk arrays and cables • Entire node shutdowns • SQL Server and application failures

  12. Agenda • Windows 2000 Clustering • SQL Server 2000 Clustering • Implementation Tips • But wait… what about Analysis Services, DTS, etc? • All possible, but another presentation…

More Related