Script to help check performance and bottle necks

  • Lord Slaagh

    SSCertifiable

    Points: 5603

    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

    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

    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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply