OpsMgr 2007 : Mise à jour du pack d'administration pour SQL (6.0.6569.0)
Voici la version 6.0.6569.0 du pack d'administration pour SQL Server 2000/5/8.
Feature Bullet Summary:
The following list gives an overview of the features of the SQL Server management pack. Refer to the SQL Server management pack guide for more detail.
- Support des éditions :Enterprise, Standard and Express deSQL Server 2000, 2005 et 2008 et architecture 32bit, 64bit et ia64.
- Support for both simple and complex SQL configurations such as clustered installations, multiple instances and 32bit roles running on a 64bit OS.
- Découverte et suppervision des rôles SQL Server DB Engine, Reporting Services, Analysis Services, Integrations Services.
- Découverte des composants SQL databases, SQL Agent et SQL jobs.
- Plus de 20 vues ( database free space, SQL related performance, SQL related alerts, and lists of the various SQL roles and components which are discovered and their related state.)
- Reports for longer-term analysis of common problem areas related to SQL Server such as SQL Server lock analysis and top deadlocked databases, SQL Server service pack levels across discovered roles, user connection activity. Likewise the generic reports from the Microsoft Generic Report Library can be used against the roles and components discovered by the SQL MPs to review availability and performance across many systems and over longer periods of time.
- Role and component specific tasks which provide access to common tools, triage information, or corrective actions without needing to leave the Operations Console in most cases.
- Monitoring of databases covers database status, database free space, log shipping monitoring for both the source and destination, and transaction log free space.
- Monitoring of key SQL related services.
- Monitoring for persistent SPID blocking.
- Monitoring of numerous SQL events and performance data points. Alerts bring the issue to your attention and provide knowledge on the impact and possible resolutions.