Forum
Bildirimler
Hepsini Temizle
System Center Yönetim Ailesi
5
Yazılar
3
Üyeler
0
Reactions
382
Görüntüleme
Konu başlatıcı
Merhaba,
SQL server 2008 R2 üzerindeki sql agent servisi zaman zaman duruyor buda sorun yaratıyor,bu servis durduğunda scom 2007 den mail gelmesini istiyorum. sql servisi için alerti scom da nasıl oluşturmalıyım?
Teşekkür ederim
Gönderildi : 13/10/2011 20:55
Merhaba;
SQL Serverlarınız üzerinde SCOM Agentları yükledikten sonra SCOM üzerine SQL Server Monitoring Management Pack kurmanız gerekmektedir.
Detaylar için http://www.microsoft.com/download/en/details.aspx?id=10631
Overview
The SQL Server Management Pack provides the capabilities for Operations
Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It
monitors SQL Server components such as database engine instances, databases, and
SQL Server agents.
The monitoring provided by this management pack
includes performance, availability, and configuration monitoring, performance
data collection, and default thresholds. You can integrate the monitoring of SQL
Server components into your service-oriented monitoring scenarios.
In
addition to health monitoring capabilities, this management pack includes
dashboard views, extensive knowledge with embedded inline tasks, and views that
enable near real-time diagnosis and resolution of detected issues.
Important Pre-Requisite Notes:
Clusters: In order to ensure
that all monitoring works correctly for clustered instances of SQL Server ensure
that your OpsMgr agents on the physical nodes of the cluster are running either
OpsMgr 2007 R2 or OpsMgr 2007 SP1 with the most recent cummulative update for
OpsMgr 2007 SP1 applied.
Feature 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 for Enterprise, Standard and Express editions of SQL Server 2005,
2008, and 2008 R2 and 32bit, 64bit and ia64 architectures. - Support for both simple and complex SQL configurations such as clustered
installations, multiple instances and 32bit roles running on a 64bit OS. For
full details on supported configurations refer to the guide included with the
management pack. - Discovery and monitoring of SQL Server roles such as DB Engine, Reporting
Services, Analysis Services, Integrations Services. - Discovery of SQL components such as databases, the SQL Agent and SQL jobs.
- Views covering areas such as 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. - Discovery and basic monitoring for SQL Server Reporting Services and
Integration Services. - 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. - A low-privilege configuration for discovery and monitoring that eliminates
the need for SQL sysadmin, dbo, db_owner, and box admin privileges.
Release History:
- 5/6/2011 - Updated to version 6.1.400.0. Minor bug fixes. Fixed sql
injection security issues - 8/17/2010 - Added SQL 2000 management pack as an independent mp, see below
downloadable SQL Server 2000 Management Pack.msi for SQL 2000 Server monitoring. - 8/5/2010 - Updated to version 6.1.314.36. Removed DMO dependency, improved
health model, improved free space monitoring to support file groups and
autogrow, added knowledge and added detailed low-privilege configuration
information in the MP guide. Refer to the management pack guide for a more
complete list of additions and improvements in this release. - 11/24/2009 - MP guide update only, same version 6.0.6648.0
- 7/22/2009 - Updated version 6.0.6648.0, which fixes an issue with some
monitoring not working on clustered instances of SQL Server. Refer to the MP
guide for more details. - 3/31/2009 - Updated version 6.0.6569.0, which provided a number of fixes.
Refer to the MP guide for more details. - 12/3/2008 - Updated version 6.0.6460.0, fixed an issue with the database
discovery script to prevent overflows - 10/29/2008 - Updated version 6.0.6441.0, which introduced SQL Server 2008
support in addition to other new features and fixes. Refer to the MP guide for a
complete list of changes. - 3/31/2008 - Updated version 6.0.6278.8
- 12/21/2007 - updated version 6.0.6247.5
- 3/23/2007 - Initial Release, version 6.0.5000.0
System
requirements
Supported Operating Systems: Windows 2000 Server, Windows
Server 2003, Windows Server 2008
- Other Software:
- System Center Operations Manager 2007 SP1 and R2
- SQL Server 2005, 2008, or 2008 R2
Clusters: In
order to ensure that all monitoring works correctly for clustered instances of
SQL Server ensure that your OpsMgr agents on the physical nodes of the cluster
are running either OpsMgr 2007 R2 or OpsMgr 2007 SP1 with the most recent
cummulative update for OpsMgr 2007 SP1 applied.
In general, the supported
configurations are outlined in the following locations:
This MP is designed
to monitor the SQL Server 2005, 2008, and 2008 R2 in the following
configuration:
- 32-bit SQL Server on 32-bit operating system
- 64-bit SQL Server on 64-bit operating system. For SQL Server 2005, only SP2
or later is supported - 32-bit SQL Server on 64-bit operating system
Only a subset of
monitoring will work for 32-bit installations of SQL Server that are monitored
on a 64-bit operating system. Please see MP guide and Knowledge Base article 891238
for detail.
For each version of SQL Server, the following editions
are supported (when they apply):
- Data Center
- Enterprise
- Developer
- Standard
- Express
The SQL Server management packs also provide
monitoring for clustered installations of all SQL roles that can be installed on
a cluster. The following limitations apply to support for monitoring clustered
installations:
- Installations of SQL Server on cluster quorum drives are not supported, and
this configuration is not suggested, as documented in Knowledge Base article 280345. - Support for SQL Server cluster resource groups, which contain more than one
network name resource requires additional configuration and the agents must be
running Operations Manager 2007 R2 or Operations Manager 2007 SP1 with the most
recent cumulative update applied. Refer to “Enabling multiple entries for
network name resources” in Knowledge Base article 959865
for instructions on the additional configuration. - Low-privilege discovery and monitoring is not supported on clustered
configurations in this release.
For detailed instructions on
setup, configuration and monitoring of clustered SQL Server resources, see
“Configuration for Monitoring Clustered Resources” in the management pack guide.
Note: This SQL Server Management Pack package does not support
agentless monitoring
Top of page
Instructions
Refer to the management pack guide included in this download for detailed
instructions on working with this management pack. For the latest MP Guide,
please download the .doc file below.
Gönderildi : 14/10/2011 02:12
Merhaba;
SQL Serverlarınız üzerinde SCOM Agentları yükledikten sonra SCOM üzerine SQL Server Monitoring Management Pack kurmanız gerekmektedir.
Detaylar için http://www.microsoft.com/download/en/details.aspx?id=10631
Overview
The SQL Server Management Pack provides the capabilities for Operations
Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It
monitors SQL Server components such as database engine instances, databases, and
SQL Server agents.
The monitoring provided by this management pack
includes performance, availability, and configuration monitoring, performance
data collection, and default thresholds. You can integrate the monitoring of SQL
Server components into your service-oriented monitoring scenarios.
In
addition to health monitoring capabilities, this management pack includes
dashboard views, extensive knowledge with embedded inline tasks, and views that
enable near real-time diagnosis and resolution of detected issues.
Important Pre-Requisite Notes:
Clusters: In order to ensure
that all monitoring works correctly for clustered instances of SQL Server ensure
that your OpsMgr agents on the physical nodes of the cluster are running either
OpsMgr 2007 R2 or OpsMgr 2007 SP1 with the most recent cummulative update for
OpsMgr 2007 SP1 applied.
Feature 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 for Enterprise, Standard and Express editions of SQL Server 2005,
2008, and 2008 R2 and 32bit, 64bit and ia64 architectures. - Support for both simple and complex SQL configurations such as clustered
installations, multiple instances and 32bit roles running on a 64bit OS. For
full details on supported configurations refer to the guide included with the
management pack. - Discovery and monitoring of SQL Server roles such as DB Engine, Reporting
Services, Analysis Services, Integrations Services. - Discovery of SQL components such as databases, the SQL Agent and SQL jobs.
- Views covering areas such as 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. - Discovery and basic monitoring for SQL Server Reporting Services and
Integration Services. - 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. - A low-privilege configuration for discovery and monitoring that eliminates
the need for SQL sysadmin, dbo, db_owner, and box admin privileges.
Release History:
- 5/6/2011 - Updated to version 6.1.400.0. Minor bug fixes. Fixed sql
injection security issues - 8/17/2010 - Added SQL 2000 management pack as an independent mp, see below
downloadable SQL Server 2000 Management Pack.msi for SQL 2000 Server monitoring. - 8/5/2010 - Updated to version 6.1.314.36. Removed DMO dependency, improved
health model, improved free space monitoring to support file groups and
autogrow, added knowledge and added detailed low-privilege configuration
information in the MP guide. Refer to the management pack guide for a more
complete list of additions and improvements in this release. - 11/24/2009 - MP guide update only, same version 6.0.6648.0
- 7/22/2009 - Updated version 6.0.6648.0, which fixes an issue with some
monitoring not working on clustered instances of SQL Server. Refer to the MP
guide for more details. - 3/31/2009 - Updated version 6.0.6569.0, which provided a number of fixes.
Refer to the MP guide for more details. - 12/3/2008 - Updated version 6.0.6460.0, fixed an issue with the database
discovery script to prevent overflows - 10/29/2008 - Updated version 6.0.6441.0, which introduced SQL Server 2008
support in addition to other new features and fixes. Refer to the MP guide for a
complete list of changes. - 3/31/2008 - Updated version 6.0.6278.8
- 12/21/2007 - updated version 6.0.6247.5
- 3/23/2007 - Initial Release, version 6.0.5000.0
System
requirements
Supported Operating Systems: Windows 2000 Server, Windows
Server 2003, Windows Server 2008
- Other Software:
- System Center Operations Manager 2007 SP1 and R2
- SQL Server 2005, 2008, or 2008 R2
Clusters: In
order to ensure that all monitoring works correctly for clustered instances of
SQL Server ensure that your OpsMgr agents on the physical nodes of the cluster
are running either OpsMgr 2007 R2 or OpsMgr 2007 SP1 with the most recent
cummulative update for OpsMgr 2007 SP1 applied.
In general, the supported
configurations are outlined in the following locations:
This MP is designed
to monitor the SQL Server 2005, 2008, and 2008 R2 in the following
configuration:
- 32-bit SQL Server on 32-bit operating system
- 64-bit SQL Server on 64-bit operating system. For SQL Server 2005, only SP2
or later is supported - 32-bit SQL Server on 64-bit operating system
Only a subset of
monitoring will work for 32-bit installations of SQL Server that are monitored
on a 64-bit operating system. Please see MP guide and Knowledge Base article 891238
for detail.
For each version of SQL Server, the following editions
are supported (when they apply):
- Data Center
- Enterprise
- Developer
- Standard
- Express
The SQL Server management packs also provide
monitoring for clustered installations of all SQL roles that can be installed on
a cluster. The following limitations apply to support for monitoring clustered
installations:
- Installations of SQL Server on cluster quorum drives are not supported, and
this configuration is not suggested, as documented in Knowledge Base article 280345. - Support for SQL Server cluster resource groups, which contain more than one
network name resource requires additional configuration and the agents must be
running Operations Manager 2007 R2 or Operations Manager 2007 SP1 with the most
recent cumulative update applied. Refer to “Enabling multiple entries for
network name resources” in Knowledge Base article 959865
for instructions on the additional configuration. - Low-privilege discovery and monitoring is not supported on clustered
configurations in this release.
For detailed instructions on
setup, configuration and monitoring of clustered SQL Server resources, see
“Configuration for Monitoring Clustered Resources” in the management pack guide.
Note: This SQL Server Management Pack package does not support
agentless monitoring
Top of page
Instructions
Refer to the management pack guide included in this download for detailed
instructions on working with this management pack. For the latest MP Guide,
please download the .doc file below.
Gönderildi : 14/10/2011 02:12
Konu başlatıcı
fatih Bey merbaba,
MP i import etmek istediğimde sql2008 monitoring için aşağıdaki hatayı alıyorum.
The dependencies for this management pack cannot be located.
To remove this management pack from the import list, right-click the management pack and click Remove. To see the list of missing dependencies, click Error in the Status column.
Gönderildi : 14/10/2011 18:31
Merhaba, management pack import ederken cataloga baglanirsaniz boylece sorunu cozebilirsiniz (Depend management packleri yuklemek icin)
Bir diger olasi durum ise, default management pack'i sildiniz mi ?
Gönderildi : 16/10/2011 21:39
