Viewing 4 posts - 1 through 4 (of 4 total)
It wasn't open row groups or a need to rebuild, it was simple operator error.
It became very clear what the problem was when I tried to switch my staging table...
May 21, 2014 at 10:49 am
SQLKnowItAll (2/27/2013)
When I look at Jonathan's Extended Event Session Explorer (We are on 2008 R2) I DO see object names for the deadlocks. Any thoughts?
I've always had to look...
June 21, 2013 at 7:42 am
hello mahesh (9/17/2012)
We had couple of deadlock issues,but nothing is captured with this query..
First try this:
WITH SessionData as (
SELECT
XEventData.XEvent.value('(data/value)[1]', 'varchar(max)') VarcharResults
FROM (
select...
September 17, 2012 at 4:00 pm
I get the bad XML error because of tags like this that show up intermittently--
<victim-list>
<victimProcess id="process541c988">
<victimProcess id="process6e8bdc8"/>
</victim-list>
I've started doing this--
WITH SessionData as (
...
May 23, 2011 at 8:12 am
Viewing 4 posts - 1 through 4 (of 4 total)