MSSQL UCP

Question

Hello colleagues

these day I am trying to fight MDW and UCP in MSSQL but there is some conflict between the databases for each of them. I have several servers with data collections running with centralized MDW. For each monitored server I have created separate MDW database to speed up the reports (In one big DB the queries where totally slow and reports were sluggish). To be honest I was not sure if it can run like this but it does. The problem of this solution is that UCP cannot be uconfigured here because its collection uses the DB configured in MDW but the reports are connected to the database configured by UCP. Is there any way how to separate it? What I know, there is a configuration in msdb that says MDW has its own DB and UCP its own but the collection is mismatched somehow.

Answer 1

Hi,

Your question is outside the scope of this Community.

Kindly repost your question in the TechNet SQL Server Forums.

https://social.technet.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

"MSDN SQL Server Forums"

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

TechNet Forums:

https://social.technet.microsoft.com/Forums/en-US/home

MSDN Forums:

https://social.msdn.microsoft.com/Forums/en-US/home

Cheers.