Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: 3521 | Views in the last 30 days: 0
 
Related Articles
BLOG

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:...

BLOG

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...

FORUM

SQL Server 2000 on Windows Server 2000 or 2003

improvement of SQL Server 2000 performance on Windows 2003

BLOG

PASS Virtual Chapter Events : November 2013

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

BLOG

PASS Virtual Chapter Events : November 2013

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

Tags
book reviews    
reviews    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones