Thank you for your video and script. I used it to find some problematic queries in my application. Especially liked the trick about CAST the execution plan into XML to easily visualize the query. Well done.
Awesome vedio...After expensive query found still customer facing the slowness so in this case on which factors should i focus...? Could you please make an vedio on integrity check DB through jobs by using ole hallengren scripts for particular database ,And through jobs how can we find the checkdb error....?plz help me out..
Finding expensive queries is first step, second step is tuning them, DB integrity check don't confirm performance. For tuning queries refer this video ruclips.net/video/t2R0-xcKw44/видео.html
Sent, kindly check your email. Note: I also provide commercial support. Please contact if needed. If you find this solution helpful than donate comfortable amount on papal to my email ID or link www.paypal.me/bimlamehla. Donation is not mandatory, it is just a request to support free tutorials.
I have implemented Table Partitioning in Azure Sql Server and my table is working fine but sometimes It takes time to retrieve data like in 1 min it retrieves more than 1 lakh records and sometimes i get only 15000 .Please help me on this
Thank you for your video and script. I used it to find some problematic queries in my application. Especially liked the trick about CAST the execution plan into XML to easily visualize the query. Well done.
Glad it helped!
This is an excellent tutorial, I have been looking for a long time.
Glad it was helpful!
Thank you so much for this video, This help me a lot. Could you please share the scripts.
You have to post more and our support always there.
Thank you. You can check second part of video as well, it is short but helpful. ruclips.net/video/5v7ddPrNMFg/видео.html
hello sir , your videos are really helpful , i need to try it out so please share the query script
It's a very interesting session, please share the scripts.
kindly share your email
Good content.
Thank you
This is very helpful. would you mind sharing the script ? Thanks.
sent me mail at yogesh.mehla@gmail.com
Awesome vedio...After expensive query found still customer facing the slowness so in this case on which factors should i focus...?
Could you please make an vedio on integrity check DB through jobs by using ole hallengren scripts for particular database ,And through jobs how can we find the checkdb error....?plz help me out..
Finding expensive queries is first step, second step is tuning them, DB integrity check don't confirm performance. For tuning queries refer this video ruclips.net/video/t2R0-xcKw44/видео.html
Great video, please share the script, it will be helpful
kindly reach me on yogesh.mehla@gmail.com
@@techsapphire please share the script,
Hello, It's very interesting and will help to me. can share the script?
Yes, of course. Kindly mail me at yogesh.mehla@gmail.com
Indeed this session is helpful. Can you share the query.
kindly share your email.
@@techsapphire You can share on arpit.sawarn@gmail.com
Thanks in adavnce!
Sent, kindly check your email.
Note:
I also provide commercial support. Please contact if needed.
If you find this solution helpful than donate comfortable amount on papal to my email ID or link www.paypal.me/bimlamehla.
Donation is not mandatory, it is just a request to support free tutorials.
Hi very good video, very simple to understand. can you please send the script, Thanks
Kindly share your email
Help full topic, please share the script
techsapphire.net/finding-expensive-queries-in-sql-server-and-performance-optimization/
Kindly check link shared and subscribe
I have implemented Table Partitioning in Azure Sql Server and my table is working fine but sometimes It takes time to retrieve data like in 1 min it retrieves more than 1 lakh records and sometimes i get only 15000 .Please help me on this
I cannot suggest without looking into it
@@techsapphire can we connect?
@@techsapphire can we connect?
you can contact with me on yogesh.mehla@gmail.com or +91-9023262520
Good content bro
Appreciate it
Helpful video, could you please share scripts
kirankamthe55@gmail.com
kindly share your email.
Please share the query stats code. Thanks
Kindly check your email.
Hello can you please share query stats code?
Share your email
@@techsapphire jjaikumar45@gmail.com
Thanks in advance 😇
hello, can you send me the code of the script, please?
Kindly share your email
Can you Share the Query
kindly share your email.
Kindly share the script please 🙂🙂
Kindly share your email, or mail me at yogesh.mehla@gmail.com
Can you share the script?
Kindly mail me at yogesh.mehla@gmail.com
Kindly check script on techsapphire.net/finding-expensive-queries-in-sql-server-and-performance-optimization/
Where is that code ?????
Kindly check your email.
Please share the script (code)
kindly share your email or mail me at yogesh.mehla@gmail.com
Kindly share the code.
kindly share your email.
@@techsapphire kensp00@gmail.com
sent kindly check your email.
kindly share the scripts please
Kindly mail me at yogesh.mehla@gmail.com
Can you please send me the code
share your email
Hey, please share the script, it will be helpful. Thanks for the great session.
Kindly share your email.
Please send the script to debashispaul08@gmail.com. Thank you
Please share me the scripts.
bhargavb429@gmail.com
Thank you...
Please, van you share your query to my e-mail:
bmartim@amartim.com
Thank you for sharing your knowledge
Could you please share - indrameshbisoi@gmail.com
pls share the script
kindly share your email.
who have the script please share for me please
Kindly check script on techsapphire.net/finding-expensive-queries-in-sql-server-and-performance-optimization/
Yogesh nice writeup can you send me the scripts used? Have sent email to your gmail already. Appreciate your help here.
I have shared you the scripts. Kindly let me know if your have found them.
@@techsapphire I did not get the scripts can you resend to my gmail? I have sent you a personal from gmail
@@techsapphire my email id is sesha3pv@gmail.com
@@seshadriprasanna7219 sent again
What the fuck you are talking about???? iiddiii bidddiii qudduduu guuuquuqu
hello, can you send me the code of the script, please?
Kindly share your email.
Can you share the Query
Kindly share your email.
Please send me the code
kindly mail me at yogesh.mehla@gmail.com for the queries