


Keep an eye on the free space there – you don’t want to create a test file that can run your server out of drive space. Just know that the bigger the test file, the longer it takes to generate. Smaller test file sizes may look fast but don’t really reflect how a large database will work. If you’re under the gun, do a quick 1GiB test, but for real go-live prep, I like using 32GB to reduce the chances that I’m just hitting cache and getting artificially fast numbers. If you want a fast seat-of-the-pants guess, do 1, but keep in mind it can be wildly variant between passes if something else happens to be going on in the SAN. 1 – the number of test passes you want to run.The zip version can be just saved to a network share, and then anybody can run it from there.Īfter extracting the zip file’s contents, run DiskMark64.exe on an idle server or desktop first (not your live SQL Server, because it’ll slow things down while it runs.) It’ll look like this:Īcross the top, set the first three dropdowns to: The zip version doesn’t require an installer, which is cool because I’m not a fan of installing things on production servers.

There are multiple download links – you want CRYSTALDISKMARK, not CrystalDiskInfo, and you want the Standard Edition, Zip Version. Go to the CrystalDiskMark download page, but PAY CLOSE ATTENTION. (I’ll be charitable and not tell you which one.) Instead, let’s get seat-of-the-pants numbers for your storage. It takes knowledge and time, and you only have one of those. The CrystalDiskInfo application was designed to help you view details about your hard disck drive.I’ve written about how to test your SAN’s performance with SQLIO, but I’ll be honest with you: that’s the hard way. * Monitoring health status and temperature This is all available due to threshold of caution capabilities. The health status is indicated in the main window, and at the press of a button a new window is brought up that enables you to set several slider representing reallocated sectors count, current pending sector count and uncorrectable sector count. It easily gets deployed on your hard disk drive, with little system resources used, offering a great deal of helpful info in return. CrystalDiskInfo is a powerful analysis tool that comes in handy for both beginners and experts alike. Even though it may not seem like it, problems appear and a faulty disk drive can drastically reduce the overall performance of your machine. Hard disk drives are one of the main elements that keep your data alive. CrystalDiskInfo is a HDD/SSD utility which supports S.M.A.R.T.
