Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

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.

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

Your Answer

 
discard

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.