Popular Posts

  • Error: 18056, Severity: 20, State: 23
    SQLServerCentral » Latest topics Error: 18056, Severity: 20, State: 23 Hi.. Error: 18056, Severity: 20, State: 23. Message The clie...
  • sp_helpindex2
    SQLblog.com - The SQL Server blog spot on the web sp_helpindex2 --my extension of sp_helpindex: sp_helpindex2 USE master GO IF EXIS...
  • SSMS for Linux
    SQLServerCentral » Latest topics SSMS for Linux I can't find information on the Web about whether Microsoft plans to develop an...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Sunday, August 27, 2017

high writelog wait on OLTP system and fast SSD storage, log flush is slow

SQLServerCentral » Latest topics
high writelog wait on OLTP system and fast SSD storage, log flush is slow
we have recently upgraded from SQL server 2008 to new servers and upgraded to sql server 2016 (SP1 CU3)

new servers hardware hp proliant 580G8 , 4 socket intel xeon E7 processor, total 60 cores, 640GB ram, 8 intel SSD S3700 Raid 0, local
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)