Query about SQL server monitoring pool configuration

Question

Hello all,

Our environment consits of 5 managemnet servers in SCOM 2019.

Server 1 , server 2 - Dedicated for agent monitoring.
Server 3 - Azure Monitoring and VEEAM Vmware monitoring.
Server 4 - Network device monitoring
Server 5 - ACS collector server.

Currently all are part of SQL Server monitoring resource pool

Is it mandatory to keep all the management servers as a part of this resource pool ? if so what is the justification ?

If not , can we remove server 4 and server 5 from this resource pool ?

Regards,
Sushanth S K.

Answer 1

Hi @Sushanth S K ,

If you have dedicated management servers (like 3, 4 and 5) you need to exclude those from the "SQL Server Resource Pool" as the SQL MP related workflows will also be spread amongst those servers if they are part of the resource pool.
So, this means that it makes sense that you have only Server 1 and Server 2 in your SQL resource pool, as those two servers are used for agent monitoring...

Here are my favourite sources regarding ressource pools, which you might find intersting:

Understanding SCOM Resource Pools
https://kevinholman.com/2016/11/21/understanding-scom-resource-pools/

Resource pool design considerations
https://learn.microsoft.com/en-us/system-center/scom/plan-resource-pool-design?view=sc-om-2022

and

How to manage resource pools
https://learn.microsoft.com/en-us/system-center/scom/plan-resource-pool-design?view=sc-om-2022

I hope I was able to answer you question.

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Stoyan Chalakov