Activity overview
Latest activity by maddave
How do you archive your backups?
This isn't really a support question, but more a general "how do you do it" type query.
In our organisation we use Redgate backup. We backup 17 SQL instances with a total of about 150 databases ac...
I use SQL Monitor to monitor SQL servers running on VM's hosted by VMWare ESX 5.1. I have noticed descrepencies in the stats collected too, such as CPU will be showing as maxed out via Virtual Center, but never going over 80% via SQL monitor.
I took this down to being due to the different ways the two system monitor the server. Namely, SLQ monitor doesn't look all the time, but polls the system. / comments
I use SQL Monitor to monitor SQL servers running on VM's hosted by VMWare ESX 5.1. I have noticed descrepencies in the stats collected too, such as CPU will be showing as maxed out via Virtual Cen...
Thanks. I knew it was something like that! The service and agent account were not domain accounts. I have now changed and all working ok. / comments
Thanks. I knew it was something like that! The service and agent account were not domain accounts. I have now changed and all working ok.
I've received a support call about this issue, but when I view it it says the call doesn't exist.
Either way, I have had to remove and reinstall SQL Monitor and destroy the database as there was no way for me to recover from the problem as I couldn't extent the disk and the database had no free space in it.
Before I reinstalled I could see the purge options were working. If I changed the purge time to just one weeks of data, then this is all that was shown on the analysis page of SQL Monitor. Even though the data has purged the free space of the data file never increased.
There had been no changes in the number of databases or instances being monitored. I will keep an eye on the data growth and monitor for unusual patterns. / comments
I've received a support call about this issue, but when I view it it says the call doesn't exist.
Either way, I have had to remove and reinstall SQL Monitor and destroy the database as there was no...
Edit - mistake. / comments
Edit - mistake.
Monitor Database doubled in last month
I've noticed today that my SQL Monitor collection database has doubled in size over one month.
Since installing SQL Monitor back in Jan 2013, the database data file has been 50GB and never grown at...
Restore permission denied.
Hi, I am sure this is a configuration problem on my part, but for the life of me I cannot see it.
I have a primary server where SQL Backup is backing up a database fine.
On a separate secondary ser...
When does an alert get raised after a copy failure?
Hi, what is the trigger for an alert being raised after a backup copy to a network location fails? Is it after the retry interval and retry amounts have all be exhausted? Or does the alert get ra...
Perfect. Thanks for the quick reply, that's definitely something to keep an eye on. I'll see if this resolves the issue.
Thanks again. / comments
Perfect. Thanks for the quick reply, that's definitely something to keep an eye on. I'll see if this resolves the issue.
Thanks again.
Hi,
Did you find moving the base monitor to a new server resolve this issue? I am having exactly the same symptoms with one server always having SQL Monitoring Stopped errors, with no login failures on the server. The server is working fine ad the error is ended in a few seconds.
Thanks. / comments
Hi,
Did you find moving the base monitor to a new server resolve this issue? I am having exactly the same symptoms with one server always having SQL Monitoring Stopped errors, with no login failure...