250 likes | 515 Views
Question. Can System Center Operations Manager 2007 deploy software?. Answer. Part of the System Center Family of productsService Management Tool for Monitoring and ControlOther examples:Configuration Manager 2007 R2: Configuration ManagementService Manager 2010: Incident and change mangement .
E N D
1. System Center Operations Manager 2007 R2 Ricardo Noulez
Senior Consultant – Microsoft Belux
2. Question Can System Center Operations Manager 2007 deploy software?
3. Answer Part of the System Center Family of products
Service Management Tool for Monitoring and Control
Other examples:
Configuration Manager 2007 R2: Configuration Management
Service Manager 2010: Incident and change mangement
4. Question Can System Center Operations Manager 2007 tell me the health of my systems?
5. Small implementation: 250 to 500 servers
6. Medium implementation: 500 to 750 servers
7. Large or Enterprise implementation: 750 to 6000 servers
8. Question Can System Center Operations Manager 2007 tell me that my coffee is running out?
9. Answer http://www.youtube.com/watch?v=U0_WsgR6hPw&feature=player_embedded
May not be Microsoft endorsed or officially supported, but it still is quite funny.
10. This example shows the flexibility of Operations Manager 2007 R2 monitoring Monitoring intelligence is added by using Management Packs
Each Management Pack imported provides the monitoring for a particular technology
Management packs:
MS: Server Base OS, Exchange, SQL, IIS, AD, ...
Third party software developers: Quest, HP, Dell, Fujitsu, Amberpoint, ...
11. Management packs from MS Part of common engineering criteria
Functional criteria driven by collaboration with Microsoft-IT (eat our own dogfood)
Available as part of the product (RTM +30 days)
Focus on: SQL Server Management Pack
12. Agent is a workflow processor First type of workflow: Discovery workflow:
Discover the configuration items to be monitored
Discovery rules are targeted againts existing items:
Windows Computer will run discovery for Operating System
Operating System will run discovery for Logical Disk
Windows Computer will run discovery for SQL Server DB Instance
SQL Server DB Instance will run discovery for databases
13. SQL Server Management Pack discovered configuration items (CI)
14. SQL Server Management Pack discovered configuration items (CI) continued
15. Agent is a workflow processor Second type of workflow: Monitoring workflow:
Monitors the state of all the configuration items
State change from green to red (or yellow) will generate alerts
State change back to green will close the associated alert
State changes are kept in the database and are reused for availability calculations
16. SQL Server Management Pack key monitoring scenarios Availability of discovered components: all discovered components are monitored for their availability.
Monitoring for blocked single server process IDs (SPIDs).
Periodically queries the database engine for a list of SPIDs. If blocking SPID is detected (exceeds the given threshold), then a red state and an alert are generated.
Data file and log file space monitoring.
Total data file and log file free space is monitored and checked against percentage and size in megabytes based thresholds.
Long-running agent jobs
Maximum job duration is compared against the thresholds on a per agent basis. If a single job runs to long, a red state and an alert are generated.
Service pack compliance
Can be fine-tuned(override) to a specific SP version
17. Agent is a workflow processor Third type of workflow: Collection workflow:
Collects events and performance data from individual configuration items
Long term storage of collected data in the datawarehouse
Event and performance data is aggregated and kept up to 400 days
18. SQL Server performance collection: SQL DB Engine SQLServer:Broker Activation-Task Limit Reached-_Total-15.0-minutes
SQLServer:Broker Statistics-Broker Transaction Rollbacks-15.0-minutes
SQLServer:Broker Statistics-Enqueued Transport Msgs/sec-15.0-minutes
SQLServer:Broker Statistics-SQL RECEIVEs/sec-15.0-minutes
SQLServer:Broker Transport-Open Connection Count-15.0-minutes
SQLServer:Broker Transport-Receive I/Os/sec-15.0-minutes
SQLServer:Broker Statistics-SQL SENDs/sec-15.0-minutes
SQLServer:Broker Statistics-Enqueued Messages/sec-15.0-minutes
SQLServer:Broker Transport-Send I/Os/sec-15.0-minutes
SQLServer:Broker Activation-Stored Procedures Invoked/sec-_Total-15.0-minutes
SQLServer:Broker Transport-Message Fragment Sends/sec-15.0-minutes
SQLServer:Broker Activation-Tasks Aborted/sec-_Total-15.0-minutes
SQLServer:Broker Activation-Tasks Started/sec-_Total-15.0-minutes
SQLServer:Broker Transport-Message Fragment Receives/sec-15.0-minutes
SQLServer:Broker Activation-Task Limit Reached/sec-_Total-15.0-minutes
19. SQL Server performance collection: SQL DB
Collect Database Size (MB)
Collect Transaction Log Size (MB)
Collect Transaction Log Free Space (%)
Collect Transaction Log Free Space (MB)
Collect Database Free Space (MB)
Collect Database Free Space (%)
20. SQL Server performance collection: Analysis Services and Integration Services Analysis Services:
MSAS 2008:Query-Bytes sent/sec-15.0-minutes
MSAS 2008:Data Mining Model Processing-Current models processing-15.0-minutes
MSAS 2008:Query-Rows sent/sec-15.0-minutes
MSAS 2008:Proc-Rows read/sec-15.0-minutes
MSAS 2008:Proc-Rows written/sec-15.0-minutes
MSAS 2008:Data Mining Prediction-Concurrent DM queries-15.0-minutes
MSAS 2008:Connection-Current connections-15.0-minutes
MSAS 2008:Memory-Memory Limit High KB-15.0-minutes
MSAS 2008:Query-Avg time/query-15.0-minutes
Integration Services:
SQLServer:SSIS Pipeline-Rows Read-15.0-minutes
SQLServer:SSIS Pipeline-Buffers Spooled-15.0-minutes
SQLServer:SSIS Pipeline-Rows Written-15.0-minutes
21. Reports
SQL Broker Performance
SQL Database space report
SQL Server Configuration
SQL Server Database Engine Counters
SQL Server Lock Analysis
SQL Server Servicepack Report
SQL User Activity
Top 5 Deadlocked Databases
User connections by day
User connections by peak hours
22. Health models A health model represents the relationships between configuration items
Contains definitions on how the state of a configuration item affects another configuration item
The health model in itself also becomes a configuration item
23. How health rolls-up for SQL 2000
24. How health rolls-up for SQL 2005 and SQL 2008
25. Custom Health models Are called distributed applications
Distributed applications represent services
You can report against distributed applications to determine service availability