Database Performance and Maintenance Guidance for Fortify Software Security Center

This guide provides comprehensive instructions for maintaining and optimizing the database associated with Fortify Software Security Center version 23.2.0. It outlines essential database settings recommendations for Microsoft SQL Server, MySQL, and Oracle databases, emphasizing the importance of working with a Database Administrator (DBA) for effective implementation. The document details common database performance issues such as Disk I/O and indexing fragmentation, along with practical solutions for managing artifacts and scheduling maintenance. Additionally, it includes specific queries for MS SQL databases that can help identify performance bottlenecks and establish a baseline for database performance. The guide also stresses the necessity of adjusting the compatibility level of the database to align with the current SQL Server engine version. Overall, this document serves as a critical resource for users seeking to enhance the performance and reliability of their Fortify Software Security Center database.