Wireless Office Headset User Manual

EMBARCADERO TECHNOLOGIES > DSAUDITOR 4.5 USER GUIDE 9
Modify a Chart
To change the date range of a chart, change from chart to table view or vice-versa, or select a different chart type,
click the Configure (wrench) icon in the upper-right corner of the chart.
NOTE: If you set the date range so as to return an enormous amount of data, for example by selecting
All Dates Through Today, after you save the configuration it may take several minutes for the
chart to be updated. If the results are too dense to be readable, try switching to table view.
Chart Descriptions
Performance Charts - Column Usage
Column usage is important to continuously monitor in order to understand historical trends for data warehousing
optimization as well as security.
Top 25 Column Accesses: This chart provides information on the top 25 columns accessed (select activity) for the
monitored databases for the last 7 days.
Top 25 Column Updates: The Column Updates chart shows the top 25 updated columns per database instance
for the last 7 days.
Performance Charts - Dormant Objects
Dormant Table charts are used to streamline the data being loaded into the DSS database. For example, data
accessed only once per month can be loaded on a different schedule than data accessed on a daily basis.
Unused Table charts are used to aide in re-design of the DSS database eliminating unutilized Tables and improving
the ETL process performance.
Dormant Columns: The Unused Columns chart shows columns that have not been accessed in the last 90 days.
This data may no longer be required by the application or may be redundant.
In addition, these columns may contain sensitive data and should be evaluated for business risk.
Dormant Tables: The Unused Tables chart shows tables that exist in the database that have not been accessed in
the last 90 days. This data may no longer be required by the application or may be redundant.
In addition, these tables may contain sensitive data and should be evaluated for business risk.
Performance Charts - Long Running
Long running queries are often indicative of SQL that needs to be tuned, missing indexes, or the need for summarized
data. The Longest Running Query chart is used to target a set of queries to optimize. The overall query performance
on the database is improved as well because optimizing long running queries frees up database resources for other
queries. The Longest Running Query chart is used to identify users who require more understanding of data farming.
Identifying and training power users can have a significant impact on system performance.