Solved

SQL Server Express on a Multiple core installation

Posted on 2012-04-07
7
1,277 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
7 Comments
 
LVL 26

Accepted Solution

by:
tigin44 earned 200 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 100 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:sqlservr
sqlservr earned 200 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Monitor input from a computer is usually nothing special.  In this instance it prevented anyone from using the computer.  This was a preconfiguration that didn't work.
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

832 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