Can honestly, say, 10 years of looking after 30+ SQL servers, countless server builds, 1000's of hours maintaining, restoring and general DBa duties, not once have i come across DELAYED_DURABILITY -...

We just need 14 & 16 across now, but stuck to the max

Bring on the Answers

November 16, 2017 at 7:22 am

#1968343

Made the mistake of giving this to my team this morning, productivity is zero lol - best effort so far is 12 words, 9 to go!

Hi Dale

Did you ever find a fix / cause for this issue?

We're seeing the exact same error on our nightly consistency checks (for the past 3 nights consistently - never...

Hi Jeff

The example i posted was an example of...

EDIT: Answered on StackOverflow: http://stackoverflow.com/questions/8592764/crosstabbing-rows-based-on-sequence-islands-in-a-list-of-times

Hi Jeff

Loving your solution, but i'm struggling to apply it to a scenario where the ID is a compund of multiple columns.

Let me explain...

Hi Praveen, the script is posted under scripts, there is a link the script in the first post of this thread:

http://www.sqlservercentral.com/Forums/FindPost1029139.aspx

Regards

Jordon

just a bit of an update in case anyone else gets the same problem.

I have not found the root cause yet, but i have found a work around.

Given that the...

Hi

We are only running it manually after killing the hung job, therefor they are never running at the same time.

I rebuilt all indexes last night (which included statistics right?) (took...

if blocking is occurring whilst the job is running, its not being shown in Activity Monitor (“Blocked By” etc).

And typical, my VS2008 debugging is deciding not to hit the breakpoints...

hi mate

Na, the job has not changed in any way.

I tried the usual fixes for parameter sniffing, adding RECOMPILE, rewriting to not using the Procs parameters directly, (i.e. passing the...

Hi David,

Sorry i could not be of more use, i fear this problem lies deep within the SQL event logging binaries, i couldn't find no reference of 32040 etc...

Hi David,

Bad AND Good news!

I was able to recreate your problem, event 32040 etc are indeed written to event log, and no email is generated. As you suggest, this is...

hmmm, I understand you now.

Let me do some stress testing and get back to you shortly.

Regards

Jordon

Hi David

As i say in my second post above, you simply call sp_dbmmonitorchangealert to set thresholds at a Database level. The very first paramater of sp_dbmmonitorchangealert is to specify the...