Hey guys

I found the solution. I had to enable Snapshot Isolation on my database

ALTER DATABASE MyDatabase

SET ALLOW_SNAPSHOT_ISOLATION ON

Thank you for all the answers

The status of session 66 is SLEEPING and the cmd is AWAITING COMMAND.

I think is is an issue in the code, I think SQL is waiting for the application to...

Yes, I can see the lock.

ObjectName : DIMENSIONHIERARCHY

Request_mode: IS

Request_owner_type: Transaction

Session ID :71

ObjectName : DIMENSIONHIERARCHY

Request_mode: IX

Request_owner_type: Transaction

Session ID : 66

ObjectName : DIMENSIONHIERARCHYLEVEL

Request_mode: IX

Request_owner_type: Transaction

Session ID : 66

Head Blocker = Session 66

Session...

Thanks for your answer,

I am not a developer so I have not checked the code yet.

Do you mean if the query is being part of a transaction (ttsbegin -ttscommit) ?

Are...

Thank you very much guys !

@SeniorITGuy

VMFS version is 5.61 and the block size is 1 MB

SAN sector size = 512 bytes

There is conversation about block size across different layer (OS, VMFS, SAN)...

SAN LUN presented as a drive to VMware. I am doing my test on a virtual disk.

Thank you very much, it certainly helps to understand SQL. I understand now that SQL does not only perform 64K operations as pointed on by GilaMonster.

Interleaved files is also very...