| Author |
Message |
neelymd
Joined: 04 Jan 2010
Posts: 8
Location: St. Paul, Minnesota, USA
|
 Posted: Wed Mar 03, 2010 10:14 pm Post subject: Deadlocks show message- This alert is still being written to |
 |
|
| 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 |
|
 |
Anu Deshpande
Joined: 20 Apr 2009
Posts: 590
Location: Cambridge
|
| Posted: Fri Mar 05, 2010 11:58 am Post subject: |
|
|
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 |
|
|
neelymd
Joined: 04 Jan 2010
Posts: 8
Location: St. Paul, Minnesota, USA
|
| Posted: Sat Mar 06, 2010 8:00 pm Post subject: It's working, Excluded files from Anti-Virus |
|
|
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.
 |
|
| Back to top |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 590
Location: Cambridge
|
| Posted: Tue Mar 09, 2010 12:35 pm Post subject: |
|
|
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 |
|
|
neelymd
Joined: 04 Jan 2010
Posts: 8
Location: St. Paul, Minnesota, USA
|
| Posted: Wed Mar 10, 2010 9:06 pm Post subject: it quit working again |
|
|
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?  |
|
| Back to top |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 590
Location: Cambridge
|
| Posted: Thu Mar 11, 2010 10:29 am Post subject: |
|
|
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 |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 590
Location: Cambridge
|
|
| Back to top |
|
|
|
