December 1, 2009 at 9:53 am
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
December 1, 2009 at 10:39 am
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
December 1, 2009 at 10:41 am
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
----------------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply