LepideAuditor for SQL Server Review

Product: LepideAuditor for SQL Server

Publisher: Lepide Software Pvt Ltd.

Price

Pricing is based on Per Server. Single
server license fee is $ 499. Support and Upgrades are free as long as
subscription is valid. They offer Educational, Government and Non-profit
discounts.

Introduction

LepideAuditor is an auditing tool for Auditing
in SQL Server. Though there are in built auditing options in SQL Server, this
tool provides additional options for DBAs.

Installation & configuration

This tool has a simple installation. After
installing you need to configure what are the SQL Server instances you are
auditing. After setting those few objects will be created in the SQL Server
Instance. Firstly, it will create a database name called LepideSQLTracker in
the instance. Since this is taking the recovery model of model database, you
need to create additional log backup options so that log of this database is
not growing rapidly. If not, you need to change the recovery model of this
database to Simple.

SQL Server Agent jobs will be added to the
server to populate data to the SQLTracker database.

There
are two types of configurations, Server and Database configurations.

However, database object configuration is
for the all the databases hence you don’t have an option of setting
configuration for separate databases.

However, vendor informed that this will be
added to the next version of this tool.

Features

There three main features with
LepideAuditor for SQL Server.

·
Change Analysis

·
Scheduled Reports

·
Realtime Alerts

Change Analysis

Change analysis is the main feature of this
tool. Users have the option of analyzing the changes server wise and the
database as well.

So you will get the details of , what was
the object changed and type of change, when it was changed, who changed from
which application and the relevant t-sql statement.

There are limited filtering options such as
Duration (Last 24 hrs, Last 7 Days, Last 15 Days, Last 30 Days and Date Range)
, Object Type , Operation Type. User and application are the most important
parameters missing for the filtering.

Also, there is an option to save the report
in different formats such as CSV, HTML and PDF.

Scheduled Reports

Scheduled Reports are wizard driven so that
users can configure them easily.

First you will be asked to select an
operation from following list.

Depending on the selection whether it is
server objects or database objects, user will be asked to select types of
objects.

Then the scheduling can be done as shown
below.

Though this does not have option you have
in the SQL Server Agent scheduling, but this may be just enough.

In the reporting option you only have a
mailing option. There is no option to create a report to a folder. Also, in the
SMTP configuration you have to have a user name and password. However, there
are two other SMTP options, anonymous and windows authentications are missing.

Real Time Alerts

Since reports are scheduled tasks, there is
another feature where it delivers alerts as and when event occurs. It is
similar to reports and you will get the all the pros and cons of reports in the
real time alerts as well.

This is a major feature with this auditing
tool, since most of the auditing tool only provides simple auditing.

Other Information

Web site

http://www.lepide.com/sql-server-audit/

Documentation

http://www.lepide.com/sql-server-audit/documentation/

Download

http://www.lepide.com/sql-server-audit/download.html

Price

http://www.lepide.com/sql-server-audit/buy.html

Review Summary

Description

Rating

Comments

Installation

5

Simple and Standard installation

Configuring

3.5

No configuration available for each database wise

Product Stability

5

Had no issues

Usability

5

Feature Set

4

Apart from the few configuration options (which
vender confirms that those will be available in future versions) , most of
the valuable features exists.




Array

One Response to “LepideAuditor for SQL Server Review”

  1. An excellent auditing tool helping in proper examining of operations done on the SQL Server and Database objects related to Create, Alter and Drop.

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |