Can SQL Server 2003 provide CPU usage information by application?
I have a Windows Server 2003 Service Pack 1 (SP1) machine and need to find out how much of the central processing unit (CPU) each application is using. I am familiar with task list for Windows XP, but the only task list I see on the Windows 2003 machine is a command line tool and it does not provide CPU utilization. There is also PerfMon, but it does not provide CPU usage by application information either. Is there an application on a SQL 2003 server that will do this?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 21, 2008 8:39 PM
UPDATED:
March 23, 2008 5:14 PM
Answer Wiki:
There is no such thing at SQL Server 2003. There is SQL Server 2000 and SQL Server 2005.
Windows 2003 has the same Task Manager which Windows XP has. Right click on the task bar and select Task Manager.
You can also see this information in Performance Monitor. Under the Process performance object select the "% Processor Time" counter and select the processes you are interested in from the Instances list.
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
There is also now SQL Server 2008 due to RTM in Q3 and is already widely installed by early users. You seem to be interested in the performance characteristics of the server which system monitor is better suited to provide http://technet.microsoft.com/en-us/library/bb266984(EXCHG.80).aspx.
Here is some more SQL Server performance and tuning guidance http://msdn2.microsoft.com/en-us/library/ms179428.aspx.