My hope is if you are reading this then you are a Vault user, my other hope is that you are already taking good care of your Vault Server, you know, performing your backups (perhaps even testing to make sure they work from time to time!), watching the database and file store growth, periodically checking your Vault and Windows logs for issues and otherwise keeping the engine well oiled.
But what about Microsoft SQL? A great deal of your Vault's performance can be directly attributed to SQL performance and just like any other system it too needs to be maintained to ensure efficient operation.
The world of a DBA can though be a little intimidating and confusing to Vault administrators, trying to decipher the optimal database settings and what maintenance tasks are actually required - indeed without a little SQL knowledge how would you know where to find the maintenance plan setup?
To this end we have had for some time information around SQL maintenance best practice and a step by step procedure in fact (for both full and Express editions) on how your Vault databases should be configured, what initial size and growth factors should be (too big is inefficient as is too small - it needs to be just right) and were this can all be found.
Working with Microsoft over time, some of these recommendations have changed (We no longer remove the unused space as part of the regular maintenance) so it may also be worth while going back and looking at these maintenance plan guidelines again and giving your environment a bit of a tweak.
So where is all this information? It's available here at the bottom of the Perform Vault Maintenance page in WikiHelp of course. Now stop reading blogs and get back to reading log files and tweaking server settings.
Photo: LadyDragonflyCC <3