SQL Compliance Manager v5.9

Performance Enhancements

• Collection service multithread event file capture processing:
  • Improved event file capturing mechanism with parallel processing.
  • Previously several areas appeared to be functioning as single-threaded. With this release, the Collection Service can now process multiple files simultaneously.
  • This change enhances the performance and scalability of SQL Compliance Manager and significantly lowers the impact on the monitored systems while maintaining data integrity.
• Console application performance improvements:
  • Improved the console application response state to avoid and eliminate areas that caused "Non-Responding" conditions.
  • Improved the console application's response time by streamlining the SQL Compliance Manager index structure and query efficiency.
  • These enhancements reduce latencies and improve the overall usability of the SQL Compliance Manager console.
• Improved reports and console performance for large repositories by modifying the repository index structure and query efficiency to refine console application response time.
• Inheritance mechanism adjustments:
  • This release introduces a simplified inheritance mechanism by providing users with flexible customization options when configuring audit activities settings for both Server-Level and Database-Level settings.
  • In this release, whenever Privileged Users are set on the Server-Level, they are automatically displayed on the Database-Level.

Alerts

• Timeframe configuration:
  • Alert Rule wizard now includes new timeframe configuration feature.
  • Added new screen to the Alert Rule wizard where users can decide to keep an alert rule active within a specified time and for a specific number of days.
  • Added the ability to limit the number of notification alerts sent via email.