Can SQL Server 2003 provide CPU usage information by application?

Tags:
CPU usage
SQL Server 2003
SQL Server performance
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following