[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

Can I verify my SQL Server is using all 4 CPU's? Same with the Operating System?

We have an SQL Server (Standard) that I thought could only use 2 CPU's but if I go into my SQL manager it lists all of my CPU's (0-7) so I'm assuming it's using all 4.  We have some performance issues so we are considering upgrading to 2005 but want to know if I'm using all 4 processors or not with SQL?  

Is there a performance monitor that will monitor individual CPU's?  That way I could also see if only 2 of the CPU's were getting maxed out, thus I could conclude it's only using 2 or all 4.

TIA
0
TJanousek
Asked:
TJanousek
1 Solution
 
RichieHindleCommented:
"Is there a performance monitor that will monitor individual CPU's?"

Yes: Process Explorer: http://www.sysinternals.com/Utilities/ProcessExplorer.html
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now