Performance Analysis

SQL layer • parallelism research • examining SQL instances • checking services • index fragmentation verification • maintenance plan • verification of missing indexes • SQL memory verification

Infrastructure layer • infrastructure memory check • architecture verification • data storage

Application layer • checking the load on basic tables • DBPlus installation for a trial period • general analysis of the 10 slowest SQL queries with indication of places in the application causing slowdowns

Business layer • examining the use of tables • retention policy study • background posting