Home / server / Questions / 74045
Accepted
blueberryfields
Asked: 2009-10-14 06:30:00 +0800 CST

How fine grained of an association can I make between SQL Server log files and CPU?

  • 772

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.

sql-server

1 Answers

  1. Best Answer

    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.

    • 2