How to identify slow running queries in SQL Server and how to resolved it

Manir Hossen
Manir Hossen used Ask the Experts™
on
How to identify slow running queries in SQL Server and how to resolved it
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
David ToddSenior Database Administrator

Commented:
Hi,

There are a couple of places you can look.

There are builtin-report in SSMS for top queries.

Or you can get Brent Ozar's First Responders kit and use sp_BlitzCache for insight into what is in the query plan cache, you'll get things like missing indexes etc.

HTH
  David
Tomas Helgi JohannssonDatabase Administrator / Software Engineer

Commented:
Hi,

Check out this blog on how to identify slow running queries in SQL Server.

Also as David mentioned use the Brent Ozars First responder kit. It is a very useful package full of scripts and checklists.

Ones you have identified the queries you have to execute explain on them to see where you could tune it either by adding indexes or tweak the part of the query that is producing bad access paths. Access paths especially where full table scans are shown should obviously be the first to tackle and eliminate.

Regards,
    Tomas Helgi
Tomas Helgi JohannssonDatabase Administrator / Software Engineer

Commented:
Hi,

Do you need more help on this ?

Regards,
    Tomas Helgi

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial