- Newest
- Most votes
- Most comments
I couldn't find an answer to this, but it wasn't the reason fn_dblog was running slowly. We had too many tempdb files on different drives. Some old config.
""" So after upgrading from 3.4.x to 3.5.x our latency from SQL Server got super slow. This was a forced upgrade by AWS.
Turns out our production instance had a 8 tempdb files. Some where on the Z: drive and some on the C: drive. Not sure why this freaked SQL Server out, but fn_dblog performance got very poor. Tempdb verison store old transaction time steadily increased.
Dropped down to 2 tempdb files both on Z and contention went away. Luckily we had a QA system where we didn't have that config and saw the Tempdb stats in one of our monitoring tools.
I did notice the syntax of the fn_dblog call changed from 3.4 to 3.5 with a few additional parts of the where clause. Like a lot of things SQL server probably uses the tempdb during the fn_dblog calls...wish they would just admit it needs to be a documented function. """
answered 2 years ago
