Posts

Showing posts with the label SQL Server AWS

AWS I3 Instances for Demanding I/O Intensive Applications that like Super Fast Disk

Image
I had some time at AWS re:invent to play with these I3 instances and a few others which are designed for I/O intensive workloads and are equipped with super fast NVMe SSD storage.  These instances can deliver lots of fast read and write IOPS making them a great fit for any workload that requires high throughput and low latency including relational databases for Microsoft SQL and Oracle databases server. When compared to the I2 instances, I3 instances deliver storage that is less expensive and more dense, with the ability to deliver substantially more IOPS and more network bandwidth per CPU core.  Additional, if you take advanatage of the  I will show some of the Read and Write benchmarks using the  Diskspd Utility : A Robust Storage Testing Tool (superseding SQLIO) with DiskSpd Batch that was created by HeraFlux Technologies which can be found HERE    as well as the quick button push of CrystalDiskMark.  So if you want to see all the numbers ...