Part 1 - How to Troubleshoot a Slow Running Query in SQL Server by Amit Bansal (Recorded Webinar)
Вставка
- Опубліковано 16 чер 2024
- Want access to all our free webinars? Become a free member at SQLMaestros.com and access all the free webinars. sqlmaestros.com/product/free-...
Want to access all our paid webinars? Become a Premium member at SQLMaestros.com and access all the premium content which includes paid webinars & premium tutorials. sqlmaestros.com/product/paid-... - Наука та технологія
very helpful, thanks a lot.do you have more performance tuning videos
Very nice I really like it
Here, you ran the procedure, but how as a dba I would find which are the procedures and sqls are causing the slowness in the background?
Sir can you suggest how to tune the update statement, if it's running slow.
Make sure the tables involved are not over indexed. Make sure you have the right index to accommodate the predicates in your update statement.
G8 Session...)
Haha,, He had shown how to check wait info, He did not show solution for slow running queries...
Actually he did mention that avoiding the sort would solve the problem but if you must have the sort then the solution will be to insert the data from the select statement into a temp table then the sort of that temp table will have accurate statistics and will be super fast.
he didn't give the solution...hahaha...time waste video