Solarwinds SQL Sentry

Database performance monitoring for the Microsoft data platform, with fast root cause analysis and visibility across the estate. SQL Sentry provides a high level review of your environment,  looks for

space and performance issues.

 

Software to manage SQL Server

Solarwinds DPA

Understand your SQL Server performance across key dimensions: query analysis, resource metrics, storage I/O information, and more. DPA helps to  find troublesome queries that run long, causing slowness in applications, reports etc. Also bad queries can cause locking and blocking issues.

  

 

Soaring Eagle Flight Center

Features

Monitoring System:

Flight monitors maintenance jobs, success, failures and issues (indexing jobs, backups, dbcc jobs, heartbeats,

Flight monitors CPU, Performance issues, unexpected capaccity issues and dbcc or integrity checks to protect against corrupted data.

Tools:

Environment

The environment page has consolidated information about your servers and databases. The Health Tab in particular provides a quick glance look as to how your servers are doing and if they needs work.

 

 Soaring Eagle FLIGHT provides 1 and done portal to view entire Database environment

 

Semi Automated Health check, shares a lot of performance related information for a dba to review and make recommendations on: Capacity, cpu, missing indexes, unused indexes, failed jobs, verifs (page verification, tempdb, auto growth,  auto shrink, io warnings, deadlocks, latency, vlf, power profile).

 

Predictive Capacity with details about database space, drive space, and predicts when the server will be full. Helps to prevent the night and weekend crashes. You are notified with time to prepare for full drives. You select your  warning levels using time or % constraints.

  

 Predict SQl Capacity with soaring eagle Flight software

Ticketing System that stores a lot of data. Collects alerts from Solarwinds DPA, SQL Sentry, Spotlight, Orion, and other ticketing systems.

 We call tickets events, events have associated so the team knows if you have special instructions for job failures, report or r and SSRS failures, and any other alerts you want to set up. There are many automated alerts already set up. You can create your own custom alerts  to create events. Reactions can be open an event by use for information, open an event for handling within 24 hours, or for immediate emergency response. This system is able to communicate to an answering service that will call the correct person per the direction’s for the event. We can customize this for you. You have the ability to track permissions and conversations by autostoring email chains within the event ticket, thus helping with compliance protocols.

 

Management tools to determine the work level of your personnel.

Communication between servers can occur through database mail or TCP IP. There are built in trackers for ip tracking. User tracking for change controls.

 

In summary, with the capabilities of DPA and SQL Sentry and infusing the information into FLIGHT you will be able to easily see the Health of your environment and investigate any issues quickly.