SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Tuning and Sizing Windows 2000

By Steve Jones,

Tuning and Sizing Windows 2000 for Maximum Performance

by Curt Aubley

5 Stars -

I had been having problems with our Cold Fusion web server and was trying to determine the best way to tune the server. I picked up another book from MS Press (review coming soon) on tuning Windows 2000, but I was not thrilled with it. While I was digging through that book, my boss dropped this one on my desk and asked me to take a look and see what I thought.

I started reading this book and within 5 minutes had learned a couple things. The first chapter immediately presents a few tools that can assist in performance tuning, a few of which I had not heard about. It also immediately presents in a concise table a few performance counters and how they can help detect bottlenecks.

As I glanced through the chapters on memory and disk systems, the author describes the technologies in use today and how they affect performance of a Windows 2000 server. The author also spends the latter half of each chapter providing good step-by-step methods for tuning a system. There is a good use of charts with quick reference information and screen shots of performance monitor screens.

The book ends with sections devoted to tuning a server specifically for the various MS applications that are available (SQL, Exchange, File Server, Web Server, Backup Server). I think this is a great book for anyone using Windows 2000, including DBAs. Even if you do not have control of the OS for your SQL Server, this book can help you understand why your server performs as it does.

Steve Jones
©dkRanch.net February 2001

Return to Steve Jones Columnist Home

Total article views: 3522 | Views in the last 30 days: 0
Related Articles

PASS Performance Virtual Chapter’s 2015 Performance Palooza - TOMORROW! - 7/23

PASS HEADQUARTERS: The PASS Performance Virtual Chapter’s 2015 Performance Palooza is tomorrow...


I’m speaking for the Performance Virtual Chapter of PASS

On January 4, I’m speaking about index internals for the Performance Virtual Chapter of PASS (http:...


Speaking at SQLPASS Performance Virtual Chapter Winter 2012 Performance Palooza

I am pleased to announce that I am speaking Thursday, December 6, at the SQLPASS Performance Virtual...


SQL Server 2000 on Windows Server 2000 or 2003

improvement of SQL Server 2000 performance on Windows 2003


PASS Virtual Chapter Events : November 2013

  Join SQL Server professionals from around the world for free online technical training and networ...

book reviews