Data Access Management and Performance Analysis

As a data access management tool, SiteAnalyzer helps you make knowledgeable decisions about managing access to corporate and departmental data. These decisions typically require balancing system performance and capacity (CPU cycles and disk space availability) with the demands of ad hoc access to information for decision making. By using the information provided by SiteAnalyzer, IS organizations have significantly improved their system performance, enabled faster data access for end users, and finely tuned the information content of their databases.

Overview of Data Access Concepts

SiteAnalyzer provides detailed information about the following four major data access variables:

• Request usage
• Data usage
• Resource usage
• Usage over time

SiteAnalyzer request usage information helps you identify the following:

• Who is using the requests?
• Which requests are being run?
• When are requests being run?
• Where are requests getting data?
• How are requests using data (that is, detail or aggregation, extract file or report)?

SiteAnalyzer data usage information helps you learn the following:

• Who is accessing the data?
• What data is being accessed?
• What data is not being accessed?
• When is the data being accessed?
• How is the data being used?

SiteAnalyzer resource usage information lets you know the following:

• Who are the high-resource users?
• Which requests use the most resources?
• When are the peak resource usage time periods?
• How can you reduce system resource utilization?

SiteAnalyzer usage over time information helps you confirm the following:

• Who is running requests during peak periods?
• Which requests are running during peak periods?
• When are the best times to off-load high resource requests?
• How do you better balance resource usage for improved performance and response time?