February 1, 2009 at 7:05 am
We trun transaction log backups every 15 minutes. Every time the log backups run we see the transaction log backup process block itself. The lastwaittype is LATCH_EX and the waitresource is ACCESS_METHODS_SCAN_RANGE_GENERATOR. What does this mean? I'm guessing this indicates a resource bottleneck, perhaps with disk, but I can't find any meaningful information on ACCESS_METHODS_SCAN_RANGE_GENERATOR.
Thanks, Dave
February 25, 2009 at 4:26 pm
Do you have row versioning (ALTER DATABASE SNAPSHOT ON)? Run this to see if its on....
Use Master
go
SELECT name, snapshot_isolation_state,
snapshot_isolation_state_desc AS description
FROM sys.databases
WHERE name = N'YOUR_DATABASE_NAME_HERE';
go
I turned on row versioning and started getting Latch_EX in my SQL blocking captures with wait type: ACCESS_METHODS_SCAN_RANGE_GENERATOR
The time between login and last batch was about 45 minutes.
I'm still researching but I was wondering it if could be because I turned on row versioning on a database that had a lot of blocking issues.
Let me know...
Mary Myers
February 25, 2009 at 6:07 pm
No. We don't have it on.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply