Event Manager 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’s performance. The following screen shot shows the event connector architecture.
Event Manager connector modules allow popular external systems, including backup, defragment, antivirus, and others, to be integrated and easily managed through the Event Manager Console. Event Manager automatically brings all of these events together and displays them on its unified calendar, so you get the whole picture.
Installation and Configuration
Installing and configuring SQL Sentry Event Manager is a straightforward process that doesn’t take a lot of effort. Below are the key steps in the process.
Preparation
Event Manager requires the following minimum hardware.
SQL Sentry Event Manager Components
- SQL Sentry Console computer
- Windows version from supported list below
- Microsoft .NET 2.0 Framework
- Minimum Single 1.6 GHz CPU, 512 MB RAM recommended
- Oracle 10-client connection software (only required if watching Oracle)
- SQL Sentry Server Service computer
- Windows version from supported list below
- Microsoft .NET 2.0 Framework
- Minimum Dual 1.6 GHz CPUs, 1 GB RAM recommended
- Oracle 10-client connection software (only required if watching Oracle)
- SQL Sentry Database
- SQL Server 2000, Standard and Enterprise
- SQL Server 2005, Standard and Enterprise
- Minimum Dual 1.6 GHz CPUs, 2 GB RAM recommended
Supported Operating Systems
- Supported operating systems (x86)
- Windows 2000 Service Pack 3
- Windows Server 2003
- Windows XP Service Pack 2
- Supported operating systems (x64)
- Windows Server 2003, Datacenter x64 Edition
- Windows Server 2003, Enterprise x64 Edition
- Windows Server 2003, Standard x64 Edition
- Windows XP 64-bit
- Supported operating systems (IA64)
- Windows Server 2003, Datacenter Edition for 64-bit Itanium-based systems
- Windows Server 2003, Enterprise Edition for Itanium-based systems
- Windows XP for Itanium-based systems version 2003
Watched Connections
- Watched (monitored) SQL Server instances
- SQL Server 7.0
- SQL Server 2000 all editions, both 32- and 64-bit
- SQL Server 2005 all editions, both 32- and 64-bit
- Watched (monitored) Task Scheduler instances
- Windows 2000
- Windows Server 2003
- Windows XP
- Watched (monitored) Oracle instances
- Oracle 9i
- Oracle 10g
Installation
Installation of Event Manager is fairly simple for the average DBA. During installation, it gathers all the information from you. In addition to the basic information that any installer needs, you will need to supply the server credentials for the database that Event Manager is going to create, SMTP details for sending notifications by e-mail, license information, etc. Because you are providing this information at the installation, installation will require a little time to complete—about 15 minutes if you have all the information at hand. Configuration will take less time to complete.