Tool - for capacity planning in SQL Server 2005

Posted on 2010-01-08
Last Modified: 2012-05-08
Dear DBA experts,

Am looking for a good tool for Capcity Planning in MS SQL Server 2005
for monitoring & estimating memory configuration for new servers.
Bascially I need to measure CPU,IO,MEM utilization on various existing  SQL servers
and make a statistical report  (excel sheet or a graph ) on daily/weekly/monthly basis
and also note peak times.

I would really appreciate if anyone can suggest me a good script both at OS and Server level
or suggest me a good tool to gather all this information, so that i suggest management
the New Hardware configuration required.

Question by:KishoreAdurty
    LVL 11

    Expert Comment

    cheap way is perfmon.  it can monitor all you want, and can do it remotely.  it also does graphs.
    LVL 5

    Accepted Solution

    I agree that using perfmon is the way to know what your instance is doing. It is up to you to turn that into capacity projections. If you want some of the heavy lifting done for you, try PAL. It takes perfmon output and cooks the data. It is free and was written by  MS employee Clint Huffman.

    There is a podcast interview with the author on RunAs Radio.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now