Post reply

Capacity Planning

  • November 8, 2012 at 9:43 am

    #284543

    Hi All,

    I was asked to do capacity planning of SQL 2005 & 2008 servers. What are some of the things you need to look into.

    If you guys have any scripts which can capture the necessary information....please provide.

    Thanks,

    SueTons.

    Regards,
    SQLisAwe5oMe.

  • November 9, 2012 at 4:58 am

    #1557562

    Some of the info I gather on a central reporting server are about: disk space, db size (mdf, ldf), memory usage, I/O, network, CPU, user sessions. Easiest way for me was using powershell and setting the ps script as a sql job.

  • November 21, 2012 at 9:27 am

    #1561296

    bjcharles (11/9/2012)

    Some of the info I gather on a central reporting server are about: disk space, db size (mdf, ldf), memory usage, I/O, network, CPU, user sessions. Easiest way for me was using powershell and setting the ps script as a sql job.

    Do you mind sharing the powershell script?

    Thanks,

    SueTons.

    Regards,
    SQLisAwe5oMe.

  • November 22, 2012 at 3:38 am

    #1561570

    I have adapted the script significantly, so i think the right thing to do is to point you to the original post that got me going years ago ( big thanks to Chad Miller):

    http://www.sqlservercentral.com/articles/powershell/68011/

    This way, you will understand how it works and decide if using powershell is right for you.

    Cheers

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply