Reporting/Monitoring tool

  • Hello Gurus

    I would like to know if there are any tools which can be deployed to know the percentage of resources (specially the CPU Usage) by the application on my sql server. Currently, we are using sql 2005 and 2008 as well. I know there are some tools which are being used in mainframes to give a report on cpu usage by different applications.

    I hope I am clear with my question.

    Early response to this post is highly appreciated.

    Thanks

    Ali

  • This should work.

    http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Clear, but a little open ended, so I'll throw a bunch of info at you. A couple of real basic tools I use are:

    Perfmon (installs with Windows)

    ProcessExplorer (in the Sysinternals suite)

    SQL Server Performance Dashboard Reports

    You can access 'perfmon' by going to Start -> Run and typing 'perfmon'. It has a ton of useful counters for monitoring various resources.

    Use this link to download the Sysinternals suite: http://technet.microsoft.com/en-us/sysinternals/bb842062.aspx. In that suite of tools, 'ProcessExplorer' can be used to find information about processes. It's a nicer interface to the Windows task manager.

    Download the 'SQL Server Performance Dashboard Reports' here: http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en. They are very useful but only report on SQL Server usage.

    HTH.

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.

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

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