Redgate Software has released a new version of SQL Toolbelt, a portfolio of database development software, that lets developers and administrators determine immediately if database deployments have caused any adverse effects.
Increasing the speed and frequency of database deployments has been a major driver in the adoption of database DevOps practices. However, changes may not always behave as expected in the production environment.
When a performance issue occurs, speed to resolution is critical, said Mark Champion, Redgate product marketing manager. When a deployment is made using one of the deployment tools in the SQL Toolbelt (DLM Automation, ReadyRoll, or SQL Compare), Redgate’s SQL Monitor records and marks the deployment and puts it in context with other performance metrics such as CPU, Memory, Waits and Disk I/O. If unusual behavior is suddenly experienced after a deployment, the DBA team will know exactly when to start their investigation. Making this connection between performance issues and deployments will help development and operations teams work together more effectively and enable them to add more value to the business, Champion added.
In addition to DBAs, developers will also benefit as they will be able to see at a glance the real impact of their code changes, whether positive or negative.
Redgate’s deployment tools and SQL Monitor are part of the SQL Toolbelt, a set of industry-standard products designed to assist anyone working with SQL Server.
For more information, go to www.red-gate.com.