Configuring The Model Database

Monica Rathbun explains why you might want to configure your model database:

Top (in no particular order) Settings I have Implemented Through Model

  • Default Growth Settings

  • Query Store Settings

  • Recovery Models

  • Read Committed Snapshot Isolation

  • Allow Snapshot Isolation

  • Auto Update Statistics Asynchronously

  • Compatibility Levels

Click through for more information and to see how to make some of these changes.

Related Posts

New(ish) VLF Status: 4

Paul Randal points out a new VLF status which can appear if you’re using an Availability Group: At least since I started working on the SQL Server team (just after 7.0 shipped) and since then there have only been two VLF status codes: 0 = the VLF is not active (i.e. it can be (re)activated […]

Read More

What sys.dm_exec_query_stats Can Miss

Matthew McGiffen takes us through a scenario where sys.dm_exec_query_stats did not give a complete view of what was running on SQL Server: I got less than 50 rows back so figured I had everything covered, but the total elapsed time across all the queries was less than ten minutes, I knew the server hadn’t been […]

Read More

Categories

October 2017
MTWTFSS
« Sep Nov »
 1
2345678
9101112131415
16171819202122
23242526272829
3031