Thanks a lot Phil, Michael and Bran for your incredible help and guidance. You guys have very well understood all my concerns and provided me exactly what I needed.

@Phil -...

• This reply was modified 3 years ago by  Abdullah_Madani.

Thanks Mr. Bran for your detailed explanation. You have rightly suggested to use a good monitoring tool. I would be glad if you can advise me with some good tools.

Actually...

Thanks a lot @homebrew01 for pointing out Extended events for me to look into it. I will definitely explore the feature

• This reply was modified 3 years ago by  Abdullah_Madani.