SQL monitor consumes more Resources

cloudsupport

Hi Team,
We configured Redgate Monitoring tool for our environment. We are using Azure managed Instance
We can't able to expand alerts. 
It's consuming more resources It's impacting to our production.
Please give solution for this.

Jon_Kirkwood

Hi there,

Thank you for reaching out on the Redgate Forums and asking about some performance concerns with SQL Monitor.

Are you able to provide some more insight into how you have SQL Monitor setup, 

Are you using the MI as a data repo / monitored environment - or both?

Can you please confirm the resources usage by SQL Monitor? 

I don't believe we have actual guideline values for Azure MI but we do have some details around Azure SQL & elastic pools which can be viewed at the link below

SQL Monitor Infrastructure - hardware & performance guidelines

Can you review and verify that your system hardware meets the recommendations?

Jon_Kirkwood

.

Jon_Kirkwood

.