Activity overview
Latest activity by jtrumbul
Hello Alex,
Thanks for the prompt response. I am sorry for the delay in my response, as we had a holiday at the office and for once in my life as a DBA i got to sleep a bit.
Here are the answers to your questions:
I am currently running SQL Monitor 5.0.7.2391 My apologies, I thought i posted my version in the initial post.
What I meant by my setup details is this:
Server A->RG BaseMonitor->IIS->RGWebUI->SQLServer->RedGateDb
Server B->AG1 being monitored. There is a single database on a single SQL instance that is the primary DB of AG1. Subsequently there is another server Server C-> with the secondary which is a read only replica of the AG
That is on the servers / AG being monitored no parts of SQL monitor are installed there. Does that paint a more clear picture?
The last question about removing system databases, I was more just asking what the standard practice is. For example, I do not see a reason to monitor the "Model" system DB. If it were to go down, we would know about it in other ways rather than constant pinging to see if its alive. I know in SQL Monitor I can add the instance names to monitor. i.e. SERVERBSQLNAMEDINSTANCEFOODBBar as opposed to adding the AG where all the databases including system on that instance get pulled in. I was more just asking what common practice was, and if there was any noticeable difference to doing things this way?
The script and tool would both be great. I am not sure which i will use. The script, only if I am planning on adding a database back one at a time ignoring the system databases. The tool is likely the way I will go. That is once I add back the other servers I need to monitor. If the stats are crazy, I will go from there.
Thank you for all your help.
-John / comments
Hello Alex,
Thanks for the prompt response. I am sorry for the delay in my response, as we had a holiday at the office and for once in my life as a DBA i got to sleep a bit.
Here are the answers to...
Consumption statistics / Exporting Alert Settings
Hello All,
Has anyone had an issue with the consumption stats posted by the dev group being roughly 10x off in just about every category? One example "Total network traffic (inbound plus outbound) ...
Yes Chris, I sure am. I was just told by support this isn't fully supported yet and a ticket was opened. I guess for now i will just have to deal? / comments
Yes Chris, I sure am. I was just told by support this isn't fully supported yet and a ticket was opened. I guess for now i will just have to deal?
Monitoring AlwaysOn HA Groups
I am currently getting an error when setting up monitor for our clustered environment. The group consists of 2 servers dbA and dbB. DBA is the primary. When I add the group to monitor, I am using c...