Post reply

Server Review

  • April 2, 2013 at 6:39 am

    #272698

    What are the things we need to consider for reviewing a windows server keeping SQL server as our point of interest.

  • April 3, 2013 at 7:15 am

    #1603136

    First of all what do you mean, capacity for existing?, capacity planning for new? Also, what version of Windows, what version of SQL Server?

  • April 3, 2013 at 7:25 am

    #1603141

    Capacity for existing

  • April 3, 2013 at 7:27 am

    #1603142

    windows 2008 r2 and sql 2008r2

  • April 3, 2013 at 7:28 am

    #1603144

    You can view Task Manager for CPU usage and there are some good monitoring tools to graph that over time to see if you are maxing the box at high usage parts of the day/night. Memory, the more the better, (if you are 64 bit)..... Database sizing, only you will know what dbs you have in SQL Server and know the growth pattern to know if you will need more space over then next 12 months to 4 years. You can run profiler to capture longer running SQL statements to see if you can add tuning indexes to make it run more efficiently.

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

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