Home > Storage > PowerFlex > White Papers > Dell APEX Block Storage for Azure: SQL Server 2022 Multi-Subnet Failover Clustering Deployment and Resiliency > Validate shutdown of active SQL server node
In this scenario, we validate a failover scenario by shutting down the active SQL Server role node serving database transactional workload generated by HammerDB.
Use Failover Cluster Manager > Roles > SQL Server role (node1) as shown in the following figure:
The current owner is SQLNODE-01.
HammerDB tool is used for generating the database transactional workload on the cluster, and while the workload was running, we shut down the node1 services.
Go to Azure Portal > Virtual Machines> PF-SQL-Node1 > stop (Stop services on node 1) as shown in the following figure:
Microsoft Windows Failover cluster service detects the node failure and automatically fails over to a secondary node. Resources are automatically brought online on the new primary node as shown in the following figure:
During the failover process, the active HammerDB connection is disconnected while the resources are being moved to a secondary node.