Home Forums SQL Server 2014 Administration - SQL Server 2014 SSD Drive RE: SSD Drive
GoWithTheFlow
SSC Veteran
Points: 299
More actions
January 11, 2017 at 2:09 pm
#1922067
The tempdb has 20 datafiles and no symptoms of contention.
The application database has extensive patch latch waits (due to table scans).