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

Loading...

PPT – Microsoft SQL Server 7'0 Optimization on Windows 2000 Advanced and Datacenter Server Donna Lambert S PowerPoint presentation | free to view - id: 1ecc48-ZDc1Z



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

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

Description:

Microsoft SQL Server 7.0 Optimization on Windows 2000 Advanced and Datacenter Server ... 7. SQL 7.0 Requirements on Windows 2000 Datacenter ... – PowerPoint PPT presentation

Number of Views:33
Avg rating:3.0/5.0
Slides: 18
Provided by: supportM
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: 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)
About PowerShow.com