Part of knowing your server(s) and part of monitoring is to know what changes happened to the environment recently. In this sense, it would be a good idea to look into the default trace daily in order to see what changed in the system. The following script will give you a list of all objects
Continue reading […] What objects were created, altered and deleted in the past 24 hours? […]
Recently I emailed a few great DBA stars with a question:
I have a question for you: do you know if there is a way to alter the properties of the default trace in SQL Server 2005 and 2008? More specifically, I am curious if we can change the number of rolled over files and their
Continue reading […] Changing the default trace settings […]
Starting with SQL Server 2005, there were a number of new tools provided in the product which would help the SQL Server administrator have vital information within close reach.
These tools (hm, I should probably not call them ‘tools’, since most of them were far from being finished tools with proper UI and easy access) include:
Continue reading […] The default trace as an entry point for performance and security auditing […]