Tag Archives: AlwaysOn

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

AlwaysOn Availability Group Aware SQL Agent Job Step

Posted on 6. May 2017 by Bennett

The SQL Agent job step that I present here is intended to make a job execute only if the node currently owns a specified replica. The T-SQL for this job step leverages a function that was published in SQL Server … Continue reading →

Posted in SQL Server, T-SQL, Uncategorized | Tagged | Comments Off on AlwaysOn Availability Group Aware SQL Agent Job Step