Red Gate forums :: View topic - Deadlocks show message- This alert is still being written to
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

Deadlocks show message- This alert is still being written to

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
neelymd



Joined: 04 Jan 2010
Posts: 8
Location: St. Paul, Minnesota, USA

PostPosted: Wed Mar 03, 2010 10:14 pm    Post subject: Deadlocks show message- This alert is still being written to Reply with quote

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?
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 685
Location: Cambridge

PostPosted: Fri Mar 05, 2010 11:58 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
neelymd



Joined: 04 Jan 2010
Posts: 8
Location: St. Paul, Minnesota, USA

PostPosted: Sat Mar 06, 2010 8:00 pm    Post subject: It's working, Excluded files from Anti-Virus Reply with quote

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.

Very Happy
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 685
Location: Cambridge

PostPosted: Tue Mar 09, 2010 12:35 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
neelymd



Joined: 04 Jan 2010
Posts: 8
Location: St. Paul, Minnesota, USA

PostPosted: Wed Mar 10, 2010 9:06 pm    Post subject: it quit working again Reply with quote

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? Mad
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 685
Location: Cambridge

PostPosted: Thu Mar 11, 2010 10:29 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Anu Deshpande



Joined: 20 Apr 2009
Posts: 685
Location: Cambridge

PostPosted: Thu Mar 11, 2010 10:32 am    Post subject: Reply with quote

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/Content.aspx?p=SQL%20Response&c=SQL_Response%5cknowledgebase%5cSR_log_files.htm
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group