Hello, here is a Microsoft article that talks about MAXDOP settings: http://support.microsoft.com/kb/329204

Set MAXDOP = n, where n is the number of physical processors in the box (for a...

Right, this won't change the log activity but was sort of taking this discussion in a slightly different direction when Grasshopper had mentioned to see if that feature was being...

Thank you all for your informative responses! :w00t: I will perform the suggestions above.

I just checked, and during maintenance, the resorting is NOT done in tempdb. Tempdb also...

Hi, what I'm trying to figure out is if there was really a need to increase the tran log size from 95 GB from 60+ when only 1% of the...

SSChampion, thank you for your response. The recovery model is Full. The database is OLTP.

Yes, we run tran log backups periodically every 10 minutes. Maintenance...