Query about SQL server monitoring pool configuration

Sushanth S K 146 Reputation points
2022-04-08T08:25:22.233+00:00

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.

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,444 questions
0 comments No comments
{count} votes

Accepted answer
  1. SChalakov 10,371 Reputation points MVP
    2022-04-13T09:41:53.397+00:00

    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


0 additional answers

Sort by: Most helpful