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

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

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

Hi,

Do you need more help on this ?

Regards,
    Tomas Helgi