Script to help check performance and bottle necks

• Lord Slaagh

  SSCertifiable

  Points: 5603

  More actions

  February 21, 2020 at 5:05 pm

  Go to Answer

  #3727770

  Hello SSC and Happy Friday!

  I am looking for an "all in one" script that can help me identify bottlenecks and performance issues on my SQL Servers. We have versions ranging from 2008R2 - 2016. I have been using Activity Monitor, sp_who, sp_who2, sp_who active, etc. But I find the results are difficult to understand. I can identify blocking/locking and things of that nature, but I am looking for a script that gives me only the relevant information that I need.

  I am new to this DBA thing, I have been a SQL developer for over 12 years and switched to DBA so I can remain competitive in an ever changing industry.

  Everyone has a plan until they get punched in the mouth. --Mike Tyson

• Phil Parkin

  SSC Guru

  Points: 244137

  More actions

  February 21, 2020 at 5:09 pm

  Answer

  #3727773

  Are you familiar with this stuff?

  I've found it helpful, despite being a developer rather than a DBA.

  If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

• Lord Slaagh

  SSCertifiable

  Points: 5603

  More actions

  February 21, 2020 at 5:20 pm

  #3727775

  Hi Phil,

  Nice to hear from you. We are actually waiting for approval on this, but for now I am looking for something quick and dirty.

  Thanks for your responses as usual. Hope all is well!

  Everyone has a plan until they get punched in the mouth. --Mike Tyson