As others have said, this is a very broad question. My suggestion would be to start with something specific you can work on: identify a common specific query that is having performance problems, and look over the execution plan to see where things are slowing down. If you've already tried that, and haven't needed indexes or been querying too broadly, you might be hitting cxpacket waits where maxdop would help. HTH