RockSolid Automation Platform

Operational Analysis

RockSolid uses advanced predictive analysis to detect issues before they cause business impact. RockSolid learns what is normal system activity, when instances fall outside established boundaries requests are raised for investigation and response.

Get Started

RockSolid uses historical data contained within its repository to carry out predictive analysis. This analysis allows issues to be detected in advance and resolved proactively. However as this analysis is based on historical data, not user defined metrics, it does not require any set up time making it a more suitable approach to analyzing key aspects of large database deployments.

Predictive Performance Analysis

RockSolid uses a combination of factors to determine normal operational ranges for dozen of key performance indicators, for each database. These factors include:

  • Current date, day and time
  • Current window type
  • Historical data averages and distributions
  • Current usage patterns

Using our own analytical logic, RockSolid makes a determination if the current performance for a given database is within the normal boundaries for this time. If there is a significant difference in those KPI’s RockSolid will raise a service request to the DBA team for further investigation. Attached to that service request will be all the relevant information so the DBA team can begin to resolve the issue immediately.

Predictive Capacity Analysis

RockSolid uses historical data to determine normal database growth and disk space utilization. If RockSolid determines disk space will become an issue within the warning period (configurable) then RockSolid will raise a service request. If enabled, this service request may proceed to the Automated Resolution Agent and have standard DBA tasks such as data file shrinking and the removal of old backup files automatically take place. The issue may be escalated to the DBA team or closed depending on the outcome of the automated resolution.

Reactive Issue Analysis

Reactive issues occur when a failure or problem occurs and an issue is raised in response. RockSolid raises all the reactive issues that you would expect from any SQL Server management tools. While all attempts are made to avoid reactive issues occurring, where possible, a certain level of reactive issues will always be present.

Some examples of reactive issues raised by RockSolid include:

  • Reoccurring Failed Logins
  • High CPU Pressure
  • High Memory Pressure
  • Fixed Data File Out of Space
  • Database Consistency Error
  • SQL Server Stack Dump
  • Log Shipping Delay
  • SQL Server Error Log Size
  • SQL Server Backup Failure
  • SQL Server Job Failure
  • Disk Out of Space
  • SQL Server Error Log Error
  • Instance Down
  • Instance Stability (reoccurring restarts)
  • Incorrect cluster node host
  • Monitoring Data uploading
  • Maintenance Jobs running outside of Windows

seperator

 

Get Started

To learn more about the RockSolid Platform, and to organise an online demo, please provide us some details about you and your environment.

First Name: Last Name:
   
Company:
 
Email:
   
Phone:
 
How many SQL Servers are in your Environment?: