STATISTICS COLLECTION AND WORKLOAD MANAGEMENT OF SQL QUERIES

In the late 1980s, data ware house technology introduced Online Analytical Processing (OLAP) in order to process the data to support the business decision and business intelligence. Multiple copies of data were located on different database servers called data mart. Later with the paradigm shift in the technology, big data and analytics are the major trends which are the changing the business world. The data which has been generated in this modern works is huge and growing exponentially. The data which is been generated is of different types. The structured and unstructured data are flooded into the organizations. So, there is a need for missioncritical environments and nonstop servers or system which provides 100% fault tolerance in storing and processing these data. Nonstop eliminates the risk of downtime while meeting large-scale business needs online transaction processing and database requirements. This paper discusses about the different aspects of Nonstop Database Analyzer (NSDA) which is a Manageability product for viewing, monitoring, managing the Database workloads running on the Nonstop System (NSK). Workload Management Services (WMS) provides the infrastructure for monitoring workloads through queries.