FlushCache messages might not be an actual IO stall

SQL Server's FlushCache message might be not actually be an IO stall and using SQL Server's perfmon counters we can isolate another reason for this warning message.

At a client site recently a SQL Server 2012 (Enterprise, SP1 + CU#9) server with 512GB RAM and 80 cores (40 cores assigned to SQL Server) that had been patched and restarted displayed the following symptoms after an index reorg operation was restarted: CPU saturation, with all cores available to SQL Server (but not all […]