MS SQL: New ways to test disk performance

Sometimes things get easier, better or simples. Actually we became spoiled to expect this kind of evolution from everything in the world, and this is not always the case. But sometimes it is. Jokes aside, a while ago I opted for simpler tools to do performance tests that are easier to translate into real-world examples, and recently one of these tools has got a revamp in functionality and this new and updated version is worth testing.

The tool is CrystalDiskMark, wich has been updated in version 4 to use a new framework to do it’s testing (Microsoft DiskSpd).

It’s good to be able to keep it simple, but if we need anything more detailed you can also go directly to the bones of it and use the new DiskSpd directly and with more control. This is a great article that I wanted to share with you, please take your time to read it and apply it to your database servers: http://sqlperformance.com/2015/08/io-subsystem/diskspd-test-storage

cya!

 

Advertisements

About mauriciorpp

Hi, I am Piccolo - but not the one from Dragon Ball. I'm from a highly competitive and fast-paced world too, the IT industry, and this space will be used to share some challenges I face daily on my career. As you will see, I don't do brawls but I need to be a fighter! Stay tuned.
This entry was posted in SQLServer, Windows and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s