Viewing 8 posts - 1 through 8 (of 8 total)
I had this issue when trying to drop the login of a person that had done an AOAG install\config. That login had granted connect permission to the HADR endpoint for...
January 27, 2016 at 11:54 am
With the exception of changing @recipients and @profile_name, I ran your script just as you posted it. I ran the first part creating sp_DetectLongRunningTransactions. I...
October 1, 2014 at 4:49 pm
Thank you Krystian, I'm testing out your script. When no queries are running it completes successfully, when I kick off a test query and then run it I get...
September 30, 2014 at 10:34 am
As you noted, using that counter only tracks transactions with "read committed snapshot isolation level." Does anyone know of a way to monitor and alert on ANY long running...
September 25, 2014 at 8:58 am
This error message from two databases was flooding the SQL error log on one of my servers and the error logs were getting huge eating up disk space. I...
October 30, 2013 at 2:10 pm
Last night while migrating a 2TB database we came across the same issue:
Database 'DBname' cannot be opened. It is in the middle of a restore.
Error: 927, Severity: 14, State: 2.
April 20, 2013 at 10:39 am
I found two solutions to this problem.
I am testing log shipping on our test server in SQL 2005. In this test environment, there are no active transactions happening. ...
March 27, 2013 at 10:02 am
Hello Gail, I know this post is old but what you mentioned relates directly to our issue. This isn't a major issue, just annoying. My customer has...
September 13, 2012 at 7:02 am