Activity overview
Latest activity by MarkTampa
Ended up bouncing the server that SQL Monitor is on and all is good now. / comments
Ended up bouncing the server that SQL Monitor is on and all is good now.
SQL Monitor not seeing SQL Server on 2 new servers in a AG Cluster
We are running 10.1.4 of SQL Monitor. We currently have 4 servers in a cluster for Availability Groups. I just added 2 new servers in SQL Monitor that used to be monitored by SQL Monitor but were...
The question becomes what type of errors are you getting? Is there a pattern to day of the week, time of day, specific servers? Could it be a network issue? A switch issue? We had this type of senario a few years back where SQL Mon kept telling us that a few of our SQL Servers were up and down over and over Fri at 10PM. After the pattern of two weeks in a row we got the network team involved and they found the issue with a switch going bad. / comments
The question becomes what type of errors are you getting? Is there a pattern to day of the week, time of day, specific servers? Could it be a network issue? A switch issue? We had this type of ...
UPDATE: We evicted the down server from the AG group and then SQL Monitor was able to monitor the 3 active servers just fine. / comments
UPDATE: We evicted the down server from the AG group and then SQL Monitor was able to monitor the 3 active servers just fine.
Monitor Error
Starting this weekend a group of AG group servers started getting random Monitor Errors all at the same time. There are 4 servers in this AG group and one of them died but the others are fine. Si...
At the current time I cannot upgrade to 10.1.8 as we just upgraded to 10.1.14. However, I will make a note of that and come back around to visit the upgrade. / comments
At the current time I cannot upgrade to 10.1.8 as we just upgraded to 10.1.14. However, I will make a note of that and come back around to visit the upgrade.
We are currently monitoring 11 different SQL Servers. The number of userids with 'sa' rights is different for all 11. So, I need to set the threshold different for each of them. / comments
We are currently monitoring 11 different SQL Servers. The number of userids with 'sa' rights is different for all 11. So, I need to set the threshold different for each of them.
Help with configuration of Custom Metric Principals with sysadmin login
I have downloaded and enabled this custom metric and configured it. However the number of 'sa' rights IDs at at each server is different. I cannot seem to find a way to have this alert be configu...
Needing a modified version of Job Failing alert
I have setup the Job Failing alert to alert us to failed jobs, however, it is alerting us of a LOT of failed jobs. I know that is a bad thing and that will be addressed soon. What I want to be no...
Jessica R said:
Hi @MarkTampa, Sorry to hear you're running into an issue! Can I just double check - is it disabled at the "all server" level? Can you please double check that it is disabled for all the desired level(s)? It is. However, Friday I was making changes to that and I think I may have stopped them from being raised via that. I will watch it and let you know if they keep coming. But, it does look like it has stopped them.
/ comments
Jessica R said:
Hi @MarkTampa,Sorry to hear you're running into an issue!Can I just double check - is it disabled at the "all server" level? Can you please double check that it is disabled fo...