Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Deadlock due to intra-query parallelism Expand / Collapse
Author
Message
Posted Monday, December 10, 2012 11:36 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 16, Visits: 939
Hi
We have been having deadlocks a lot and to track them I enabled Trace Flags 1204 and 1222.
The output does not give adequate information and object details.

,spid6s,Unknown,Input Buf: No Event:
,spid6s,Unknown,SPID: 74 ECID: 24 Statement Type: SELECT Line #: 1
,spid6s,Unknown,ResType:ExchangeId Stype:'AND' SPID:74 BatchID:0 ECID:24 TaskProxy0x0000000A03F03DA0) Value:0x418d708 Cost0/10000)
,spid6s,Unknown,Port: 0x00000000803B3B00 Xid Slot: 4<c/> Wait Slot: 5<c/> Task: 0x000000000418D708<c/> (Consumer)<c/> Exchange Wait Type: e_waitPortOpen<c/> Merging: 0
,spid6s,Unknown,Node:2
,spid6s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
,spid6s,Unknown,Input Buf: No Event:
,spid6s,Unknown,SPID: 74 ECID: 23 Statement Type: SELECT Line #: 1
,spid6s,Unknown,ResType:ExchangeId Stype:'AND' SPID:74 BatchID:0 ECID:23 TaskProxy0x0000000A03F03D40) Value:0x4173048 Cost0/10000)
,spid6s,Unknown,Port: 0x00000000803B3B00 Xid Slot: 3<c/> Wait Slot: 4<c/> Task: 0x0000000004173048<c/> (Consumer)<c/> Exchange Wait Type: e_waitPortOpen<c/> Merging: 0
,spid6s,Unknown,Node:1
,spid6s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
,spid6s,Unknown,Wait-for graph
,spid6s,Unknown,Deadlock encountered .... Printing deadlock information


I even enabled service-side tracing with profiler and the output remains the same.

Parallel query worker thread was involved in a deadlock

Even the Deadlock Graph looks weird and does not provide any information.

I have checked online for solutions and have failed.
I doubt it could be because of any SSIS package or any application.
But one of the spid shows it's a system process and similar deadlocks have been happening a lot recently.
My question here is except for changing the threshold and MaxDOP, is there any other way to track down the objects for a solution ?

Any insight would be helpful. Thank you

Post #1394904
Posted Tuesday, December 11, 2012 2:32 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 42,332, Visits: 35,382
Firstly, turn traceflag 1204 off. It produces the old-style deadlock graph that's very hard to read. With just 1222 on, wait until another deadlock occurs and post the entire deadlock graph here please.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1394959
Posted Thursday, December 13, 2012 10:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 16, Visits: 939
Traceflag 1204 is off and this is the output of 1222.

