Solved

SQL Server Express on a Multiple core installation

Posted on 2012-04-07
7
1,310 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
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!

 
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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
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…

821 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