up vote 1 down vote favorite
share [g+] share [fb]

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.

link|improve this question
90% accept rate
feedback

1 Answer

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.

link|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. – Chris Lively Oct 19 '09 at 16:15
feedback

Your Answer

 
or
required, but never shown
discard

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