Post reply

SQL Performance measuring tools

  • February 17, 2016 at 8:57 pm

    #324921

    Dear All,

    Do we have any to tool to measure SQL Server (2012 or 2014) Performance and/or Database Performance with respect to the I/O Resource usage, Memory consumption, T-SQL execution performance etc.

    Thanks in Advance

    Kishore M. K.

  • February 18, 2016 at 4:03 am

    #1859497

    Perfmon counters: https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

  • February 18, 2016 at 4:06 am

    #1859499

    Extended Events. https://www.simple-talk.com/sql/database-administration/getting-started-with-extended-events-in-sql-server-2012/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 18, 2016 at 5:51 am

    #1859529

    SQL Monitor[/url] might be of interest, if you are prepared to spend money on a solution.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • February 18, 2016 at 6:24 am

    #1859537

    I vote for Idera not cheap but still the best product out there, the snapshot it takes of things tied to alerts is invaluable, I know the Tech Politically Correct think you can have 200 scripts to do the same, sorry this solution much easier to deal with for critical servers

  • February 18, 2016 at 6:30 am

    #1859541

    Kishore M. K. (2/17/2016)

    Dear All,

    Do we have any to tool to measure SQL Server (2012 or 2014) Performance and/or Database Performance with respect to the I/O Resource usage, Memory consumption, T-SQL execution performance etc.

    Thanks in Advance

    Kishore M. K.

    2 mins of google search on this website would you have answered your question. There has been recent ask on this here

  • February 18, 2016 at 9:33 pm

    #1859725

    Thanks Beatrix Kiddo and GilaMonster for sharing these valuable information with me.

    Phil Parkin, thanks for your suggestion. Will do take care of writing a question next time.

    Also, I have already gone through IDERA-SQL Doctor tool (Demo version).

    Even I searched on Google to get related information, but not found any good one.

  • February 19, 2016 at 6:07 am

    #1859786

    Kishore M. K. (2/18/2016)

    Thanks Beatrix Kiddo and GilaMonster for sharing these valuable information with me.

    Phil Parkin, thanks for your suggestion. Will do take care of writing a question next time.

    Also, I have already gone through IDERA-SQL Doctor tool (Demo version).

    Even I searched on Google to get related information, but not found any good one.

    🙂 The words in my signature appear in every message I write: they were not targeted at you!

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 8 posts - 1 through 7 (of 7 total)

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