First published on MSDN on Aug 03, 2016
Authored by Mike Ruthruff
Reviewed by: Denzil Ribeiro, Mike Weiner, Arvind Shyamsundar, Sanjay Mishra, Mursh...
Updated Oct 28, 2022
Version 4.0
Blog Post
We migrated our database from 2012 to 2016 , this database is OLTP with 150K inserts / sec to two tables. We got target_recovery_time_in_seconds=60 seconds. Disk is showing high latency of up to 50+ milli sec compared to less than 20 milli sec in SQL 2012. Also the disk latency spikes to 300+ milli sec when Tlog backup runs.