none
Performance and data werehouse

    Question

  • Hello! 
    How enabling data warehouse affects on performance of the SQL server and what recommendations exists about it?
    Thank you!

    Wednesday, September 25, 2013 7:58 PM

Answers

  • Are you referring to the Management Datawarehouse that comes with the Data collector ?

    In that case it does not affect ther server significantly. If you are collecting data from many different servers, I would recommend to place the managementdw database on separate disk and be carefull with the retention period.

    Regards

    Rasmus Glibstrup
    http://blog.sqlguy.dk

    • Marked as answer by Mike Solovey Sunday, April 06, 2014 1:27 PM
    Tuesday, March 04, 2014 8:35 PM