On a multi cpu, multi disk, server, I am looking to associate CPUs with particular log files.
I am wondering if is possible, and how, to dedicate CPU power to specific log file work, in SQL Server 2005.
Considering every write (insert / update) transaction requires writing to the log, this isn't exactly a good idea... even if you could do it, which you can't.
Let SQL server manage it's threading across CPU's. It's going to do a much better job than we could.