,spid6s,Unknown,waiter id=process4a66748
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a67b88
,spid6s,Unknown,owner id=process4a67dc8
,spid6s,Unknown,owner id=process4a67288
,spid6s,Unknown,owner id=process4a674c8
,spid6s,Unknown,owner-list
,spid6s,Unknown,threadpool id=scheduler4a70080
,spid6s,Unknown,waiter id=process50654c8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4173948
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process5065708
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4172988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process5064988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4173dc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=processfba444748
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4abfdc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=processfba445288
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4abf708
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=processfba444988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4abf288
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4e16988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4abf948
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4e17948
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processfba444748
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4e17708
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processfba445288
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4e17288
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processfba444988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=processd2c9c0088
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4e16988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=processd2c9c0988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4e17948
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=processd2c9c02c8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4e17708
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4d95708
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4ab5b88
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4d954c8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4ab5708
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4d94e08
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4ab5dc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4d95dc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4ab4988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4b7a988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4d95708
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4b7bb88
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4d954c8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4b7b708
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4d94e08
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4b7abc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4d95dc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4b614c8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b7a988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4b61048
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b7bb88
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4b60e08
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b7b708
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4b61288
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b7abc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4b46988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b614c8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4b474c8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b61048
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4b47708
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b60e08
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4b47288
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b61288
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=processa6d882bc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b46988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=processa6d8834c8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b474c8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=processa6d883708
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b47708
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=processa6d883288
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b47288
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process7353c7b88
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processd2c9c0088
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process7353c7048
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processd2c9c0988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process7353c6748
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processd2c9c02c8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=processd2c9c1288
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4e17288
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3f00 WaitType=e_waitPortOpen nodeId=14
,spid6s,Unknown,waiter id=process7353c7708
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processd2c9c1288
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3f00 WaitType=e_waitPortOpen nodeId=14
,spid6s,Unknown,waiter id=process5065dc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4173708
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3f00 WaitType=e_waitPortOpen nodeId=14
,spid6s,Unknown,waiter id=process4b03dc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processa6d882bc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4abf948
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b03dc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4b02988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processa6d8834c8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4abfdc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b02988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4b02748
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processa6d883708
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4abf708
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b02748
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4b03b88
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processa6d883288
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4abf288
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4b03b88
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4dc9048
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a9b948
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4ab5b88
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4dc9048
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4dc9dc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a9b048
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4ab5708
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4dc9dc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4dc8988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a9ae08
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4ab5dc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4dc8988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4dc8bc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a9a988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4ab4988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4dc8bc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4dfd948
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a80e08
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4a9b948
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4dfd948
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4dfd288
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a81dc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4a9b048
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4dfd288
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4dfd708
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a814c8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4a9ae08
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4dfd708
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4dfddc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a81048
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4a9a988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4dfddc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4a80e08
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a66748
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4a81dc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a674c8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4a814c8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a67288
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4a81048
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4a67dc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4e4bb88
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process50654c8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4a674c8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4e4bb88
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4e4abc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process5065708
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4a67288
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4e4abc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4e4a748
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process5064988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4a67dc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4e4a748
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4a67b88
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process418d048
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3f00 WaitType=e_waitPortOpen nodeId=14
,spid6s,Unknown,waiter id=processffe227dc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process7353c7b88
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=processffe226988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process7353c7048
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=processffe226bc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process7353c6748
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4e4b288
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process5065dc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3f00 WaitType=e_waitPortOpen nodeId=14
,spid6s,Unknown,waiter id=process418d048
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process4e4b288
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3f00 WaitType=e_waitPortOpen nodeId=14
,spid6s,Unknown,waiter id=process418c988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processffe227dc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process4173948
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process418c988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2b00 WaitType=e_waitPortOpen nodeId=24
,spid6s,Unknown,waiter id=process418d708
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processffe226988
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process4172988
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process418d708
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3400 WaitType=e_waitPortOpen nodeId=22
,spid6s,Unknown,waiter id=process418ddc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processffe226bc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=process4173dc8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process418ddc8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b2c00 WaitType=e_waitPortOpen nodeId=16
,spid6s,Unknown,waiter id=processffe2262c8
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=process7353c7708
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3f00 WaitType=e_waitPortOpen nodeId=14
,spid6s,Unknown,waiter id=process4173708
,spid6s,Unknown,waiter-list
,spid6s,Unknown,owner id=processffe2262c8
,spid6s,Unknown,owner-list
,spid6s,Unknown,exchangeEvent id=Port803b3f00 WaitType=e_waitPortOpen nodeId=14
,spid6s,Unknown,resource-list
,spid6s,Unknown,process id=process4a66748 waittime=2534 schedulerid=5 kpid=0
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process50654c8 taskpriority=0 logused=10000 waittime=2528 schedulerid=24 kpid=128084 status=suspended spid=87 sbid=0 ecid=81 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process5065708 taskpriority=0 logused=10000 waittime=4982 schedulerid=24 kpid=102744 status=suspended spid=87 sbid=0 ecid=54 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process5064988 taskpriority=0 logused=10000 waittime=5300 schedulerid=24 kpid=122964 status=suspended spid=87 sbid=0 ecid=33 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processfba444748 taskpriority=0 logused=10000 waittime=2529 schedulerid=22 kpid=129260 status=suspended spid=87 sbid=0 ecid=73 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processfba445288 taskpriority=0 logused=10000 waittime=5147 schedulerid=22 kpid=105836 status=suspended spid=87 sbid=0 ecid=45 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processfba444988 taskpriority=0 logused=10000 waittime=5299 schedulerid=22 kpid=129488 status=suspended spid=87 sbid=0 ecid=23 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4e16988 taskpriority=0 logused=10000 waittime=2533 schedulerid=21 kpid=124208 status=suspended spid=87 sbid=0 ecid=91 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4e17948 taskpriority=0 logused=10000 waittime=2528 schedulerid=21 kpid=123104 status=suspended spid=87 sbid=0 ecid=72 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4e17708 taskpriority=0 logused=10000 waittime=5163 schedulerid=21 kpid=128900 status=suspended spid=87 sbid=0 ecid=62 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4e17288 taskpriority=0 logused=10000 waittime=5298 schedulerid=21 kpid=126876 status=suspended spid=87 sbid=0 ecid=38 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processd2c9c0088 taskpriority=0 logused=10000 waittime=2524 schedulerid=19 kpid=128892 status=suspended spid=87 sbid=0 ecid=87 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processd2c9c0988 taskpriority=0 logused=10000 waittime=5162 schedulerid=19 kpid=125076 status=suspended spid=87 sbid=0 ecid=65 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processd2c9c02c8 taskpriority=0 logused=10000 waittime=5271 schedulerid=19 kpid=131296 status=suspended spid=87 sbid=0 ecid=43 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4d95708 taskpriority=0 logused=10000 waittime=971 schedulerid=16 kpid=125460 status=suspended spid=87 sbid=0 ecid=104 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4d954c8 taskpriority=0 logused=10000 waittime=2404 schedulerid=16 kpid=124004 status=suspended spid=87 sbid=0 ecid=82 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4d94e08 taskpriority=0 logused=10000 waittime=5163 schedulerid=16 kpid=79536 status=suspended spid=87 sbid=0 ecid=53 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4d95dc8 taskpriority=0 logused=10000 waittime=5300 schedulerid=16 kpid=126420 status=suspended spid=87 sbid=0 ecid=24 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b7a988 taskpriority=0 logused=10000 waittime=2533 schedulerid=15 kpid=131896 status=suspended spid=87 sbid=0 ecid=89 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b7bb88 taskpriority=0 logused=10000 waittime=2528 schedulerid=15 kpid=123568 status=suspended spid=87 sbid=0 ecid=68 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b7b708 taskpriority=0 logused=10000 waittime=5162 schedulerid=15 kpid=124900 status=suspended spid=87 sbid=0 ecid=55 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b7abc8 taskpriority=0 logused=10000 waittime=5300 schedulerid=15 kpid=116648 status=suspended spid=87 sbid=0 ecid=27 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b614c8 taskpriority=0 logused=10000 waittime=2533 schedulerid=14 kpid=129916 status=suspended spid=87 sbid=0 ecid=90 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b61048 taskpriority=0 logused=10000 waittime=2528 schedulerid=14 kpid=131788 status=suspended spid=87 sbid=0 ecid=69 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b60e08 taskpriority=0 logused=10000 waittime=5163 schedulerid=14 kpid=124656 status=suspended spid=87 sbid=0 ecid=57 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b61288 taskpriority=0 logused=10000 waittime=5299 schedulerid=14 kpid=114472 status=suspended spid=87 sbid=0 ecid=34 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b46988 taskpriority=0 logused=10000 waittime=2448 schedulerid=13 kpid=114388 status=suspended spid=87 sbid=0 ecid=94 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b474c8 taskpriority=0 logused=10000 waittime=2448 schedulerid=13 kpid=124204 status=suspended spid=87 sbid=0 ecid=71 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b47708 taskpriority=0 logused=10000 waittime=5162 schedulerid=13 kpid=125708 status=suspended spid=87 sbid=0 ecid=63 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b47288 taskpriority=0 logused=10000 waittime=5298 schedulerid=13 kpid=132052 status=suspended spid=87 sbid=0 ecid=35 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processa6d882bc8 taskpriority=0 logused=10000 waittime=2533 schedulerid=12 kpid=104076 status=suspended spid=87 sbid=0 ecid=93 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processa6d8834c8 taskpriority=0 logused=10000 waittime=2528 schedulerid=12 kpid=125412 status=suspended spid=87 sbid=0 ecid=67 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processa6d883708 taskpriority=0 logused=10000 waittime=5162 schedulerid=12 kpid=129100 status=suspended spid=87 sbid=0 ecid=59 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processa6d883288 taskpriority=0 logused=10000 waittime=5300 schedulerid=12 kpid=129088 status=suspended spid=87 sbid=0 ecid=36 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process7353c7b88 taskpriority=0 logused=10000 waittime=2525 schedulerid=17 kpid=97888 status=suspended spid=87 sbid=0 ecid=83 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process7353c7048 taskpriority=0 logused=10000 waittime=5160 schedulerid=17 kpid=111432 status=suspended spid=87 sbid=0 ecid=58 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process7353c6748 taskpriority=0 logused=10000 waittime=5297 schedulerid=17 kpid=117216 status=suspended spid=87 sbid=0 ecid=42 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processd2c9c1288 taskpriority=0 logused=10000 waittime=5380 schedulerid=19 kpid=131968 status=suspended spid=87 sbid=0 ecid=21 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process7353c7708 taskpriority=0 logused=10000 waittime=5380 schedulerid=17 kpid=118900 status=suspended spid=87 sbid=0 ecid=22 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process5065dc8 taskpriority=0 logused=10000 waittime=5380 schedulerid=24 kpid=105228 status=suspended spid=87 sbid=0 ecid=18 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b03dc8 taskpriority=0 logused=10000 waittime=2110 schedulerid=11 kpid=120096 status=suspended spid=87 sbid=0 ecid=96 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4abf948 taskpriority=0 logused=10000 waittime=522 schedulerid=9 kpid=107584 status=suspended spid=87 sbid=0 ecid=106 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b02988 taskpriority=0 logused=10000 waittime=2527 schedulerid=11 kpid=113312 status=suspended spid=87 sbid=0 ecid=74 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4abfdc8 taskpriority=0 logused=10000 waittime=2527 schedulerid=9 kpid=125384 status=suspended spid=87 sbid=0 ecid=84 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b02748 taskpriority=0 logused=10000 waittime=5162 schedulerid=11 kpid=109996 status=suspended spid=87 sbid=0 ecid=46 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4abf708 taskpriority=0 logused=10000 waittime=5162 schedulerid=9 kpid=125648 status=suspended spid=87 sbid=0 ecid=60 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4b03b88 taskpriority=0 logused=10000 waittime=5297 schedulerid=11 kpid=127964 status=suspended spid=87 sbid=0 ecid=30 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4abf288 taskpriority=0 logused=10000 waittime=5297 schedulerid=9 kpid=128692 status=suspended spid=87 sbid=0 ecid=44 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4dc9048 taskpriority=0 logused=10000 waittime=1879 schedulerid=18 kpid=131772 status=suspended spid=87 sbid=0 ecid=97 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4ab5b88 taskpriority=0 logused=10000 waittime=327 schedulerid=8 kpid=131308 status=suspended spid=87 sbid=0 ecid=108 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4dc9dc8 taskpriority=0 logused=10000 waittime=2527 schedulerid=18 kpid=130756 status=suspended spid=87 sbid=0 ecid=75 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4ab5708 taskpriority=0 logused=10000 waittime=2527 schedulerid=8 kpid=116880 status=suspended spid=87 sbid=0 ecid=86 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4dc8988 taskpriority=0 logused=10000 waittime=5162 schedulerid=18 kpid=76840 status=suspended spid=87 sbid=0 ecid=47 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4ab5dc8 taskpriority=0 logused=10000 waittime=5161 schedulerid=8 kpid=131476 status=suspended spid=87 sbid=0 ecid=64 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4dc8bc8 taskpriority=0 logused=10000 waittime=5297 schedulerid=18 kpid=131812 status=suspended spid=87 sbid=0 ecid=31 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4ab4988 taskpriority=0 logused=10000 waittime=5297 schedulerid=8 kpid=104832 status=suspended spid=87 sbid=0 ecid=37 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4dfd948 taskpriority=0 logused=10000 waittime=1363 schedulerid=20 kpid=126060 status=suspended spid=87 sbid=0 ecid=101 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4a9b948 taskpriority=0 logused=10000 waittime=1507 schedulerid=7 kpid=115920 status=suspended spid=87 sbid=0 ecid=100 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4dfd288 taskpriority=0 logused=10000 waittime=2527 schedulerid=20 kpid=107000 status=suspended spid=87 sbid=0 ecid=79 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4a9b048 taskpriority=0 logused=10000 waittime=2527 schedulerid=7 kpid=131304 status=suspended spid=87 sbid=0 ecid=78 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4dfd708 taskpriority=0 logused=10000 waittime=5161 schedulerid=20 kpid=119296 status=suspended spid=87 sbid=0 ecid=50 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4a9ae08 taskpriority=0 logused=10000 waittime=5161 schedulerid=7 kpid=34276 status=suspended spid=87 sbid=0 ecid=51 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4dfddc8 taskpriority=0 logused=10000 waittime=5297 schedulerid=20 kpid=116604 status=suspended spid=87 sbid=0 ecid=40 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4a9a988 taskpriority=0 logused=10000 waittime=5297 schedulerid=7 kpid=126856 status=suspended spid=87 sbid=0 ecid=28 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4a80e08 taskpriority=0 logused=10000 waittime=1202 schedulerid=6 kpid=128864 status=suspended spid=87 sbid=0 ecid=102 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4a81dc8 taskpriority=0 logused=10000 waittime=2527 schedulerid=6 kpid=127724 status=suspended spid=87 sbid=0 ecid=80 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4a814c8 taskpriority=0 logused=10000 waittime=5161 schedulerid=6 kpid=125880 status=suspended spid=87 sbid=0 ecid=52 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4a81048 taskpriority=0 logused=10000 waittime=5301 schedulerid=6 kpid=122904 status=suspended spid=87 sbid=0 ecid=39 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4e4bb88 taskpriority=0 logused=10000 waittime=2527 schedulerid=23 kpid=128200 status=suspended spid=87 sbid=0 ecid=77 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4a674c8 taskpriority=0 logused=10000 waittime=2527 schedulerid=5 kpid=126708 status=suspended spid=87 sbid=0 ecid=88 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4e4abc8 taskpriority=0 logused=10000 waittime=5161 schedulerid=23 kpid=128768 status=suspended spid=87 sbid=0 ecid=49 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4a67288 taskpriority=0 logused=10000 waittime=5161 schedulerid=5 kpid=125004 status=suspended spid=87 sbid=0 ecid=66 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4e4a748 taskpriority=0 logused=10000 waittime=5298 schedulerid=23 kpid=124924 status=suspended spid=87 sbid=0 ecid=32 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4a67dc8 taskpriority=0 logused=10000 waittime=5169 schedulerid=5 kpid=127672 status=suspended spid=87 sbid=0 ecid=29 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4a67b88 taskpriority=0 logused=10000 waittime=5379 schedulerid=5 kpid=107008 status=suspended spid=87 sbid=0 ecid=15 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processffe227dc8 taskpriority=0 logused=10000 waittime=2527 schedulerid=10 kpid=124360 status=suspended spid=87 sbid=0 ecid=70 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processffe226988 taskpriority=0 logused=10000 waittime=5162 schedulerid=10 kpid=22636 status=suspended spid=87 sbid=0 ecid=56 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processffe226bc8 taskpriority=0 logused=10000 waittime=5297 schedulerid=10 kpid=129960 status=suspended spid=87 sbid=0 ecid=41 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4e4b288 taskpriority=0 logused=10000 waittime=5379 schedulerid=23 kpid=128600 status=suspended spid=87 sbid=0 ecid=17 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process418d048 taskpriority=0 logused=10000 waittime=5380 schedulerid=4 kpid=127764 status=suspended spid=87 sbid=0 ecid=16 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process418c988 taskpriority=0 logused=10000 waittime=2528 schedulerid=4 kpid=128976 status=suspended spid=87 sbid=0 ecid=85 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4173948 taskpriority=0 logused=10000 waittime=2529 schedulerid=3 kpid=111796 status=suspended spid=87 sbid=0 ecid=76 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process418d708 taskpriority=0 logused=10000 waittime=5163 schedulerid=4 kpid=95948 status=suspended spid=87 sbid=0 ecid=61 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4172988 taskpriority=0 logused=10000 waittime=5164 schedulerid=3 kpid=127108 status=suspended spid=87 sbid=0 ecid=48 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process418ddc8 taskpriority=0 logused=10000 waittime=5297 schedulerid=4 kpid=95808 status=suspended spid=87 sbid=0 ecid=25 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4173dc8 taskpriority=0 logused=10000 waittime=5298 schedulerid=3 kpid=104244 status=suspended spid=87 sbid=0 ecid=26 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=processffe2262c8 taskpriority=0 logused=10000 waittime=5378 schedulerid=10 kpid=130604 status=suspended spid=87 sbid=0 ecid=20 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,inputbuf
,spid6s,Unknown,unknown
,spid6s,Unknown,frame procname=unknown line=1 sqlhandle=0x020000001f6a4b11a3c009190d4f8d5a3cfb53a7acd9be64
,spid6s,Unknown,executionStack
,spid6s,Unknown,process id=process4173708 taskpriority=0 logused=10000 waittime=5379 schedulerid=3 kpid=127680 status=suspended spid=87 sbid=0 ecid=19 priority=0 trancount=0 lastbatchstarted=2012-12-12T15:06:34.207 lastbatchcompleted=2012-12-12T15:06:34.203 clientapp=MicroStrategy 9.2 ® Common Files hostname= AN-LAAB01 hostpid=5256 isolationlevel=read committed (2) xactid=374587447 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
,spid6s,Unknown,process-list
,spid6s,Unknown,deadlock victim=process4173708
,spid6s,Unknown,deadlock-list



