SQL Sentry software was developed in response to the needs of a high performance Hosting enterprise. SQL Sentry Performance Advisor® is a revolutionary new performance monitoring and tuning tool for Microsoft SQL Server 2000, 2005 and 2008. The software provides unparalleled insight, awareness and control over the true source of SQL Server performance issues. SQL Sentry Event Manager® is a unique scheduling and notification management system for SQL Server. It gives DBAs unprecedented visibility and control over scheduled and non-scheduled events (Jobs, DTS Packages, Windows Tasks, Reporting Services, etc.), allowing efficient management of the most complex SQL Server environment. SQL Sentry software can be used to manage your SQL Server shared hosting enterprise or as an optional add-on for your dedicated server clients.

The SQL Sentry Hosting Partner program allows you to leverage the efficiency and power of SQL Sentry software to increase client satisfaction, stand-out from your competition and create new revenue streams. It offers flexible subscription-based software licensing similar to Microsoft's SPLA model to address your changing needs plus the technical training and marketing support to ensure long-term success. The powerful functionality, of SQL Sentry software, provides unique opportunities for a Hosting Partner:

Reduce DBA Support Burden
SQL Sentry Performance Advisor efficiently captures and communicates the true source of performance issues saving your DBAs hours of manual effort. It does this without placing the burden of complex agents or high overhead on your limited server resources. SQL Sentry Event Manager can be configured to notify your hosting clients directly on the status of their SQL Server Agent jobs, Windows Tasks, DTS packages, Reporting Services reports, and more – over 90 different status conditions in all. The alerts carry granular info about each event, and can be easily customized for each server or job with specific recovery steps or escalation procedures. Clients are directly informed of the status of their own events, greatly reducing the burden on the DBA Support team.

Real Time and Historical Performance Data Collection
SQL Sentry Performance Advisor captures all Top SQL, Blocking and Deadlock issues giving total awareness of the major contributors of performance degradation in a SQL Server environment. Using one tool your data services team can efficiently resolve issues even before a client notices.

Response and Recovery Automation
In addition to sending email or pager notifications for over 90 status conditions, a variety of automated response actions can be taken. The Execute Job, Execute SQL, and Execute Process actions can be tied to any status condition trigger, enabling SQL Sentry Event Manager to go beyond basic alerting and provide full automated recovery for common issues. These actions can also be valuable in integrating with other third party monitoring applications.

Powerful Event Chaining
Event Manager's advanced chaining features enable you to quickly and easily define dependencies and workflows involving SQL Agent jobs and Windows Tasks to meet your customer’s business critical needs. You have ultimate flexibility with regard to how the chains are defined - jobs or tasks can be chained across any number of servers, and there are no limits to chain length or number of branches.

Auditing and Logging Features
With Event Manager’s auditing features, you can be instantly alerted any time a hosting client creates or deletes a SQL Agent job, Windows task, DTS package or SSRS report, and much more.
 
Event Manager keeps a complete history of all events across the hosting enterprise for as long as you desire - you’re not subject to the notoriously low history retention settings of each SQL Server Agent or Windows Task Scheduler. So when a client (or auditor) asks you for the status of a critical ETL job from 2 months ago, you’ll have the information you need.

Push Reports to Clients
Leveraging the power and flexibility of SQL Server 2005 Reporting Services, SQL Sentry Event Manager reports can easily be published to any SSRS instance where subscriptions can be created for each client. Reports include Current Failures, Management Summary info, and more.

Custom Event Views
Create customized views of activity for any client server, group of servers, or events that provide a level of insight never before possible! For example, you can quickly create a calendar of the backups across all client servers that write to the same SAN or NAS device, and easily level the backup activity via drag-and-drop to minimize load on backup device and the network. You can track replication or log shipping jobs separately for each client, and quickly see how jobs across multiple servers interact with each other and sometimes cause contention, performance problems and failures. These are just basic examples – with custom views, if you can think of it, you can create a calendar for it.
 
These are only a few examples of what is possible with SQL Sentry software. We are pleased to share this quote from an existing Hosting Partner who is successfully growing their business with SQL Sentry.

Contact Peter Shire, Director of Channel Sales, at sales@sqlsentry.net to learn how you can become a SQL Sentry Hosting Partner.