AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Crystal diskmark san8/20/2023 Microsoft Azure (IaaS) Cost Estimator Tool This entry was posted in Performance on Jby Joe Stocker. Note: the blog post also recommends an easy GUI tool that is available here:ĬrystalDiskMark generates sequential & random, read & write loads at your storage system in 512KB and 4KB chunks Many queries jump around randomly in the database, whereas things like backups, bulk loads, and table scans generally work sequentially. -frandom and -fsequential: random versus sequential access.SQL Server does a lot of random stuff in 8KB chunks, and we’re also testing sequential stuff in 64KB chunks. -b8 and -b64: the size of our IO requests in kilobytes.-s120: means the test will last 120 seconds.The more load we throw at storage, the faster it goes – to a point. SQLIO isn’t CPU-bound at all, and you can use more threads than you have processors. -t8 and -o8: means 8 threads with up to 8 outstanding requests at once.-kW and -kR: means we’re testing writes or reads. ![]() Sqlio -kR -t8 -s120 -o8 -fsequential -b64 -BH -LS D:\TestFile.dat Sqlio -kW -t8 -s120 -o8 -fsequential -b64 -BH -LS D:\TestFile.dat Sqlio -kR -t8 -s120 -o8 -frandom -b8 -BH -LS D:\TestFile.dat Sqlio -kW -t8 -s120 -o8 -frandom -b8 -BH -LS D:\TestFile.dat ![]() Then you can run a longer 120 second test by creating a batch file containing these entries: Then you can do a quick 10 second run with this syntax:Ĭ:\Program Files (x86)\SQLIO>sqlio.exe -kW -s10 -fsequential -t8 -o8 -b8 -LS -Fparam.txt timeout /T 10įor comparison my C drive is a Corsair Force GS and scored 210mb/s with 27k IOPS and my D drive is a OCZ-Vertex and scored 135mb/s and 17k IOPS (Where 20480 is a 20gigabyte file that will get created on the D:\ drive) It walked through using SQLIO to test disk performance.īasically, you just modify the param.txt file like this: ![]() I came across an excellent blog article on disk performance testing:
0 Comments
Read More
Leave a Reply. |