MS SQL Parelleism

[Hermess]

Hello all,

i have two node cluster, each server has 4 dual core processors (16 virtuals) and 16 GB of RAM.
I have to examine if MS SQL Server process is executed by more than one of processor (SQL batchs ect) because i have message of bad working antivirus software whitch blocs multiprocessor execution.

Have anybody idea how can i proof multiproccesor execution ?

Thank you

Regards

[Motoma]

Hello all,

i have two node cluster, each server has 4 dual core processors (16 virtuals) and 16 GB of RAM.
I have to examine if MS SQL Server process is executed by more than one of processor (SQL batchs ect) because i have message of bad working antivirus software whitch blocs multiprocessor execution.

Have anybody idea how can i proof multiproccesor execution ?

Thank you

Regards

I don't know of a way to "prove" multiprocessor execution, however, you can check your Processor control settings in Enterprise Manager, and watch the individual CPU usage with Task Manager.