Deadlocks show message- This alert is still being written to

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

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

Deadlocks show message- This alert is still being written to

Postby neelymd » Wed Mar 03, 2010 10:14 pm

The detail for Deadlocks is not being completed, it only shows this message - \"This alert is still being written to\". Any idea why they aren't being completed?
neelymd
 
Posts: 8
Joined: Mon Jan 04, 2010 5:48 pm
Location: St. Paul, Minnesota, USA

Postby Anu Deshpande » Fri Mar 05, 2010 11:58 am

Thank you for your post and sorry that you are experiencing this issue.

Is this problem occurring for all of the alerts or just this deadlock one?

Can you please check the following setting in the server properties for each monitored server on your Production Alert Repository and if required modify the Execution time-out to set it to 0 seconds.

Right click the computer in the Servers to show list and select Server Properties

In the Server Properties dialog for each sever and confirm that the Execution time-out Connection setting is set to 0 seconds. If it is not set to 0 seconds, can you please modify it so it becomes 0 seconds and then stop and restart the SQL Response Alert Repository.

Next monitor any new alerts and ensure that you are not getting the 'Alert is still being written to' in the alert details.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

It's working, Excluded files from Anti-Virus

Postby neelymd » Sat Mar 06, 2010 8:00 pm

I found an article about Excluding paths from the Anti-Virus Protection on the Server. The acticle said the Documents and Settings file path needed to be excluded, we weren't doing that, I had it added and it's working like a champ.

:D
neelymd
 
Posts: 8
Joined: Mon Jan 04, 2010 5:48 pm
Location: St. Paul, Minnesota, USA

Postby Anu Deshpande » Tue Mar 09, 2010 12:35 pm

Many thanks for the confirmation.

We are pleased that your issue is resolved.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

it quit working again

Postby neelymd » Wed Mar 10, 2010 9:06 pm

It's locked up again. Looks like it stopped trying to get the info for a deaklock. Is there any information in a log file somewhere? :x
neelymd
 
Posts: 8
Joined: Mon Jan 04, 2010 5:48 pm
Location: St. Paul, Minnesota, USA

Postby Anu Deshpande » Thu Mar 11, 2010 10:29 am

Kindly can you confirm that you did the changes in my previous post:

\"Thank you for your post and sorry that you are experiencing this issue.

Is this problem occurring for all of the alerts or just this deadlock one?

Can you please check the following setting in the server properties for each monitored server on your Production Alert Repository and if required modify the Execution time-out to set it to 0 seconds.

Right click the computer in the Servers to show list and select Server Properties

In the Server Properties dialog for each sever and confirm that the Execution time-out Connection setting is set to 0 seconds. If it is not set to 0 seconds, can you please modify it so it becomes 0 seconds and then stop and restart the SQL Response Alert Repository.

Next monitor any new alerts and ensure that you are not getting the 'Alert is still being written to' in the alert details.\"
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby Anu Deshpande » Thu Mar 11, 2010 10:32 am

I forgot to mention how to obtain SQL Response log files.

We have a knowledge base article for that : http://www.red-gate.com/supportcenter/C ... _files.htm
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 1 guest