SQL Server 2005 och 2008 har en användbar funktion kallad default trace. Den är påslagen…
Here is some documentation of the Default Trace Audit Lite tool:
Product name: DefaultTraceAuditLIte Version 1.0.0
Created by: Feodor Georgiev
Release date: May 10, 2011
Download: [download id=”3″]
Product information: This product contains a set of reports for SSMS (SQL Server Management Studio) which explore the performance and security auditing capabilities of the SQL Server’s Default trace. These reports work with SQL Server versions 2005 and up.
Features in this release: This release contains total of 12 reports grouped in 2 categories: performance and security.
The reports included are
– Data file autogrow and autoshrink
– Log file autogrow and autoshrink
– Error Logging event
– Sort and hash warnings
– Missing statistics and joins
– Full Text Search events
– Object creation, deletion and change
– Server Start and Stop
– Server Memory Change
– Created logins and DB Users
– Deleted logins and DB Users
– Failed Logins
System requirements: SQL Server 2005 and up. SQL Server Management Studio.
Installation: The default installation folder for the reports is %program files%SQLServiceDefaultTraceAuditLite. After running this executable file you will have the reports in the folder on your computer’s file system. In order to run the reports, open SSMS and connect to an instance of SQL Server. Right-click on the SQL Server instance name in SSMS and select Reports –> Custom reports. At the prompt navigate to the installation folder of DefaultTraceAuditLite and select the DefaultTraceAudit_Main.rdl file. The Default trace report should open in your SSMS. Just click the links and enjoy.
Security: In order to run the reports you need to have ALTER TRACE permission. If you are not a sysadmin on the SQL Server instance, then you would need to ask your sysadmin to grant you the ALTER TRACE permission. (GRANT ALTER TRACE TO [Username] )