Post reply

Management data wareouse performance issues??

  • May 26, 2014 at 5:40 am

    #285865

    Hi Experts,

    We are planning to enable MDW on the production servers, however I am worried regarding the performance issues on production servers due to MDW as the management has asked me to install it on all the production servers (no reporting server).

    Is there any link or document which can tell me whether I should enable it on the production servers or no?

    Regards,

    Ashif Shaikh

  • May 26, 2014 at 6:06 am

    #1716469

    Have you tested it out in a test environment? Was there a noticeable performance degradation? Have you had reliable reports of performance degradations caused by MDW?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 26, 2014 at 6:39 am

    #1716474

    yes, currently I am testing it on the test env. However I do not see any performance degradation in memory or CPU processing except high I/O activity on the drive where the MDW database is located.

    I haven't received any call from users as far as the performance issue is considered...

  • June 2, 2014 at 4:07 am

    #1718138

    A lot of space in the MDW can be taken for system objects. I suggest you look at http://support.microsoft.com/kb/2793580 to see how to exclude system objects.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • June 2, 2014 at 5:51 am

    #1718163

    Thanks

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

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