Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server Express on a Multiple core installation

Posted on 2012-04-07
7
Medium Priority
?
1,487 Views
Last Modified: 2012-08-09
I have an ESXi server running with a Windows 2008 installation on it. It has 2 vCPU's and it runs a SQL Express installation for a database wich is used for my ERP software.

For some reasy 1 core is peaking 100% and the other one is doing nothing mainly.

How can tell my SQL server to use both cores or even more cores if needed?

I have read the SQL Express can use 4 cores on 1 processor, but i can't find it how to enable this.

Anyone with an idea?
0
Comment
Question by:RemcoVi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 26

Accepted Solution

by:
tigin44 earned 600 total points
ID: 37818804
if you have SQL Server Manegement Studio Expres installed you can configure the CPU usage of your instance by this steps.
1. open SSMS
2. connect to you database server instance
3. right click on the server and choose properties
4. there you will see a link named "Processors", click it
5. you get a screen showing the CPU's used by your machine.
6. the CPU core used by your SQL server should be marked.. Mark the other one too
7. make sure that the "Configured Values" radio button also checked
8. save your changes by clicking the OK button
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37819748
SQL Server Express only supports 1 CPU.
0
 

Author Comment

by:RemcoVi
ID: 37819959
@tigin44
Automatically set processor affinity mask for all processors is marked
Automatically set I/O affinity mask for all processors is marked

I can't set any options in the white screen where you select the CPU.
I only see CPU0

@acperkins
What i have found by reading was that Express edition supports 1 CPU but up to 4 cores.

This virtual machines has 2 vCPU, but my taskmanager shows 100 CPU on 1 core.

So the only option i have is upgrade to SQL standard? I have an MS Action Pack so that wouldn't be a problem, but can i just simple upgrade it?
0
Looking for the Wi-Fi vendor that's right for you?

We know how difficult it can be to evaluate Wi-Fi vendors, so we created this helpful Wi-Fi Buyer's Guide to help you find the Wi-Fi vendor that's right for your business! Download the guide and get started on our checklist today!

 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 300 total points
ID: 37820290
I have an MS Action Pack so that wouldn't be a problem, but can i just simple upgrade it?
You should be able to do an Edition Upgrade.
0
 
LVL 10

Assisted Solution

by:Ramesh Babu Vavilla
Ramesh Babu Vavilla earned 600 total points
ID: 37826452
SQL Server Express supports
1 CPU
10 GB database base size .and ldf max size is 4 GB


to check the processor run this command in SSMS
xp_readerrorlog 0,1,'CPU'
0
 

Author Comment

by:RemcoVi
ID: 37979278
Sorry for my really really late response, but because some private issues i couldn't respond earlier.

@SQLSERVR
Where do i need to run that command "xp_readerrorlog 0,1,'CPU'" ?

Still didn't find any solution to get this up and working on multiple cores / vCPU
0
 

Author Closing Comment

by:RemcoVi
ID: 38276760
Still have the problem, but i am creating a new virtual machine with MS SQL standard edition, hopefully that would solve the problem.
0

Featured Post

Looking for the Wi-Fi vendor that's right for you?

We know how difficult it can be to evaluate Wi-Fi vendors, so we created this helpful Wi-Fi Buyer's Guide to help you find the Wi-Fi vendor that's right for your business! Download the guide and get started on our checklist today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question