Viewing 15 posts - 1 through 15 (of 40 total)
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!
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
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...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
Jeff Moden (12/22/2011)
{EDIT} I just noticed and I'm curious... what advantage do you find in maintaining separate DATE and TIME columns?
Hi Jeff
The example i posted was an example of...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
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 with the...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
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
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
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...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
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...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
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...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
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...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
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...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
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...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
hmmm, I understand you now.
Let me do some stress testing and get back to you shortly.
Regards
Jordon
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
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...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
Viewing 15 posts - 1 through 15 (of 40 total)