I am reading the SQL Mirroring
documentation and it says
"In SQL Server 2008 Enterprise, mirror servers on computers with fewer than five CPUs also use only a single thread. With five or more CPUs, a mirror server distributes its roll forward operations among multiple threads during a failover (this is known as
parallel redo). Parallel redo is optimized to use one thread for every four CPUs. "
I am using a 2 CPU 6 core processor machine, for both primary and mirror servers. Will my roll forward operations be still single threaded despite having 12 cores on each box?
Shouldn't MS make this per Core rather than per CPU?
View Complete Post