Program database performance analysis.

zhaozj2021-02-16  51

This database is very unstable, but there is no point to make an analysis.

1. Connect the database through the Java to do data access;

2. Record each access time by log4j;

3. Import the logging into the database by SQL Server DTS to prepare the analysis;

4. Due to the size of the data, the analysis is also made on your own SQL Server, so I don't use Analysis Service;

5. Use the Excel PivotTable to access SQL Server to create a CUBE analysis file;

6. Define the analysis structure to obtain the analysis icon, analysis, and write analysis conclusions.

转载请注明原文地址:https://www.9cbs.com/read-20693.html

New Post(0)