Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 2 down vote accepted

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.

share|improve this answer
It would be very useful to me if I could guarantee that certain databases, and database specific processes, have a guaranteed minimum of resources available, no matter what. – blueberryfields Oct 16 '09 at 0:44
In that case, set your databases up as new sql instances. You can have multiple running per machine. Then assign the resources to each instance. OR, Just split the databases across multiple servers. – NotMe Oct 19 '09 at 16:15

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.