Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

I have a virtual machine (virtualbox) with Windows Server 2003 and SQL Server 2008, running with 4 cores. I wanted to use 6, but when i changed the machine configuration, for some reason SQL Server stopped working. I couldnt start the service, it was giving me an unhandled exception without any extra data.

Does anyone know a fix for that? I can live with 4 cores, but i really want to upgrade to 6.

(I know is this setting, because as soon i went back to 4 cores SQL Server started to work again)

I think there has to be a way to upgrade the machine without reinstaling...

share|improve this question

migrated from stackoverflow.com Jan 26 '12 at 2:42

2 Answers

up vote 4 down vote accepted

Check the version of SQL Server. Enterprise version may be required.

share|improve this answer
I have the standard edition. But if the Express version works this one should too i think... Im going to check the requirements. – H27studio Jan 25 '12 at 22:44
Well, you were right: 4 procs limit. There is a PDF on the SQL Server 2008 Editions Overview that says it. microsoft.com/sqlserver/en/us/editions.aspx Damn! SqlExpress gives me more power? WTF?! hehehe :-) – H27studio Jan 25 '12 at 22:49
up vote 2 down vote

it was giving me an unhandled exception without any extra data

Who was giving an unhandled exception? You app code? Your VM? SQL Server will restart on 6 cores perfectly fine, you shouldn't have to do anything. It may not use all the cores, but it will restart just fine. If SQL Server cannot restart, for any reason, it will add diagnostics in the ERRORLOG, echoed in the system application trace event log as well. Check the ERRORLOG file, as well as eventvwr.exe.

share|improve this answer
The SQLServer process when trying to start it from SQL Server Configuration Manager. – H27studio Jan 25 '12 at 22:16
Did you check the ERRORLOG ? – Remus Rusanu Jan 25 '12 at 22:18
Yes, i found on the Log a message saying something like "4 cores detected" allways even when there were 6... And then all my login errors. but nothing that explains it. I also have a SQLExpress installed, this one logs that it found the 6 cores. Also there is the unhandled exceptions, without any more explanations. So i thinks its going to remain a mistery... ;-) – H27studio Jan 25 '12 at 22:42
It seems it was the processor limit of sql server standard. But it wasnt throwing any errors... It just stops working. Anyway, thanks for the help! – H27studio Jan 25 '12 at 22:50
The problem is that the VM sees 6 different processors with 1 core each. – H27studio Jan 25 '12 at 23:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.