I am a new DBA to a company and in general. I am planning to do some changes to a database settings such as backup compression, enable some trace flags, create more files in TempDB ets. My question is what would be the best way to keep track of all changes and new implemented settings So it can be easy accessible? And so people after me can easy access and see what is the current condition of the database? Is there maybe special software for that? Or common way that all DBA's are follows? I just want to know how to record everything you did on a database? i can write everything down on a piece of paper, word doc, excel or maybe there is a better way of doing that? Thank you
Asked
Active
Viewed 437 times
2 Answers
0
Do you have budget for a third party monitoring tool such as SQL Sentry?
This will monitor your SQL Server instance for you, far easier than attempting to create your own solution. You can also create additional Advisory Conditions to alert you for any changes you choose.
Andy Jones
- 1,371
- 7
- 11
0
Aaron Bertrand's post What event information can I get by default from SQL Server? covers the best options available right out of the box, including mining the Default Trace, Extended Events and the Error log. The techniques described can be augmented to log the captured data to permanent tables for long-term auditing.
The SQL Audit feature is also effective, consolidating related commands into various groups allowing the setup of templates based on specific command/event types. Audit data is captured to file and, if the business requires it, the DB engine can be commanded to shut down if SQL Audit data cannot be saved.
