SQL Management Suite updated

SQL Compliance Manager

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.

SQL Safe Backup

• Amazon S3 Cloud
  • The StorageClass parameter is now available when backing up to Amazon S3 Cloud (AWS S3).
• SQL Safe Repository
  • Users can now record cluster details in the SQL Safe Repository.