Redgate is releasing SQL Monitor 9.1, with new features including an expanded API to help fine-tune alerting through Microsoft PowerShell and a unique permissions function.
These updates support tightened security and compliance by providing a drill-down view of who has access to monitored databases and servers, and their permissions level.
Developed and introduced based on customer feedback, the SQL Monitor PowerShell API allows users to write PowerShell scripts to configure what areas and parameters the tool should monitor and to specify how they are alerted to issues.
This ensures that DBAs can be alerted to what really concerns them in a way that best suits their needs, with the ability to instantly replicate these settings across their entire database estate.
Data compliance is a key business imperative in the age of regulations such as the GDPR, HIPAA and the forthcoming California Consumer Privacy Act (CCPA).
SQL Monitor’s new permissions table aids auditing and compliance by providing an instant overview of who has access, and at what level, to specific servers and databases. DBAs can then drill down to see more details, such as when a user last logged in, as well as delivering a count of Windows Logins, Active Directory Accounts and SQL Server logins.
SQL Monitor provides real-time SQL Server performance monitoring, scalable across even the largest estates.
It delivers instant problem diagnosis and intelligent and customizable monitoring, enabling database administrators (DBAs) to proactively find and fix issues before they impact business performance.
“We’re continually listening to users to ensure that SQL Monitor is both simple to use and delivers the functionality they need to do their jobs in the most efficient way possible,” said Jamie Wallis, product marketing manager, Redgate Software. “The new PowerShell API has been introduced directly due to user feedback, and along with the permissions table feature shows our commitment to developing the tool. I’d encourage all our users to keep engaging with us through our user forums to ensure we are always delivering on their changing requirements.”
For more information about these updates, visit www.red-gate.com.