Part 1 - How to Troubleshoot a Slow Running Query in SQL Server by Amit Bansal (Recorded Webinar)

Просмотров 26 тыс.

% 374

Want access to all our free webinars? Become a free member at SQLMaestros.com and access all the free webinars. sqlmaestros.com/product/free-membership/
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-membership/

Наука

Опубликовано:

27 апр 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 11

@erfaanmubeen7437 3 года назад

very helpful, thanks a lot.do you have more performance tuning videos

@BubbaNeeta Год назад

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?

@mohammedmustofa8960 11 месяцев назад

Very nice I really like it

@santoshjaiswal9717 2 года назад

Sir can you suggest how to tune the update statement, if it's running slow.

@sakauk7566 Год назад

Make sure the tables involved are not over indexed. Make sure you have the right index to accommodate the predicates in your update statement.

@jainyogesh8 4 года назад

G8 Session...)

@RamPrasad-hd9mm 2 года назад

Haha,, He had shown how to check wait info, He did not show solution for slow running queries...

@sakauk7566 Год назад

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.