SiteAnalyzer for Decision Support Analysis

Information Technology (IT) administrators, DBAs, and application developers require a variety of information to determine how to optimize reporting environments. SiteAnalyzer offers decision support analysis, helping administrators decide how to organize their site by supplying useful hard facts about the following types of issues:

• Monitoring and managing the impact of reporting on Online Transaction Processing (OLTP) operational systems.
• Balancing decision support systems (DSS) reporting with OLTP workload to allow the two to coexist and to ward off threats posed by reporting on OLTP data.
• Determining if data access design meets the needs of users.
• Removing resource-consuming data that is never used (dormant data).
• Determining the best times to schedule maintenance, backups, data warehouse extractions, and batch processes.
• Determining an allowable amount of downtime.
• Deciding how fast users must be able to recover from software failure or disk drive crashes.
• Discovering performance "hot spots" that must be targeted for correction before they become major problems.
• Analyzing how mixed workloads pattern themselves and change over time (trend analysis).
• Determining how to educate the user community through, for example, efficient request writing, overnight batch processing, and report bursting, to avoid performance problems.
• Deciding how the organization can quantify returns on investments for new data warehouse data dissemination initiatives and justifying these expenses to management.
• Considering if and when the enterprise should decide to charge back the users of data.