<div>
<div class="content wysiwyg-content">
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. &nbsp;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? &nbsp;<br />
<br />
Is there a performance monitor that will monitor individual CPU's? &nbsp;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.<br />
<br />
TIA
</div>
</div>


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

Can I verify my SQL Server is using all 4 CPU&#39;s?  Same with the Operating System?

We have an SQL Server (Standard) that I thought could only use 2 CPU&#39;s but if I go into my SQL manager it lists all of my CPU&#39;s (0-7) so I&#39;m assuming it&#39;s using all 4.  We have some performance issues so we are considering upgrading to 2005 but want to know if I&#39;m using all 4 processors or not with SQL?  

Is there a performance monitor that will monitor individual CPU&#39;s?  That way I could also see if only 2 of the CPU&#39;s were getting maxed out, thus I could conclude it&#39;s only using 2 or all 4.

TIA

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

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).