Another great meeting last week. I wanted to thank the Speakers Omid Abdollahpour for his Hyper-V talk, Morgan Holm for his insight to the Bridgways Virtual Machine MP, and finally, Raphael Burri and Pete Zerger for the Advanced MP Authoring in the R2 Console talk.
The live meeting recording is now available for download.
Time stamps:
| Topic | Start | End |
| Introduction | | 2:50 |
| Hyper-V | 2:50 | 41:20 |
| Bridgeways | 41:20 | 1:16:00 |
| MP Authoring | 1:16:50 | 2:17:41 |
| Q&A | 2:18:00 | 2:37:45 |
Facebook Group: System Center Virtual User Group
Linked-In Group: System Center Virtual User Group
If you would like to present to the group drop me a line at jscottmossatgmaildotcom
Thank you for your continued support!
Scott Moss
president - System Center Virtual User Group
vice president - Atlanta Systems Management User Group
Overview
Read the Important Pre-Requisite Notes as well as other supporting documentation
The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The availability and performance monitoring is done using a combination of scripts and native Operations Manager capabilities.
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 patch installed from KB959865.
SQL-DMO: Scripts in the SQL Server 2008 management pack rely on SQL Data Management Objects (SQL-DMO) to query information from the SQL Server. SQL-DMO is now deprecated and is not shipped as a part of SQL Server 2008. Every system with SQL Server 2008 that will be monitored must have SQL-DMO installed from the Microsoft SQL Server 2005 Backward Compatibility Components. For instructions on how to download and install the SQL Server 2005 Backward Compatibility Components refer to the management pack guide.
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 for Enterprise, Standard and Express editions of SQL Server 2000, 2005 and 2008 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.
- Over 20 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.
- 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.
The next System Center Virtual User Group meeting #7 will be July 23rd, 12 noon central start time. We have a great mix of Windows 2008 R2 hyper-V, monitoring Virtual Machines with Bridgeways products, and Advanced MP Authoring in the R2 Console, R2 Authoring console create custom datasource, custom monitor type to go with it, illustrate how to use Cookdown, and a few other gems, as well as a Swag Drawing at the end.
Agenda (Central Time Zone)
| Presenter |
Topic |
|
| Scott Moss |
Introductions |
12:00 - 12:05 |
| Omid Abdollahpour |
Windows 2008 R2 - What's new with Hyper-V |
12:10 - 12:40 |
| Morgan Holm |
Bridgeways |
12:45 - 1:20 |
| Pete Zerger/Raphael Burri |
Advanced MP Authoring in the R2 Console |
1:25 - 1:55 |
| Scott Moss |
SWAG Drawing Closing Open for Questions |
1:55 - 2:10 |
Registration
We have an excellent line up for this meeting so join us by registering here!
PC Audio only for Attendees
Audio will only be available through Live Meeting
Presenter Bios
Omid Abdollahpour
Is currently working at a Sweden based company called Xperta AB as Virtualization Specialist (primary focus on Hyper-V and SCVMM). Had the chance to test Windows Server 2008 and Hyper-V early in beta phase and held seminars about Hyper-V & SCVMM 2008. I became MCT this year, held two courses about Hyper-V (MOC 6422) and preparing to hold SCVMM (MOC 6331).
Morgan Holm
Morgan has more than fifteen years of technology experience with a focus on enterprise applications and systems management. He has held key roles in product management and marketing, technology alliances and evangelism. Prior to joining Xandros, Morgan was at NetPro Computing managing a line of infrastructure management, security and compliance solutions for Microsoft environments.
Raphael Burri
Lives and works in Zürich, Switzerland. In the last 9 years Raphael has been designing, implementing and operating various network, system and service management suites. Raphael is currently an independent consultant working with Operations Manager. Raphael Burri's blog: http://rburri.wordpress.com
Pete Zerger (MVP)
Pete Zerger is a consulting partner with AKOS Technology Services and has nine years of experience in the IT industry. He focuses on design and deployment of enterprise operations management, directory services, and messaging solutions. Pete holds an MCSE for Messaging, an MCTS for SQL Server 2005, and he is a Microsoft MVP for Microsoft Operations Manager. He is founder of System Center Forum, a popular community site covering Operations Manager 2007, Essentials 2007 and the System Center Suite.
Swag Drawing
At the end of the meeting, there will be a drawing for some technical swag.
Thank you for your continued support!
Scott Moss
president - System Center Virtual User Group
vice president - Atlanta Systems Management User Group
Just got my MMS 2009 DVDs in the mail. Looking forward to seeing the sessions that I was double booked on! Also the Microsoft Technet web site now has Management Pack University. Check it out there is some great new stuff out there!
http://technet.microsoft.com/en-us/opsmgr/cc671407.aspx