Ask a questionAsk a question
 

AnswerSizing for MAPS database

  • Tuesday, May 12, 2009 4:35 PMMike.Brannigan Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I need to place a machine onto a clients network to perform some stats gathering for a potential Hyper-V implementation to virtualise a number of their servers.  The machien once on the wire will be left unattened for a month to ensure we capture the entire business cycle.
    Is there anyway of knowning how big the SQL databse will get to ensure we spec the PC correctly.
    There are approximatly 50 servers to be monitored.

    Regards

    Mike

Answers

  • Tuesday, May 19, 2009 4:29 PMJay SaulsMSFTUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Mike, sorry for the late reply... 

    For 50 servers, you won't exceed the 2GB database file size limit on SQL Express running over a month of perf collection.

All Replies