Possible to assign for each CPU a different process within one SQL Server 2005 on a multicore se

Hi all,

is it possible to assign for each CPU a different process within one SQL Server 2005?

I got 2 servers (each 4 CPUs; 64 bit system) which should be able to failover, but on the other hand there are reporting/analysing applications and totally different sharepoint/other applications that should be hosted seperately, each on one physical server.

Thanks a lot for any help!

MarcBey wrote:

Hi all,

is it possible to assign for each CPU a different process within one SQL Server 2005?

I got 2 servers (each 4 CPUs; 64 bit system) which should be able to failover, but on the other hand there are reporting/analysing applications and totally different sharepoint/other applications that should be hosted seperately, each on one physical server.

Thanks a lot for any help!

Within one SQL Server? No not that I am aware of. You can use the affinity mask option to exclude certain CPUs from an entire instance of SQL Serfver, but you can't do it by individual databases within an instance.

|||

Hi,

It is not possible to restrict CPU to work for certain task.

Regards

Sufian