Видео

I have got question again, Automatic failover has happened. SLO's like to which transaction and statement has caused the issue and triggered automatic failover? How to prove it is due to Memory\CPU\IO? and which transaction caused the issue. Is there any video which you already made on this? Thank you Sir for any information.

Good job mate!! 👏🏼👏🏼

perfect

Can you do this without a certificate? Thanks.

Can we please have some videos on how to resolve wait issues, such as CX waits.

Thank you for this well needed series. What does it mean when your wait_time is negative?

Thanks, you made this very clear. I will continue to watch until I can teach this to a peer!

Hello Sir, Thanks a lot for the video on AO alerting. I have tried setting up the below alerts and started getting thousands of emails. close to 95,000 emails. May I know the best way to handle this? Also, my second question is, Is it possible to alert (send email) the query which has caused the Latency issues ? ('1480' , 'AG Role Change (failover)') , ('976' , 'Database Not Accessible') , ('983' , 'Database Role Resolving') , ('3402' , 'Database Restoring') , ('19406', 'AG Replica Changed States') , ('35206', 'Connection Timeout') , ('35250', 'Connection to Primary Inactive') , ('35264', 'Data Movement Suspended') , ('35273', 'Database Inaccessible') , ('35274', 'Database Recovery Pending') , ('35275', 'Database in Suspect State') , ('35276', 'Database Out of Sync') , ('41091', 'Replica Going Offline') , ('41131', 'Failed to Bring AG Online') , ('41142', 'Replica Cannot Become Primary') , ('41406', 'AG Not Ready for Auto Failover') , ('41414', 'Secondary Not Connected');

Thank you, its very helpful

Thanks very helpful

I have been working on AO and issues since many years as a DBA. But it is strange that the entire video is completely new for me :-) You have nailed it brother. How do you learn\get this information ? Would you mind sharing the source ? Thanks a ton for this training video. I will try to implement and will see if I can do it.

Great Brother. ❤

May I know what is the best way to setup alerts for Always on? I did try using few links in google but I am getting bulk of emails(close to 90000) to my inbox. Can you make any video for that too in your Always Playlist. Also, I need Merge replication issues and trouble shooting in advance level and secondly, stuck on where\how to start performance tuning. I have been following your videos since your first video. Do let me know if you give training too. Thanks a Ton for all the video trainings.

So Latch is on page level?, Lock is on rowlevel?

Hi, I think rebuilding indexes updates the statistics only for the columns that have an index. For example the statistics that were created by "where" statement - they won't be updated when rebuilding indexes.

hii ... thanks for explaining ... 😊😊

woow.. thank u soo much sir, u explained very well and clear without doubt .. looking for more like this ... 😊😊😊

Why is the volume so low?

I cant hear you speaking even at full volume

This is what I have actually been looking for... More precisely explained.. Thanks a lot...

Nice video, can you make a video of SQL server pages types and working please

Hello sir how did you choose domain name? Is it computer name or else? Please let me know 🙏

Thank you so much sir 😊

Why forced manual fail over needed sir?

very well explained, liked your videos...

very good

Bro your content of this video is awesome but your accent make me difficult to understand even though watching twice same result 😢😢😢

😊great job bro

Could you please share your Email id?

No problem bro. Keep great work.

Good view of whole process thanks

Great Bro. I love your videos. Can you please make a video on query performance tunning?

Thank you sir

Thank you!! For this informative video.

Thank you!! For sharing it.

Thank you for this. Could you please also touch upon LPIM setting and stolen pages perf counter.

Great session. Thank you. If we run backup in SQL server does it utilise buffer pool to copy the files or it reads directly from the disk. Could you please explain

very useful

may you please suggest me a good performance tuning live classes from basics to advanced. Its my request

Great

Very nice tutorial. Thanks

Please increase the voice in these series so that you can hear it more clearly. The voice decreased accidentally while editing.

Please increase the voice in these series so that you can hear it more clearly. The voice decreased accidentally while editing.

Please increase the voice in these series so that you can hear it more clearly. The voice decreased accidentally while editing.

Please increase the voice in these series so that you can hear it more clearly. The voice decreased accidentally while editing.

Please increase the voice in these series so that you can hear it more clearly. The voice decreased accidentally while editing.

Please increase the voice in these series so that you can hear it more clearly. The voice decreased accidentally while editing.

Please increase the voice in these series so that you can hear it more clearly. The voice decreased accidentally while editing.

Please increase the voice in these series so that you can hear it more clearly. The voice decreased accidentally while editing.