Thank you so much. I have a web application for my clinic that uses MS-SQL SERVER and sometimes it gets extremely slow. Any idea what might cause that?! Thank you.
Sorry I don't have much expertise on this. There can be multiple reasons 1. The internet itself might be slow at that time 2. There can be some issue with web app 3. If we talk about SQL Server, may be there are some maintenance tasks like database backups are going on or index rebuild or statistics updates are going some, thus may be due to some maintenance task it can be slow. I think only a DBA can take a look at it and can tell the reason when it is slow.
@@abdullahquhtani4247 Sorry currently I don't provide any consultation. I just focus on my day job and in the spare time I try to make some videos for youtube.
Please explain about lock commands and after finding blocking session what are the next steps. Only killing that blocking Id or any other further steps.
Amazing, with simple tricks. Good work Bro. Thanks for the video.
Thank you Abhilash, sorry for replying so late on this.
Best video easy to understand
Thank you.
Hi @learnsis Can you please tell proc sniff as one of the proc running in the production is taking time due to sniff
thanks for your video.This helps me a lot.Appreciate your great efforts
You are most welcome Abraham.
Thank you so much. I have a web application for my clinic that uses MS-SQL SERVER and sometimes it gets extremely slow. Any idea what might cause that?!
Thank you.
Sorry I don't have much expertise on this. There can be multiple reasons
1. The internet itself might be slow at that time
2. There can be some issue with web app
3. If we talk about SQL Server, may be there are some maintenance tasks like database backups are going on or index rebuild or statistics updates are going some, thus may be due to some maintenance task it can be slow. I think only a DBA can take a look at it and can tell the reason when it is slow.
@@learnssis Thank you. BTW, in case we need consultation or (PAID) remote help, you have time and willingness to do so?!
@@abdullahquhtani4247 Sorry currently I don't provide any consultation. I just focus on my day job and in the spare time I try to make some videos for youtube.
You are doing great work BRO
Thank you Junaid.
Thank you bro..crystal clear❤
Thank you.
Nice video, thanks 👏
Thank you Ram.
Great work 👍
Thank you so much for your appreciation.
if 1 session in running state and my session is blocked by running session , shall i kill that session or not
If that session is not important then you can kill it.
@@learnssis if it matters
@@haneeshreddy3166 If the session is important then wait for another process to finish then the blocking will finish automatically.
Please explain about lock commands and after finding blocking session what are the next steps. Only killing that blocking Id or any other further steps.
Okay, sure in coming videos on SQL I will try to cover those.
@@learnssis Thanks bro.
Thank you soo much.. Please tell me how recover data from accidentally deleted from the tables in sqlserver
I actually never tried that but may be below blog can help you
dzone.com/articles/recover-deleted-data-from-sql-table-using-transact
Thanks for the quick response 😊
@@ajaswanth2219 No problem.
@@ajaswanth2219 no problem.