I have a query that is stuck (running for few hours but normally takes 2-5 mins)..
Id like to find out why its basically stuck! and see what can be done to not have it happen again. (its happened a few times now)
Any one know a tutorial or willing to go step by step though it with me?
Not sure what info would be needed.. I have sp_whoisactive so know some info..
INSERT INTO VPX_EVENT WITH (ROWLOCK)
(EVENT_ID, CHAIN_ID, EVENT_TYPE, EXTENDED_CLASS,
CREATE_TIME, USERNAME, CATEGORY, VM_ID,
VM_NAME, HOST_ID, HOST_NAME, COMPUTERESOURCE_ID,
COMPUTERESOURCE_TYPE, COMPUTERESOURCE_NAME, DATACENTER_ID,
DATACENTER_NAME, DATASTORE_ID, DATASTORE_NAME, NETWORK_ID,
NETWORK_NAME, NETWORK_TYPE, DVS_ID, DVS_NAME, CHANGE_TAG_ID
(@P1, @P2, @P3, @P4, @P5, @P6, @P7, @P8, @P9, @P10, @P11, @P12, @P13, @P14,
@P15, @P16, @P17, @P18, @P19, @P20, @P21, @P22, @P23, @P24
Hope you can help