Comments
Sort by recent activity
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...
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?