System Architecture
 
 
System Architecture

SQL Sentry software was built to handle the largest server environments. Its lightweight polling architecture incurs minimal network and server overhead; and because there are no agents, installation and maintenance overhead is virtually non-existent.

SQL Sentry Client
The zero-configuration SQL Sentry Client mirrors your existing Management Studio configuration, so you don't have to redefine all of your servers and groups.  As a result you can be up and running in a matter of minutes instead of hours or days.  You can install an unlimited number of Clients across your enterprise, and DBAs can easily connect to multiple SQL Sentry installations from a single Client.

SQL Sentry Database
SQL Sentry utilizes a single SQL Server database to store collected job and performance data, as well as configuration information. For maximum fault tolerance the SQL Sentry database can be installed on a clustered SQL Server instance.

SQL Sentry Monitoring Service
The SQL Sentry Monitoring Service is a Windows service which handles various responsibilities, including monitoring job status and performance, generating notifications, and actively collecting job history data.  One SQL Sentry Monitoring Service is required for approximately every 50 to 100 monitored servers.

Fault Tolerant Architecture
Multiple Monitoring Services can be linked together using our own clustering technology to provide virtually linear scalability and extreme fault tolerance. If any SQL Sentry Monitoring Service fails, the others automatically pick up the load in a matter of seconds, ensuring nothing is missed and notifications are always sent.

Using the concept of "Sites", SQL Sentry can easily be setup in geographically dispersed environments to monitor SQL Servers at specific locations and report back to the SQL Sentry database, minimizing network overhead.

SQL Sentry Event Connector System
SQL Sentry seamlessly integrates external event data into calendars alongside SQL Server Agent jobs, and gives you unprecedented visibility and control over all of the events that can impact your server performance. See Cross-platform Support for more information.

 
Product Evaluation
New SQL Sentry Software Version

Check out Greg's blog and our videos for what's new in SQL Sentry v7! Download Performance Advisor, Event Manager, and Fragmentation Manager together.

SQL Sentry Plan Explorer

The most powerful query plan analysis tool on the planet just got better!

See Greg's blog on Plan Explorer PRO.

Fully integrated point-and-click SQL Server defragmentation, at top speed!

Customer Support
F.A.Q.
Online Help
Evaluation Highlights
Videos
Forums
System Architecture
Customer Portal
Contact Support
Professional Services

Innovative ideas to improve SQL Server performance. Visit the Blog.

Join Our Community
Twitter Feed
Loading..
sql server solutions | analysis services solutions | site map | privacy | contact us | about us | sales@sqlsentry.net | 704-895-6241 | 855-775-7733 toll-free    twitter  facebook
© 2013 SQL Sentry, Inc. All rights reserved.