This particular result how much time to flush, If example: Application team facing issue on loading transactions into databases from Application to DB so some times job is failed and some was successfully imported so is it helpful to identify anything to analyse
Easy to Understand, very well explained. I have 4 doubts : (1) in Login_Time , how will we come to know that for how long a particular query is running. (Do we need to subtract the coming time from the Current Now Time ) ? (2) If you can explain the Execution Plan diagram in respect of COST like Cost is 22% for Sort , and 77% for Hash Match (Inner Join) in the current scenario that tou have shared. (3) Will it show us the number of queries being executed / List of queries being executed like in above you have QueryText , so if in a case 4-5 queries are causing the performance issue , so will we get 4-5 rows aa output while running this Script ? (4) How to know whether the query that caused the issue have fired any Trigger or Stored Procedure ? A bit lengthy, but that's what is currently required. Hoping to get the answers 😊 Thank you once again.!!
For 1,3 and 4 - start using Query Store features... Enable on ur db... It will solve easy way.. 2- mostly you can see cost and scan type In best case index seek scan is good. Also can see actual no of rows and estimated no of rows should be same. There are many more parameters which helps u from execution plan.
Hey please change latest video description.. There u will get a shared location... Placed all docs, query there... Thanks for support.. Plz contribute TH-cam Thanks
Hey please change latest video description.. There u will get a shared location... Placed all docs, query there... Thanks for support.. Plz contribute TH-cam Thanks
I appreciate the great work you're doing. thank you
Thank you... You can check playlist of channel and join as menner
What if the this select command run by client side system and how to fetch this type of info 🤔
This particular result how much time to flush,
If example: Application team facing issue on loading transactions into databases from Application to DB so some times job is failed and some was successfully imported so is it helpful to identify anything to analyse
Easy to Understand, very well explained.
I have 4 doubts :
(1) in Login_Time , how will we come to know that for how long a particular query is running.
(Do we need to subtract the coming time from the Current Now Time ) ?
(2) If you can explain the Execution Plan diagram in respect of COST
like Cost is 22% for Sort , and 77% for Hash Match (Inner Join) in the current scenario that tou have shared.
(3) Will it show us the number of queries being executed / List of queries being executed like in above you have QueryText , so if in a case 4-5 queries are causing the performance issue , so will we get 4-5 rows aa output while running this Script ?
(4) How to know whether the query that caused the issue have fired any Trigger or Stored Procedure ?
A bit lengthy, but that's what is currently required.
Hoping to get the answers 😊
Thank you once again.!!
For 1,3 and 4 - start using Query Store features... Enable on ur db... It will solve easy way..
2- mostly you can see cost and scan type
In best case index seek scan is good. Also can see actual no of rows and estimated no of rows should be same. There are many more parameters which helps u from execution plan.
It is Really helpful to us
we need this query..
How to check Sp id Bro
Thank you.
Pls, where i can i find this query? thank you
You can check in latest video description... Shared location link you will get it.. Thanks plz join as member..
Where can we get the query, thanks for this, it was helpful
Hey
please change latest video description.. There u will get a shared location... Placed all docs, query there...
Thanks for support.. Plz contribute TH-cam Thanks
thanks
Hey
please change latest video description.. There u will get a shared location... Placed all docs, query there...
Thanks for support.. Plz contribute TH-cam Thanks