SQL Server 默认跟踪报表

SQL Server性能与安全审计工具DefaultTraceAuditLite

最新推荐文章于 2020-07-28 12:58:30 发布

原创最新推荐文章于 2020-07-28 12:58:30 发布 · 129 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一款名为DefaultTraceAuditLite的工具，它为SQL Server Management Studio提供了一系列报告，用于探索SQL Server默认跟踪的性能和安全审计能力。此工具适用于SQL Server 2005及更高版本，包含12份报告分为性能和安全两大类别。

全文转载自 http://sqlconcept.com/tools/default-trace-audit-documentation-and-faq/

Default Trace Audit documentation and FAQ

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: （见附件）

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:

Performance:

    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

Security:

    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%\SQLService\DefaultTraceAuditLite. 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] )

F.A.Q.:

Q: How much data is stored in the default trace and for how long?

A: Depends on how busy the server is; the Default trace has 5 files 20 Mb each, and depending on how many events are written to the Default trace files, the files may roll over and overwrite the oldest file.

Q: Can we change the settings of the Default trace in SQL Server?

A: No. More details can be found here.

Q: Do I need to install this tool on every server?

A: No, you can install the tool on one server and use the SQL Server Management studio to connect to any server in the network and run the reports this way.

Q: What should I do if I find bugs or if I have questions and comments?

A: Send a message to the author by using the contact form.