Hi Jordy,

Just having a quick google...

http://blog.sqlauthority.com/2010/03/15/sql-server-maxdop-settings-to-limit-query-to-run-on-specific-cpu/

It looks like there are a number of issues to consider:

• Size of datasets
• Available memory

I think you'll need to tune the database server to your particular environment as there's no solutions to this. Best practice might simply be a matter of "if it's fast enough, don't change it." Otherwise, it's just one of the many tools in your SQL Tuning bag of tricks; along with creating new indexes, striping data, increasing memory, etc.

Having said all of that, what lead to your investigations? Is Laserfiche running slower than you'd like?

-Ben