Stress testing disk subsystems – SQLIOSIM

A client of ours recently bought a brand new set of disks and wanted to know best practices around tempdb optimizations during the discussion we were trying to identify the latency for read and write performance as well as other benchmarking and stress testing metrics and I figured it would be a good time to…

IS IT POSSIBLE? Bulk operations in Full recovery model

Here is the reason I am writing this post As per the above entry from MSDN, there cannot be any minimally logged operations in full recovery mode, which is what I have always understood since full recovery model requires point in time recovery. In order to understand my dilemma we need to first define what…