Introduction to Data Access and Performance Analysis With Resource Analyzer

In this section:

Resource Analyzer gives you a very thorough understanding of data access at your site. This section discusses some of the ways you can use Resource Analyzer to understand and analyze the data access patterns and issues of your organization.

Data Access Management

As a data-access management and performance-analysis tool, Resource Analyzer 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 Resource Analyzer, IS organizations have significantly improved their system performance, enabled faster data access for end users, and finely tuned information content of their data sources.

Overview of Data Access Concepts

In this section:

Resource Analyzer specifically provides detailed information about the following four major data access variables:

Usage Information

Resource Analyzer 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, online or offline)?

Resource Analyzer data usage information enables you to learn the following:

  • What is the most and least popular data being accessed?
  • What columns are potential index candidates?
  • 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?

Resource Analyzer 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?

Resource Analyzer 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?
  • How does request volume relate to resource usage over time?
  • How has usage changed over time?
WebFOCUS