Very informative and very useful troubleshooting scenarios. also please replicate following issue and try to troubleshoot this scenarios. (due to its nature of the error this has multiple scenarios in itsetlf) Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=0; handshake=14999; (Microsoft SQL Server, Error: -2)
Hi.. Our SQL always on setup (win 2019) with quorum disk is switching frequently (2-4 times a week) automatically. Network looks all OK.. ping responses are all OK at the time of switching. All 3 servers are in local network. Not able to get to the root cause. any help?
Hi, I am facing a issue on AOAG. we have 3 nodes server and 2 are in synchronous commit and another is in asynchronous commit mode in the weekend the 3rd node (Asynchronous) is terminated from primary replica for few seconds and after that it will get connected automatically it's on AWS EC2 instances i am not able to find the solution could you please help me out for this issue?
If my AG is Asynchronous commit & fail over mode is manual and if my both Server is restarted what happens to AG is my AG will be healthy after restart
if it is graceful restart then the databases will need to go through crash recovery for primary and secondary replicas. Post that the databases will come online on primary and on secondary if not we need to resume them
hi sir, i've configure sql server 2109 always on on window server 2022 it's work smoothly but when i turn on window firewall all database not synchronize i try to allow many port but it's still got issue, please kindly help guide thanks
Big thumbs up Vamsy, your videos are thorough and effective,
Cheers
Glad you like them and it's my pleasure
Learning many things from your videos thanks for sharing :)
Very informative and very useful troubleshooting scenarios.
also please replicate following issue and try to troubleshoot this scenarios. (due to its nature of the error this has multiple scenarios in itsetlf)
Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.
This could be because the pre-login handshake failed or the server was unable to respond back in time.
The duration spent while attempting to connect to this server was - [Pre-Login] initialization=0; handshake=14999; (Microsoft SQL Server, Error: -2)
Simply Superb:)
Glad you like them
Learn more from this video
.good job bro
Glad to hear that
Excelent explanation👏
Thank u Vamshi
Hi.. Our SQL always on setup (win 2019) with quorum disk is switching frequently (2-4 times a week) automatically. Network looks all OK.. ping responses are all OK at the time of switching. All 3 servers are in local network. Not able to get to the root cause. any help?
Hi,
I am facing a issue on AOAG. we have 3 nodes server and 2 are in synchronous commit and another is in asynchronous commit mode in the weekend the 3rd node (Asynchronous) is terminated from primary replica for few seconds and after that it will get connected automatically it's on AWS EC2 instances i am not able to find the solution could you please help me out for this issue?
Are starting any online classes vamsi ?
Hi sir, Good evening, By when your new online batch will start?
Hello, Thanks for your interest. Can you ping me on my WhatsApp +91-9739093905?
If my AG is Asynchronous commit & fail over mode is manual and if my both Server is restarted what happens to AG is my AG will be healthy after restart
if it is graceful restart then the databases will need to go through crash recovery for primary and secondary replicas. Post that the databases will come online on primary and on secondary if not we need to resume them
hi sir, i've configure sql server 2109 always on on window server 2022 it's work smoothly but when i turn on window firewall all database not synchronize i try to allow many port but it's still got issue, please kindly help guide thanks
Did you run Test-netconnection on those ports?
Sir, What about all job when it's failover
I took a class on how to take care of the jobs when it gets failed over
Please upload this video, is there any scripts when it’s failover primary jobs will be enabled and secondary jobs will be disable