This is the output of 1222.
Post #1396302
Posted Thursday, December 13, 2012 10:59 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 42,332, Visits: 35,382
Yup, that's intra-query parallelism

Tune the query so that it doesn't need to parallel (or just to get a more efficient plan) or put a maxdop hint on the query.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1396310
Posted Thursday, December 13, 2012 11:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 16, Visits: 939
Yeah....That's what I have been thinking.
But this is just one output.
We have been having frequent deadlocks like this.

Changing at the query level is my recommendation.
MaxDOP is 0 and Cost Threshold For Parallelism is 5. (Default setting at the server level).

Since too many queries getting deadlocked, I am skeptical whether changing the server level setting would help or not ?

Any suggestions on this ?
Post #1396317
Posted Thursday, December 13, 2012 11:24 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 42,332, Visits: 35,382
I would start by tuning the queries.
If that doesn't work to remove the deadlocks, then and only then add a maxdop hint to those queries.

Server level, without knowing anything about your server, the best I can suggest is leave the maxdop at 0 and increase the cost threshold a bit. I like 25 as a starting point, but that is just a number pulled out of thin air.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1396328
Posted Thursday, December 13, 2012 11:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 16, Visits: 939
Thank you very much Gail.
It was very helpful
Post #1396333
Posted Friday, December 14, 2012 7:32 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 11:14 AM
Points: 4,311, Visits: 6,098
I will make 1 "improvement" to Gail's recommendation on MAXDOP. Check your hardware, and if it is NUMA (almost all modern servers are) then set the SQL Server MAXDOP setting to lessthan or equal to the number of PHYSICAL cores in each NUMA node. This works to minimize cross-node memory access, which is a relatively slow operation.

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1396656
Posted Friday, December 14, 2012 1:04 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 16, Visits: 939
Thanks Kevin.
I will check it out.

But after interpreting the output and discussing with the developers, they want to start with adding with(Nolock) to all the queries, detected by -T1222.
Dirty Reads does not seem an issue, but they do not want to restrict the threads, since there are huge imports mostly.



Post #1396798
Posted Friday, December 14, 2012 7:59 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:05 PM
Points: 36,612, Visits: 31,049
Abdul Rahman (12/14/2012)
Thanks Kevin.
I will check it out.

But after interpreting the output and discussing with the developers, they want to start with adding with(Nolock) to all the queries, detected by -T1222.
Dirty Reads does not seem an issue, but they do not want to restrict the threads, since there are huge imports mostly.


Can you tell by using the T-SQL handle if this is the result of an UPDATE or MERGE statement?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1396855
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse