Microsoft SQL Server 7'0 Optimization on Windows 2000 Advanced and Datacenter Server Donna Lambert S

1
Microsoft SQL Server 7.0 Optimization on Windows
2000 Advanced and Datacenter Server Donna
LambertSupport ProfessionalSQL Server
SupportMicrosoft Corporation
2
SQL Server 7.0 Clustering Why Cluster?

• All the benefits of Microsoft SQL Server
• High availability
• Static load balancing

3
Introduction to Microsoft Windows 2000
Datacenter Server and Microsoft Windows 2000
Advanced Server

• Part of the Windows 2000 Server family
• Provides additional functionality geared toward
  high performance systems

4
Installing SQL Server 7.0 on Windows 2000Windows
2000 Advanced Server and Windows 2000 Datacenter
Server
5
Small Changes in Procedure

• Mostly GUI changes Microsoft Management Console
  (MMC) and so on
• Account configuration in Active Directory

6
SQL Server 7.0 Requirements on Windows 2000
Advanced Server

• All the same physical requirements as Microsoft
  Cluster Service (MSCS)
• A separate physical disk for the quorum drive
• RAM 4 GB
• With Physical Address Extensions (PAE), Windows
  2000 Advanced Server can support more, but SQL
  Server 7.0 cannot use it

7
SQL 7.0 Requirements on Windows 2000 Datacenter

• Same as for general clustering and Windows 2000
  Advanced Server
• Only two nodes (DC supports up to four)
• RAM 4 GB
• Windows 2000 Datacenter Server supports more, but
  SQL Server 7.0 cannot use it

8
Performance Tuning?

• Tune as you would for a single server
• Same rules apply
• Normalize
• Streamline your queries
• Use stored procedures when possible
• Use indexes appropriately

9
General Performance Troubleshooting

• Analyze each node independently
• Benchmark, tweak, test, compare
• Perfmon is your friend

10
The Biggest Performance Issue

• Disk bottlenecks
• How to find them
• Counters to monitor
• How to avoid them

11
Second Biggest Performance Issue

• Memory
• SQL Server and Windows 2000 Server family
  self-tune
• Paging disk I/O
• Counters to monitor

12
Memory Watch for Failovers

• Provide enough physical memory on each node to
  support all resources combined
• Especially in active/active cluster configuration

13
Processor Performance

• General multi-CPU tuning
• Dedicated OLTP?
• Thread versus fiber

14
Service Packs

• Microsoft SQL Server 7.0 - SP2
• Microsoft Windows 2000 - SP1

15
Resources on the Web

• Windows 2000 Clustering Basics WebCast
• http//support.microsoft.com/servicedesks/webcast
  s/so_projects/socluster/soclusterblurb.asp
• Windows 2000 Datacenter WebCast
• http//support.microsoft.com/servicedesks/webcast
  s/wc092100/wcblurb092100.asp
• Database Normalization WebCast
• http//support.microsoft.com/servicedesks/webcast
  s/wc060600/wcblurb060600.asp
• (Note that the URLs should be entered as one
  line they are wrapped here for readability.)

16
More Resources

• SQL Server and Clustering Articles
• Q219264, Order of Installation for SQL Server
  7.0 Clustering Setup
• Q254321, Clustered SQL Server Do's, Don'ts and
  Basic Warnings
• SQL Server and Clustering White Paper
• How to Install SQL Server on Cluster Server Step
  by Step Instructions http//support.microsoft.com
  /support/SQL/Content/70Papers/70clstr.asp?LNEN-US
  SDgnFR0
• (Note that the URL should be entered as one line
  it is
• wrapped here for readability.)

17
(No Transcript)