January 7, 2015 at 4:46 am
Hi
We have a virtual sql2008r2 server which our supplier has just added a new Vcpu to, totalling 2 cpu's.
I can see the 2 cpu's in windows os level but sql server is only using one
SELECT cpu_count from sys.dm_os_sys_info
select scheduler_id,cpu_id, status, is_online from sys.dm_os_schedulers where status='VISIBLE ONLINE'
confirms 1 cpu and scheduler id 0 as visible online.
So when I run
sp_configure 'show advanced options', 1;
RECONFIGURE;
GO
sp_configure 'affinity mask', 3;
RECONFIGURE
I get a message confirming affinity mask changed fom 0 to 3 then an error
Msg 5832, Level 16,state 2, line 1
The affinity mask specified does not match the CPU mask on this system
I'm pretty sure the last time this happened a reboot fixed it and the 2nd scheduler became visible to sql server. This article says that a reboot it not needed http://msdn.microsoft.com/en-us/library/ms187104.aspx . Do I need to restart sql server ?
January 8, 2015 at 3:26 am
just in case anybody has the same issue.......rebooting allows sql server to 'see' the new cpu even though the link in my original post says a reboot is not needed. Maybe this has something do with the instances being virtual - i'm not sure - but my cpus are now being seen by sql server 🙂
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply