Measuring IOPs on MS Windows – Day 01

Background Wanted to cover a couple of options for measuring Storage IOPs on a MS Windows machine. Outline SysGauge - System Monitors MS Windows Performance Monitor Disk IO Logical Disk SQL Server ( v2014+ ) Choices SysGuage Download SysGuage from here. Install it on targeted machine. Run it while sufficient load is running. Images MS … Continue reading Measuring IOPs on MS Windows – Day 01

SQL Server – Storage – IO Pattern – Seeks versus Scans

Background One of the areas that needs to be considered when preparing IOPs requirements, is the mix of Seeks versus Scans. Let us see how we compare amount of seeks versus scans on an existing system.   Referenced Blogs Here are the blogs that pre-meditated this post. SQL Server – Storage – IO Pattern – … Continue reading SQL Server – Storage – IO Pattern – Seeks versus Scans

Technical: Disk – IO – Performance – Disk Benchmark – Tools – DiskMark

Technical: Disk - IO - Performance - Disk Benchmark - Tools - DiskMark Introduction Have a couple of internal disks and network SAN Storage and wanted to know how they compare. So looked on the Net for free Disk IO Benchmark and profiling tools. Tools Iometer Atto CrystalDiskMark Tried a couple of the tools, but the one … Continue reading Technical: Disk – IO – Performance – Disk Benchmark – Tools – DiskMark

Storage Professional Services and Guiding Angels

Introduction Customer Testimonies are not easy to recant or write about.  It is either too ‘soapy’ or critical; a bit forced either way. So let me try writing one without quite doing so. A little over a year ago we were having big performance problems.  Everything was at a standstill. Nothing was moving either way. … Continue reading Storage Professional Services and Guiding Angels