RockSolid is, at it's core, a platform for delivering operational management for Microsoft systems. This includes both automated and manual operational management, through effective use of policy and adaptive automation processes.
However RockSolid also offers features of benefit to the developers building SQL Server based applications who have deployed applications under operational support from RockSolid. Through monitoring, RockSolid is able to offer developers insight into the performance and usage characteristics of their applications once deployed, to allow for proactive improvement.
The key features RockSolid provides for Devops include:
- SQL Server database Performance monitoring and reporting
- SQL Server database maintenance reporting
- SQL Server database configuration and compliance reporting
- SQL Server database security monitoring and reporting
- SQL Server Availability group object synronisation
SQL Server Database Performance Monitoring and Reporting
RockSolid's performance monitoring capabilities for SQL Server are extensive. You can find more detail on this topic on this site, however key areas that relate to Devops include:
The RockSolid Dashboard
The RockSolid Dashboard is a key component of the RockSolid application that allows operational and development staff insight into both current and historical performance of their applications deployed ether in production or in testing environments. The RockSolid dashboard provides access to numerous KPIs that provide insight into:
- CPU performance
- Memory usage
- Query execution statistics and resource consumption
- Queries consuming tempdb space
- Queries generating with large transaction log usage
- Capacity, table & index growth
- IO throughput and queuing
- Data file growth events
- Wait statistics
- Long running queries
- Long running SQL Agent jobs
- Index fragmentation levels
- Locking and spin locking
RockSolid provides automated base lining of all metrics using a proprietary algorithm that constructs the baseline using a combination of daily, weekly and monthly statistics.
These baseline metrics prove invaluable during performance issue investigation as it allows clear identification of where changes in system performance has occurred, allowing for a focused investigation and faster resolution of underlying issues.
SQL Server database maintenance reporting
Operational issues can sometimes be due to improper database maintenance. Such issues can be great causes for concerns for developers, as the responsibility for undertaking maintenance may be elsewhere however the developers are often the ones tasked with resolving issues that result as an outcome.
The RockSolid maintenance reporting provides developers clear insight into the current state of maintenance including:
- Fragmentation status, history, index maintenance and rate of change
- Database statistics status, history, and maintenance
- Database consistency check history and outcomes
- Patching (SP, CU, Security Patching) Status and History
SQL Server Database object reporting
Once a database is deployed into production the way in which it grows may differ from the initial expectations of the developers. This may lead to contention in unexpected areas of the application, as well as requirements to optimize new areas through indexing and code efficiencies. The RockSolid object reporting allows developers to understand the way in which objects are changing and how this impacts on the use of the application, including areas:
- Table row count current status and growth history
- Index size current status and growth history
- Index usage history and unused index identification
- Database index recommendations
- Data compression recommendations
- Stored procedure execution usage history
- Stored procedure change history
- Schema change history
RockSolid logs events that are relevant from a DevOps perspective. Events are kept in RockSolid, and can be either historical searched or proactively alerted to DevOps teams on occurrence. These include:
- Schema objects being created, altered or deleted
- New users being created
- Permissions being granted/revoked
- Blocking occuring
- Deadlocks occuring
Security Reporting & Alerting
The RockSolid security reporting supports DevOps requirement to ensure secure compliance and operational best practices are being met. Features in RockSolid include:
- Failed login alerting and historical reporting. Reoccurring failed logins typically related to failing batch processes or attempted security breaches.
- Last login reports . Understand which users are using which databases, and identify unused logins which can be removed.
- Elevated privileged reports, identify users running with elevated privileges
- Orphaned users
RockSolid Database Firewall
The RockSolid database firewall can be configured to alert when valid users are connecting to databases using non-valid methods. For example, a user may be valid to connect from a specific application, but not from an ad-hoc query tool which bypasses the application business logic. The RockSolid database firewall allows rules to be configured which associated users with either applications an/or host or network segments. Violations of rules can either alert Devops teams or block invalid login attempts failing their connection.