What are the best counters or KPIs to identify what dirves woudl benefit from EFD’s and can be used to reflect before and after performance metrics?
Posted by: Denny Cherry
SQL Server, Storage
EFDs (Enterprise Flash Disks) or SSDs (Solid State Disks) are all the rage today for systems which have very high IO load requirements. But knowing if your disks would benefit from this technology can be a bit of a problem if you don’t know where to look. After all these disks are not cheap.
Some perfmon settings that you’ll want to look at include the seconds per operation, operations per second, disk queue. Now if you are in a SAN environment you will also want to look at the metrics which the array presents to confirm that the problem is actually on the array side and not just a problem of the server.
However if the server has its own disks on the storage array, and the array numbers match what the server is seeing then it may be time to look at EFDs or SSDs for your disk solution.