• sqlactions (6/4/2012)


    Hi,

    Check out this blog, it may help you asses the current capacity limits of your 'model' and further be able to determine what resources you need to build the new server. May not be a complete solution but hope it would get you started.

    http://sqlactions.com/2012/05/15/collection-and-reporting-of-perfmon-data-for-sql-server-capacity-planning-and-trend-analysis

    Thanks!!

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html