Пікірлер
@depanderbhardwaj4961
@depanderbhardwaj4961 Ай бұрын
If lease timeout is happening then wat is the solution?
@chandustechnet4214
@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.
@ArokiyaAnandKumar
@ArokiyaAnandKumar 2 ай бұрын
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
@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
@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
@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
@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
@telugutechgamerz1819
@telugutechgamerz1819 2 ай бұрын
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?
@queenbella4535
@queenbella4535 2 ай бұрын
Great explanation
@manishkambleofficial
@manishkambleofficial 2 ай бұрын
Try Hindi Series Also Please
@Shaolin80000
@Shaolin80000 3 ай бұрын
Great video. Thanks
@reddynaresh-bl1rh
@reddynaresh-bl1rh 3 ай бұрын
Thanks brother it is helpful 🙏👍
@nareshchennoj4221
@nareshchennoj4221 4 ай бұрын
🎉
@sqltechzpestechz7053
@sqltechzpestechz7053 4 ай бұрын
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??
@chandustechnet4214
@chandustechnet4214 4 ай бұрын
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-p7v
@FardinNoman-p7v 5 ай бұрын
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.
@chandustechnet4214
@chandustechnet4214 5 ай бұрын
Service accounts should be domain accounts.
@sinchana9358
@sinchana9358 5 ай бұрын
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...
@chandustechnet4214
@chandustechnet4214 5 ай бұрын
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_sql5321
@satish_sql5321 6 ай бұрын
its a great help slow learners, as the teaching method is like peeling banana and eating... Awesome patience with expert knowledge..
@chandustechnet4214
@chandustechnet4214 6 ай бұрын
Thanks for the feedback
@satish_sql5321
@satish_sql5321 6 ай бұрын
at 8:00 we can see db1 and db1_log
@chandustechnet4214
@chandustechnet4214 6 ай бұрын
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-09
@Ganeshay-09 6 ай бұрын
how to add new availibity group wizard in always on high availablity becose not showing
@chandustechnet4214
@chandustechnet4214 6 ай бұрын
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
@goguladhananjineyulu3174
@goguladhananjineyulu3174 8 ай бұрын
THANK YOU SO MUCH ANNA 😍🥰
@sriharibandi2907
@sriharibandi2907 8 ай бұрын
Super explanation and really helpful
@chandustechnet4214
@chandustechnet4214 8 ай бұрын
Glad it was helpful!
@ShubhenduKumarKundu
@ShubhenduKumarKundu 8 ай бұрын
After successful synchronized, secondary database shown restoring mode. How do I get back in normal mode with synchroinized?
@chandustechnet4214
@chandustechnet4214 8 ай бұрын
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.
@thanuhari688
@thanuhari688 8 ай бұрын
Nice explained sir but last few seconds some confusion sir ..whether we need to take log backup from primary to secondary to restore sir ??
@chandustechnet4214
@chandustechnet4214 8 ай бұрын
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.
@labibchy9293
@labibchy9293 9 ай бұрын
how to connect with you ?
@chandustechnet4214
@chandustechnet4214 9 ай бұрын
You can contact me on, [email protected]
@labibchy9293
@labibchy9293 9 ай бұрын
how to connect for training ?
@chandustechnet4214
@chandustechnet4214 9 ай бұрын
You can contact me on, [email protected]
@labibchy9293
@labibchy9293 9 ай бұрын
hi Chandu is there anyway to connect with you on whatsapp ? amazing tutorial love it
@chandustechnet4214
@chandustechnet4214 9 ай бұрын
You can contact me on, [email protected]
@sandykalyan7124
@sandykalyan7124 10 ай бұрын
Hi brother can you do vedio on what are all the queries we use daily as a MSSQL DBA❤
@chandustechnet4214
@chandustechnet4214 10 ай бұрын
Sure, thank you.
@AjayKumar-c2h2q
@AjayKumar-c2h2q 10 ай бұрын
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
@chandustechnet4214
@chandustechnet4214 10 ай бұрын
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.
@thanuhari688
@thanuhari688 8 ай бұрын
Azure sql have u stared any batch sir ??kindly let me know sir
@chandustechnet4214
@chandustechnet4214 8 ай бұрын
Sure, thanks
@srinathrana8332
@srinathrana8332 10 ай бұрын
Dear Chandu Sir, Kindly post video on widows Cluster.
@chandustechnet4214
@chandustechnet4214 10 ай бұрын
𝚂𝚞𝚛𝚎, 𝚝𝚑𝚊𝚗𝚔𝚜
@Greatest.Everrr
@Greatest.Everrr 10 ай бұрын
Very good explanation 👏
@Ameeralitp
@Ameeralitp 11 ай бұрын
you are repeating too many times. which i hate it in your video
@chandustechnet4214
@chandustechnet4214 11 ай бұрын
Thanks for the feedback. Will try not to repeat. I just wanted to make sure that everyone understands clearly.
@JSunilKumar0508
@JSunilKumar0508 11 ай бұрын
How to troubleshoot 927 error in Database Mirroring ?
@chandustechnet4214
@chandustechnet4214 11 ай бұрын
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.
@JSunilKumar0508
@JSunilKumar0508 11 ай бұрын
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.
@chandustechnet4214
@chandustechnet4214 11 ай бұрын
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-s5q
@karthicksekar-s5q 11 ай бұрын
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
@VeeVeeSarathi
@VeeVeeSarathi 11 ай бұрын
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?
@chandustechnet4214
@chandustechnet4214 11 ай бұрын
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.
@ssk3532
@ssk3532 11 ай бұрын
Thanks😊
@ssk3532
@ssk3532 11 ай бұрын
Great👏
@vijayBomma-y1c
@vijayBomma-y1c 11 ай бұрын
Execellent explanation
@kuswas_rr
@kuswas_rr Жыл бұрын
🙏
@kuswas_rr
@kuswas_rr Жыл бұрын
I learnt something new because of you... thank you..
@shivajisriram5782
@shivajisriram5782 Жыл бұрын
log_reuse_wait_desc as replication where the database is participating in always on not in replication - how to fix
@chandustechnet4214
@chandustechnet4214 Жыл бұрын
Did you check if CT or CDC enabled? You would not see replication if it's just Alwayson configured.
@ImranKhan-er4od
@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
@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.
@sumankumar5647
@sumankumar5647 11 ай бұрын
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??
@itechnicalstudy
@itechnicalstudy Жыл бұрын
Very nice explanation
@chandustechnet4214
@chandustechnet4214 Жыл бұрын
Thank you
@narareddy770
@narareddy770 Жыл бұрын
🎉🎉
@abhispidy616
@abhispidy616 Жыл бұрын
Any way to contact you
@abhispidy616
@abhispidy616 Жыл бұрын
Hi chandu, nice teaching please make more classes
@chandustechnet4214
@chandustechnet4214 Жыл бұрын
Contact me on [email protected]
@prashantbhosale5635
@prashantbhosale5635 Жыл бұрын
Please show how to configure on domain server
@chandustechnet4214
@chandustechnet4214 Жыл бұрын
You mean to configure database mirroring on cluster environment?
@arputhaanish2793
@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
@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
@arputhaanish2793 Жыл бұрын
@@chandustechnet4214 Thank you for your wonderful information.....
@cheddodu6281
@cheddodu6281 Жыл бұрын
Bro your explaining like spoon feeding that was appreciable
@chandustechnet4214
@chandustechnet4214 Жыл бұрын
Glad you liked it
@mufayt
@mufayt Жыл бұрын
I have an issue our nav not connecting data base after it's suspected
@chandustechnet4214
@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
@ImranKhan-er4od Жыл бұрын
Can database be removed from AG on primary ?
@chandustechnet4214
@chandustechnet4214 Жыл бұрын
Yes, you can remove the database from the secondary and/or primary as well.