Usage Monitoring

A secure DW/BI system will have usage monitoring in place. In an increasingly regulated world, its extremely valuable to know who is connected to the system and what theyre doing.

In Chapter 15 we talk about how to set up usage monitoring on Analysis Services, Reporting Services, and the relational engine. For some organizations its sufficient simply to collect logons : whos accessing the database and when? Other organizations need to know exactly who is accessing which information.

Reporting Services monitors usage by default. In addition, Reporting Services provides an option to copy the usage logs from the Reporting Services catalog into a separate database. This option provides a target relational database, Integration Services packages to move the data, and a starter set of reports . This database should suffice for the majority of usage reporting requirements from Reporting Services.

Usage monitoring provides other valuable benefits. Its a valuable tool for performance tuning. Spending a bit of time analyzing how business users are accessing data is very valuable for understanding how to improve your DW/ BI system.

If you set up a usage monitoring systemas we strongly recommendyou should inform your business users of what youre doing, why, and how the information will be used.