A little while back we tried configuring the instance. Sometimes though, instance settings are a bit heavy handed, so this time round let’s try working with database scoped configurations.
- Start by figuring out how to set a database scoped configuration. Assuming you don’t already know of course.
- Review what the various options are. Go into detail on at least 5.
- Try a few out. Again at least 5.
- Take the database configurations you reviewed and see if you can match them up with server level configurations that do the same thing.
- See if you can be even more granular with the effects you are getting.
So for example once you’ve figured out the general command, take a look at MAXDOP. This is something you can set an instance level, database level and even at a query level.