Not getting low disk space alerts

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Not getting low disk space alerts

Postby kevriley » Thu Jun 24, 2010 1:12 pm

I'm having issues with 'low disk space alerts'

I've edited the alert from 80% to 95% for a particular server.
Then I copied some files to exceed that threshold.

I did not get an alert

Check the config.xml and the setting for this alert is 120 = 2mins

so I waited.....and waited....still didn't get an alert.

Seem to recall I get low disk/low memory alerts when I restart SQL Response, but I don't seem to get any once it is running.....
kevriley
 
Posts: 70
Joined: Tue Apr 07, 2009 12:46 pm
Location: UK

Postby kevriley » Thu Jun 24, 2010 3:07 pm

just to check, I just restarted the SQL response Alert Repository Service, and then the alert fired!
kevriley
 
Posts: 70
Joined: Tue Apr 07, 2009 12:46 pm
Location: UK

Postby eddie davis » Mon Jun 28, 2010 11:37 am

Hi Kevan

Sorry for the delay in replying back to you.

In the time since you restarted SQL Response has the problem re-appeared?

When the problem originally appeared, if known, what was the CPU usage of the SQL Response Alert Repository Service?

If the problem has re-occurred, what is the CPU usage of the SQL Response Alert Repository Service?

A support call has been created for this forum post, call reference F0035979.

Can you please attach to an e-mail the Alert Repository log file for Thursday 24th June and if the problem has re-occurred the log file for today. Please send the e-mail to support@red-gate.com and include the above call reference number in the subject field of the e-mail.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby kevriley » Thu Jul 01, 2010 9:43 am

Eddie,

sorry for the delay in getting back to you too!

I don't know what the CPU usage was like at the original time.

Have sent the logfiles as requested - I need to do some more testing to see if the alert is behaving as expected. but obviously with this being a low disk space alert I need to be careful as and when I run the space down.
kevriley
 
Posts: 70
Joined: Tue Apr 07, 2009 12:46 pm
Location: UK

Postby eddie davis » Tue Jul 06, 2010 4:12 pm

Hi Kevriley

Thank you for your reply.

The log file you have supplied to me is from the SQL Response Client. The SQL Response Client uses .NET Remoting to connect to the Alert Repository, I can see from the log File that there where connection errors but I am unsure if they occurred when you were performing your 'Low Disk Space' Alert testing or from you restarting the SQL Response Alert Repository Service.

If you can remember at what time did you restart the Alert Repository Service.

Can you please also reply with a copy of the Alert Repository Log file for the date you performed your testing?

Windows 2003 - C:\\Documents and settings\\All Users\\Application Data\\Red Gate\\SQL Response 1

Windows 2008 - C:\\ProgramData\\Red Gate\\Logs\\SQL Response Alert Repository 1

I have also sent the above request to you via e-mail.

Many Thanks,
Eddie Davis
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests