Changing the default trace settings

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 […]

 

The wheel of performance information gathering

SQL Server is such a grand product that it has its own set of performance information providers. The product ships with these tools (well, some of them are built in the Windows platform, but SQL Server brings extras to them, for example Perfmon).

Here is the Wheel of Performance tuning tools:

The Wheel of Performance tuning

Continue reading […] The wheel of performance information gathering […]

 

The default trace as an entry point for performance and security auditing

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:

the

Continue reading […] The default trace as an entry point for performance and security auditing […]