Emulate Multi-CPU ?

Are there any option to emulate multi-cpu ?

Because, I start to use SQL Server 2008 in VirtualPC environment.

In VirtualPC, CPU is one.

So, I cannot check new feature for multi-cpu, like bitmap filter.

Therefore, I wish the option for two or more SOS_CPU node, SOS_Scheduler in one CPU.

Regards,

I've not seen any virtualization software capable of emulating multiple CPUs, but if you use VMWare on a computer with more than one CPU you can assign more than one CPU to the VM; and they will appear as multiple CPUs in the VM.

Apart from that, what I really like is to get my hands on an old 2-way or 4-way computer, they're really great for this kind of testing.

|||As Ole says; VMWare allows (both on Win as well as on Mac) the guest VM to utilize multi CPU's. Both if you have a multi-core box, or a "proper" multi CPU box.

Niels
|||

I don't know if they removed it from SQL Server 2008, but if not then the -P startup switch should do the trick. See http://www.microsoft.com/technet/abouttn/flash/tips/tips_120705.mspx

|||

Excellent !.

-P startup switch works on SQL Server 2008 June CTP. like -P4.

4 scheduler found in 'select * from sys.dm_os_schedulers'.

and Some query use 'Parallel' in execute plan.

best regards,