July 6, 2017 at 8:31 am
I've created a Windows server failover cluster. I've created the Availability groups, created the listener and added a database.
Now, I want to test this.
I know how to simulate a failover at the cluster. However, I want to run some queries. Create a failover. Run the same queries and I should get the same result.
How do I do this? In SSMS, can I run a query and then failover (in windows and in SQL Server and then run the same query? How do I run a query against the listener and not the primary replica ?
All I see is the usual. Open a connection to a server instance and run a select query. However, I want to query secondary replica's database and see if it returns same data after failover. Is this done only outside of SQL Server via ODBC DSN?
A lot to learn. The cluster is built on two Azure VMs running Windows Server 2016 datacenter. The version of SQL Server is 2016 Enterprise.
Thanks.
Things will work out. Get back up, change some parameters and recode.
July 6, 2017 at 9:23 am
Well, it looks like I did a good job. It works!
I ran some tests and it seems like everything is doing well. I was thinking I had to run some queries. Come to find out, it was much easier and straight forward.
Tests complete.
Thanks.
Things will work out. Get back up, change some parameters and recode.
July 7, 2017 at 3:31 am
WebTechie - Thursday, July 6, 2017 8:31 AMHello,I've created a Windows server failover cluster. I've created the Availability groups, created the listener and added a database.
Now, I want to test this.
I know how to simulate a failover at the cluster. However, I want to run some queries. Create a failover. Run the same queries and I should get the same result.
How do I do this? In SSMS, can I run a query and then failover (in windows and in SQL Server and then run the same query? How do I run a query against the listener and not the primary replica ?
All I see is the usual. Open a connection to a server instance and run a select query. However, I want to query secondary replica's database and see if it returns same data after failover. Is this done only outside of SQL Server via ODBC DSN?
A lot to learn. The cluster is built on two Azure VMs running Windows Server 2016 datacenter. The version of SQL Server is 2016 Enterprise.
Thanks.
Check my stairway to AlwaysOn starting at this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply