Before SQL 2016 we have a feature called data collection which will collect High CPU/Memory utilisation queries if we don't have a monitor tool in place.
Yes it's there however it was not so handy when it comes to rescue. But still I will consider this and thanks for bringing up. Well, to be honest I am taking these sessions on the fly with out any preparation so there are chances to miss a few.
AFTER WATCHING THIS VIDEO, I GOT GOOD INFORMATION ABOUT TROUBLESHOOTING. THANK YOU
Great insights on the common interview Q&A's and deep insights on troubleshooting . Thank you for sharing with wider community !
Glad you liked it. There are 152 videos what I made till now with another 48 videos to go
Its Really nice video Vamsy, and have tips to convey in intw point of view as well..way to go..I connect with you offline soon.
Database health check detection will applies for entire AG, it will failover entire AG if any one DB not healthy.
how only single DB will failover ?
Good session , got valuable information
Harsha answer to to your question is failover threshold limit execeeded but allow failback option is checked due to that also it will come...
Thanks Vamsy
Before SQL 2016 we have a feature called data collection which will collect High CPU/Memory utilisation queries if we don't have a monitor tool in place.
Yes it's there however it was not so handy when it comes to rescue. But still I will consider this and thanks for bringing up. Well, to be honest I am taking these sessions on the fly with out any preparation so there are chances to miss a few.
@@vamsychiranjeevi9619 These videos are really helpful. Thank you very much for uploading them.
can you SHARE the word documents with the questions/answers ?