March 18, 2014 at 1:28 pm
How would I test the data throughput capabilities of the transaction log only? I am trying to test out whether certain configurations are having a positive affect on the MB/s throughput of the log file.
It is difficult to tell because I am currently testing with an insert statement but cant tell if the log file or data disks are the bottleneck.
March 18, 2014 at 3:13 pm
March 19, 2014 at 4:17 am
If you observe the wait statistics through sys.dm_os_wait_stats, you'll be able to tell where the waits are occurring. If you see log latch and IO waits, then you're experiencing slower performance on the log. If it's other waits, then the slow down is occurring elsewhere.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply