Tag Archives: testing

High Availability Lab: Adding dual Ethernet NIC yields big improvements

Posted on 8. November 2017 by admin

I have a lab that includes: Two standalone SQL Server 2014 instances One standalone SQL Server 2017 instance running on Linux Thee 2016 instances that are part of an availability group A 2016 failover cluster instance with two nodes A … Continue reading →

Posted in AlwaysOn, SQL Server | Tagged , , | Comments Off on High Availability Lab: Adding dual Ethernet NIC yields big improvements

WAN Emulator for Availability Group Testing

Posted on 21. October 2017 by Bennett

I had an unmet need to be able to test my AlwaysOn Availability Groups under less than ideal network conditions.  More specifically I needed a way to add network latency in order to create more realistic monitoring and troubleshooting scenarios. … Continue reading →

Posted in Open Source, SQL Server | Tagged , , , , | Comments Off on WAN Emulator for Availability Group Testing

How to quickly and easily simulate a low disk space scenario

Posted on 14. October 2017 by admin

It turns out that the built in fsutil OS utility can quickly create an empty file of any size.  For example: fsutil file createnew test.txt 1300000000 Will create a file 100 billion bytes in size. For my scenario I needed to … Continue reading →

Posted in Performance, SQL Server | Tagged , , | Comments Off on How to quickly and easily simulate a low disk space scenario