If lease timeout is happening then wat is the solution?
@chandustechnet4214Ай бұрын
@@depanderbhardwaj4961 lease thread is a high priority thread. If it expires, there are high chances system wide performance issues like high CPU or High memory, sql is unresponsive or windows cluster has some issues or windows cluster is stuck/rhs.exe deadlock etc.. You need to examine the overall server wide performance (not just sql process) or cluster level issues. For a temporary mitigation you can always increase the lease timeout.
@ArokiyaAnandKumar2 ай бұрын
Thank you Mr. Chandu, Your explanation was fantastic. But My issue is I have 2 different system, in both system have [NT Authority/System] . I have tried the below Script GRANT CONNECT ON ENDPOINT:: MIRRORING to [NT AUTHORITY\SYSTEM] But after if I executing the mirroring Same 1418 error is coming I try to check in sp_readerrorlog 2024-11-28 11:11:52.060 Logon Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed with error: 'Connection handshake failed. The login 'NT AUTHORITY\ANONYMOUS LOGON' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: 172.16.29.110] NT AUTHORITY\ANONYMOUS LOGON Can you please guide me where I have to fix this issue.
@merjt14Ай бұрын
I was having the same problem, the only thing i came up was to create NT AUTHORITY\ANONYMOUS LOGON login and give it CONNECT permission on both servers, i don't know if it is something that can be done but it worked for me, even though i'm still looking for another way to solve it
@merjt14Ай бұрын
Oh, another solution i found was to use .\Administrator instead of NT Service\MSSQL$SERVER01 for Log On As i both servers, i think it can work by using another windows account but keeping the same passwords in both servers. I didn't went for this because i was using a SCADA database and didn't wanna move something that may alter the application
@chandustechnet4214Ай бұрын
Is it your test machine or your personal laptop and learning? Is SQl service running under the default account and/or the local system account? Please give sysadmin to the SQL service account (create both service accounts if different) and check. If it's a domain computers, suggest you to use the domain logins and fix SPNs if any.
@chandustechnet4214Ай бұрын
I still recommend to use domain accounts. If you're using admin accounts. Then you need to add admin login both the servers. Ex: Server1/administrator and server2/administrator with required permissions
@telugutechgamerz18192 ай бұрын
Hi , I have question as per the video you have mentioned that taking backup of seconday datafile why can't we take the backup of transactional log when datafile has been and restore it in to the secondary server with move option instead taking the ndf file level backup?In this case log file has secondary datafile information and we can restore it in to the seconday database with move option?It would be great if any clarification?
@queenbella45352 ай бұрын
Great explanation
@manishkambleofficial2 ай бұрын
Try Hindi Series Also Please
@Shaolin800003 ай бұрын
Great video. Thanks
@reddynaresh-bl1rh3 ай бұрын
Thanks brother it is helpful 🙏👍
@nareshchennoj42214 ай бұрын
🎉
@sqltechzpestechz70534 ай бұрын
Thank you very much… just one thing to clear if we use the ‘Join only’ option then we have to restore a log backup also with ‘no recovery’ option correct??
@chandustechnet42144 ай бұрын
Correct. You will have to restore required log backups with norecovery. Make sure, log backup jobs are disabled until the secondary is in sync.
@FardinNoman-p7v5 ай бұрын
When I will implement database mirroring in 2 different server then what are the things I have to mention in service accounts? There are 2 options one is principle & another one is mirroring. Whether i have to put server name or anything else just clear this part. Thanks.
@chandustechnet42145 ай бұрын
Service accounts should be domain accounts.
@sinchana93585 ай бұрын
Very nice explanation thanks... could u please tell what happens in asynchronous commit and when the data in the log file will be deleted.. it gets deleted after updating to data file or after receiving harden acknowledge from secondary or both.... please let me know on this...
@chandustechnet42145 ай бұрын
The logs will not be truncated unless the data is available in the data file. If you have a log send queue (logs are not hardened on secondary) or redo queue (logs are hardened on secondary but not yet redo to the data file) the logs will not be truncated. In both the cases you would see the Availability_Replica wait type. Async replicas behavior is only for commit (primary will not wait for ack from secondary to commit) the log truncation behavior is same. I believe understood your question correctly and answered. If not, please add your comment.
@satish_sql53216 ай бұрын
its a great help slow learners, as the teaching method is like peeling banana and eating... Awesome patience with expert knowledge..
@chandustechnet42146 ай бұрын
Thanks for the feedback
@satish_sql53216 ай бұрын
at 8:00 we can see db1 and db1_log
@chandustechnet42146 ай бұрын
Thanks for checking. I've created a folder called DB1 and inside we've database files on Node1 and it doesn't exist on node 2. That's the issue.
@Ganeshay-096 ай бұрын
how to add new availibity group wizard in always on high availablity becose not showing
@chandustechnet42146 ай бұрын
What do you mean by adding a new availability group wizard? If you enable alwayson feature from configuration manager, you should be able to configure alwayson from SSMS
@goguladhananjineyulu31748 ай бұрын
THANK YOU SO MUCH ANNA 😍🥰
@sriharibandi29078 ай бұрын
Super explanation and really helpful
@chandustechnet42148 ай бұрын
Glad it was helpful!
@ShubhenduKumarKundu8 ай бұрын
After successful synchronized, secondary database shown restoring mode. How do I get back in normal mode with synchroinized?
@chandustechnet42148 ай бұрын
Need to look into the logs to understand the issue. But just a couple of generic checks, make sure both principal and mirror are on the same build/version. Please check the algorithm you're using and make sure it's AES but not RC4 algorithm.
@thanuhari6888 ай бұрын
Nice explained sir but last few seconds some confusion sir ..whether we need to take log backup from primary to secondary to restore sir ??
@chandustechnet42148 ай бұрын
Yes, but depends on the issue. If you wanted to remove database from secondary and wanted to reseed. Please try with log backups first than restoring the entire database.
Hi brother can you do vedio on what are all the queries we use daily as a MSSQL DBA❤
@chandustechnet421410 ай бұрын
Sure, thank you.
@AjayKumar-c2h2q10 ай бұрын
sir please keep posting videos...don't stop.. it's very helpful in learning... or please share a channel where we can join online classes
@chandustechnet421410 ай бұрын
Sure, thanks for the feedback. Not getting time, will start uploading. I will let you know if I start a new batch for alwayson. Currently performance tuning batch has started.
@thanuhari6888 ай бұрын
Azure sql have u stared any batch sir ??kindly let me know sir
@chandustechnet42148 ай бұрын
Sure, thanks
@srinathrana833210 ай бұрын
Dear Chandu Sir, Kindly post video on widows Cluster.
@chandustechnet421410 ай бұрын
𝚂𝚞𝚛𝚎, 𝚝𝚑𝚊𝚗𝚔𝚜
@Greatest.Everrr10 ай бұрын
Very good explanation 👏
@Ameeralitp11 ай бұрын
you are repeating too many times. which i hate it in your video
@chandustechnet421411 ай бұрын
Thanks for the feedback. Will try not to repeat. I just wanted to make sure that everyone understands clearly.
@JSunilKumar050811 ай бұрын
How to troubleshoot 927 error in Database Mirroring ?
@chandustechnet421411 ай бұрын
What's the SQL version? Please check if you've any pending logs to be restored. It's not an error or issue, if the LSN should be in sync with the primary. Make sure that no log backup jobs running on primary while configuring mirroring. Restore necessary logs and then configure.
@JSunilKumar050811 ай бұрын
Principle Server: SQL 2017 Developer Edition Mirror Server: SQL 2019 Developer Edition. Took one Full & one Transaction log backups from Principle Server, same Restored in Mirror server. Then configured. Observed 927 error.
@chandustechnet421411 ай бұрын
Please share the error message and check if any logs pending to restore. To isolate the issue, you can create a test database and try to configure. **Make sure that database mirroring endpoint encryption algorithm configured with AES but not RC4.
@karthicksekar-s5q11 ай бұрын
Can you share us a query to get failover reason using extended events. I tried many but not giving what i expect. For eg if it failover due to lease timeout issue it should say AG failover due to lease timeout issue
@VeeVeeSarathi11 ай бұрын
Hi Guys It Worked. But i cannot Open the Mirrored Database after the mirroring process. it Says The database TestMirror is not accessible. (ObjectExplorer) any Solutions?
@chandustechnet421411 ай бұрын
What do you mean "you cannot open the mirrored database", you cannot access the mirrored database because it's always in restoring state. You can access only the principal.
@ssk353211 ай бұрын
Thanks😊
@ssk353211 ай бұрын
Great👏
@vijayBomma-y1c11 ай бұрын
Execellent explanation
@kuswas_rr Жыл бұрын
🙏
@kuswas_rr Жыл бұрын
I learnt something new because of you... thank you..
@shivajisriram5782 Жыл бұрын
log_reuse_wait_desc as replication where the database is participating in always on not in replication - how to fix
@chandustechnet4214 Жыл бұрын
Did you check if CT or CDC enabled? You would not see replication if it's just Alwayson configured.
@ImranKhan-er4od Жыл бұрын
Thanks for the nice explained video tutorial. So for SQL Server 2012 onwards, IsAlive and Looks Alive not use for health checks?
@chandustechnet4214 Жыл бұрын
Yes, starting from SQL 2012 we have more thorough check using sp_server_diagnostics. You can consider "looks alive" check is "lease timeout" and "Isalive" is a "health check timeout" which executes sp_server_digsignostics.
@sumankumar564711 ай бұрын
This vedios are best tutorial vedioes whatever I have gone through in my life. This is one of thoughest/confusing topics in Cluster. You cleared out douts easily!! Thanks for sharing vedios. I can see only 15 vedios on this channel. Is more vedios are available for paid subscriber??
You mean to configure database mirroring on cluster environment?
@arputhaanish2793 Жыл бұрын
Hi sir... I am facing the log send rate too low.... So the log size also increases and log send queue is increasing...... What the solution here
@chandustechnet4214 Жыл бұрын
Check the flow control from performance counters. It happens because of the flow control. You can restart the endpoint on secondary which will reset the flow control threshold and will increase the send rate
@arputhaanish2793 Жыл бұрын
@@chandustechnet4214 Thank you for your wonderful information.....
@cheddodu6281 Жыл бұрын
Bro your explaining like spoon feeding that was appreciable
@chandustechnet4214 Жыл бұрын
Glad you liked it
@mufayt Жыл бұрын
I have an issue our nav not connecting data base after it's suspected
@chandustechnet4214 Жыл бұрын
If the primary database status is suspect, application would not be able to connect. Action you may have to perform are: 1. remove database from alwayson 2. After removed the database from primary, check if synchronous secondary can bring it online, so that application connection redirect to connect to the secondary replica 3. If step 2 doesn't work. Restore from backup or repair the database
@ImranKhan-er4od Жыл бұрын
Can database be removed from AG on primary ?
@chandustechnet4214 Жыл бұрын
Yes, you can remove the database from the secondary and/or primary as well.