Activity overview
Latest activity by jonwilk
My thoughts exactly
Ours is a heavy server load, but i should'nt be seeing redgate errors on their.
Is there way to turn this top query aspect off as it's something we don't use anyway?
Also the deadlocks fill my sql log so simply ignoring them is very difficult to do.
We could do with a quick fix for this please?
thanks / comments
My thoughts exactly
Ours is a heavy server load, but i should'nt be seeing redgate errors on their.
Is there way to turn this top query aspect off as it's something we don't use anyway?
Also the de...
SQL Monitoring creating deadlocks
Hi
I've started to get deadlocks on one of our servers, and after further investigation it seems redgate sql monitor is causing them. It looks like it's because of temp tables. Here's the output ...
i'm having exactly the same problem.
this cluster used to work fine for about 2 years and now suddenly won't work / comments
i'm having exactly the same problem.
this cluster used to work fine for about 2 years and now suddenly won't work
Alerting.Base.Service.exe taking consuming all memory
Hi
I've posted this before and now this problem keeps happening.
The Redgate.Response.Engine.Altering.Base.Service.exe application keeps consuming all of the available memory on the server dedicate...
hi
all of the databases are online and working fine (this is a production server)
they are all showing as offline in sql monitor
this worked fine in 2.2
thanks / comments
hi
all of the databases are online and working fine (this is a production server)
they are all showing as offline in sql monitor
this worked fine in 2.2
thanks
Databases shown as offline
Hi
Just upgraded to 2.3
We're monitoring a few servers and all is well, however, the 1 and only cluster we're monitornig is showing the databases as offline when viewed from the overview page.
The ...
Log backup overdue alert when using SIMPLE recovery model
Hi
I'm now getting daily alerts saying
"Alert type: Log backup overdue"
for multiple databases that are set to use the SIMPLE recovery model.
I am taking FULL backups of these databases each day, b...
False Alert - Monitoring error (SQL Server data collection)
Hi
We're monitoring a SQL server that is receiving shipped transaction logs. This seems to randomly cause "Monitoring error (SQL Server data collection) (Raised - High)" Alerts to be raised.
I man...
Hi
Thanks for your prompt response.
In answer to your questions:
All of the times are the same time - from the domain controller.
All moniotred machines are all in the same physical location
There 4 SQL servers being monitored.
Yes SQL is monitoring its own database. Average Disk Read is 1.1ms, write 1.2ms. Transfer per sec = 2.3.
What type of disk is Sql Monitor's repository stored on? Generic answer is fine, e.g.:
it is a SAN / high performance RAID.
This has only happened once. I will keep an eye on it.
Thanks / comments
Hi
Thanks for your prompt response.
In answer to your questions:
All of the times are the same time - from the domain controller.
All moniotred machines are all in the same physical location
There ...
High Memory Use
We're experiencing high memory usage in the RedGate.Response.Base.Service.
It had used 1,891,160K of memory in a server with 2GB of RAM.
This made the website inaccessable and the only way to solve...