SQL Server Utility (UCP) vs Management Data Warehouse (MDW)

  • Hoping someone can provide some clarification. My understanding is that these are two *different* technologies that both provide some degree of monitoring target SQL Servers. Yet they both use shared Data Collectors on the instances, and don't appear to both be able to run side by side...

    Is it true I can only enroll an instance in either Utility or MDW but not both?

    Any insight into which I should choose? MDW seems to have a lot more granular information than UCP - any advantage to using the latter? (note that I only have about 20 SQL Server instances of 2008 to 2012 if that's a consideration for which one I choose)

  • I haven't worked with it much, but from what I know and read, it seems UCP is the evolution of MDW in some ways. It's more for control than it is for long term analysis and monitoring.

    However the UCP page says that non-UCP data collection items can still run. I'd guess that's the case.

    UCP is only v10.5 or greater, so if this is an issue, I'd stick with MDW.

Viewing 2 posts - 1 through 1 (of 1 total)

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