October 2008 - Posts
The following should help MOM Admins get a good picture of what is going on in their onepoint database. It will require you to groom out all but one days worth of data in the onepoint database so you will be able to get a better picture of what is being captured on a daily basis. Once you know what is happening on a daily basis you should be able to identify the counters that are collecting too much data then turn off the rules that are collecting extra un-needed data. Unfortunately each management pack loaded into the MOM 2005 environment has the potential to add additional duplicate performance collection rules. The worst offenders are the duplicates found in the the following management packs, Exchange (any version), and SQL Server (any version) as they have rules similar to the base OS Management Pack for collecting basic perf counters for disk utilization, memory, and CPU.
1. Make sure DTS job has been run and is up to date (a must if you are using reporting)
2. Change the Global setting for database grooming to Groom Data older than the following number of days to 1, apply the changes.
3. Open the SQL Admin tool and run the SQL Job "MOMX Partitioning And Grooming" to groom old data out of the onepoint db.
4. Once that SQL job has completed find out whats going on with these Kevin Holman SQL Queries:
First look at the number of Perfmon data points your collecting by running this SQL Query
-- Kevins performance objects
select performanceobjectname, performancecountername, count(performanceobjectname) as 'count' from sdkperformanceview
group by performanceobjectname, performancecountername
order by 'count' desc
Second check what the individaul servers perfmon data points are looking like
-- noisy perf computers
select distinct server, count(*) as NumberOfOccurences
from SampledNumericDataPerformanceReportView
group by server
order by numberofoccurences desc
If there is a server with a large number of perf data points run this query to see what its collecting
Replace YOURSERVERNAMEHERE with the server name you want to look at the data points for.
-- kevins performace object query
select performanceobjectname, performancecountername, count(performanceobjectname) as 'count'
from sdkperformanceview
where computername = 'YOURSERVERNAMEHERE'
group by performanceobjectname, performancecountername
order by 'count' desc
After looking at this data you should be able to have a good idea what rules need to be tuned.
Hope this helps!
Citrix released this last month, and I'd not seen it anywhere else yet. http://support.citrix.com/article/CTX116421 Citrix MP for XenApp 5.0 for Windows Server 2008. This is the link to the Admin guide. Still looking for an MP.
From a request on the SystemCenterCommunity a user wanted a SQL query to disply the following information: Managed computer, Alert description and Alert severity. Well its much easier to just open up Powershell and get this information, and slap it into a csv fie.
get-alert | select-object NetbiosComputerName, Description, Severity | Export-Csv -path “c:\alerts.csv“
One of the users on SystemCenterCommunity requested a SQL query for scom to get the following information: Managed computer, Alert description and Alert severity. I wrote the following SQL query to do that only instead of getting the Managed Computer name I use the MonitoringObjectDisplayName. I should be able to figure out how to get this same information from a powershell one liner too.
-- Scott Moss
-- 10/27/2008
-- SCOM 2007 SP1 OPerationsManager DB Query
-- Get listing of MonitoringObject, Alert descriptiong and Severity
-- http://myitforum.com/cs2/blogs/smoss
select
MonitoringObjectDisplayName,
AlertStringName,
AlertStringDescription,
'Severity' = Case
When AlertView.Severity = 0 Then 'INFORMATIONAL'
When AlertView.Severity = 1 Then 'WARNING'
When AlertView.Severity = 2 Then 'CRITICAL'
Else 'Undetermined'
End
From AlertView
There has been a recent surge of activity on the OpsManJam site, with the following documents being published on the OpsManJam Site, OM2007_Install_Reporting_WindowsServer2008, ReportKnowledgeTemplate, Regular Expression Support in SCOM 2007, and Scripting Guide for Discovery and a ProxyMPs.
Link to OpsManJam Site Library
Windows Server Operating System Management Pack for Operations Manager 2007 version 6.0.6321.5
Overview
The Windows Server Operating System Management Pack consists of the following five management packs: Microsoft Windows Server Library, Microsoft Windows Server 2008 Discovery, Microsoft Windows Server 2008 Monitoring, Microsoft Windows Server 2003, and Microsoft Windows 2000 Server. The Microsoft Windows Server management packs monitor the performance, health, and availability of Windows Server 2008, Windows Server 2003, and Windows 2000 Server.
By detecting, alerting on, and automatically responding to critical events and performance indicators, management packs reduce resolution times for issues and increase the overall availability and performance of your Windows Server 2008, Windows Server 2003, and Windows 2000 Server operating systems, thereby helping to reduce the total cost of ownership.
Feature Summary
- Availability
- Key Operating System Services: Required services are checked for status (for example, running, not running, or paused).
- Storage: Logical hard drives are checked for availability, sufficient free space, and integrity of the NTFS partition.
- Network: Network adapters are checked for connection health, name and IP address conflicts.
- Performance
- Processor: System processor(s) performance is checked system-wide. Processors can optionally be monitored on a per processor basis.
- • Memory: Memory consisting of physical memory and virtual memory (also known as page files) is monitored using the following performance indicators:
- Available memory (in MB)
- Pages per second
- Page file percent usage
- Disks and Partitions: Logical disks/partitions and physical disks are monitored, and performance data is collected for average disk seconds per read, disk seconds per write, and disk seconds per transfer. Depending on which version of the operating system is being monitored, either logical or physical monitoring is enabled by default. Refer to the MP guide for more detail.
- Network Adapter: Network adapters are monitored for the number of bytes received per second, the number of bytes sent per second, and the total bytes per second. In addition, the health state of the network adapter is evaluated and is set to Healthy if connected and Critical if disconnected.
Management Pack Release History:
- 3/23/2007 - Initial Release, version 6.0.5000.0
- 9/28/2007 - Updated release, version 6.0.5000.25
- 10/23/2007 - Updated MP Guide - Software Version still 6.0.5000.25
- 11/8/2007 - Updated MP Guide - Software version still 6.0.5000.25
- 1/15/2008 - Updated MP Guide - same version
- 2/22/2008 - Updated release, version 6.0.6278.0, and released on SP1 media
- 5/27/2008 – Same version as released on SP1 media, version 6.0.6278.0, and released on Microsoft Download Center.
- 7/27/2008 - Updated version, 6.0.6278.22: Introduced support for the Windows Server 2008 Operating System and addressed some issues from the previous release. Refer to the MP guide for further details.
- 10/20/2008 – Updated release, version 6.0.6321.3: Refer to the MP guide for further details.
New Veeam Reporter Enterprise now available. Considered to be the first reporting solution specifically designed for documentation and change management in large VMware Infrastructure 3 environments.
Features include:
The Southeast Management User Group invites you to attend the next SMUG meeting scheduled for November 14th, 2008 for a day of great presentations, discussions, and networking, at the Alpharetta Microsoft Campus.
REGISTRATION LINK
http://msevents.microsoft.com/CUI/InviteOnly.aspx?EventID=5B-11-D1-1D-08-92-D8-84-78-E1-CD-6A-5C-13-92-AA&Culture=en-US
DATE & TIME
November 14th, 2008
9:00 AM – 4:00 PM
Breakfast and lunch provided courtesy of our sponsors at Acresso and Secure Vantage!
THE AGENDA
| Presenter |
Agenda |
Start |
End |
| |
Breakfast/Meet and Greet |
8:30 AM |
9:00 AM |
|
SMUG |
Introduction |
9:00 AM |
9:10 AM |
|
Mark Mears |
CCMWindows w/ SMS 2003 |
9:15 AM |
9:35 AM |
|
Greg Cameron |
SC Virtualization Management |
9:40 AM |
10:50 AM |
| |
Break |
10:50 AM |
11:00 AM |
|
Hal Rottenberg |
Managing VMWare w/ Powershell |
11:00 AM |
12:10 PM |
|
Evan Orgel |
Best Practices for Traditional and Virtual Application Management (Lunch) |
12:15 PM |
1:25 PM |
|
Troy Wilch |
App-V/Softgrid w/ SCCM 2007 R2 |
1:30 PM |
2:40 PM |
| |
Break |
2:40 PM |
2:50 PM |
|
Jeremiah Beckett |
ACS Design and Planning |
2:50 PM |
4:00 PM |
|
SMUG |
Wrap Up |
4:00 PM |
4:05 PM |
PRESENTER BIOGRAPHIES
Mark Mears
Mark has been working with Systems Management Server since 1996 when version
1.2 was the current version. He spent 5 years at Microsoft assisting customers with their issues in PSS before leaving Microsoft and becoming an SMS consultant. For the past 4 years, he has been enjoying his time assisting a variety of customers with their Systems Management issues and designs. He is currently the operational SMS Administrator at Macy's Systems and Technologies in John's Creek.
Greg Cameron
Greg Cameron is a Senior Product Technology Specialist with Microsoft working in the Communications Sector. He has been with Microsoft for 6 years and has been involved with technical sales of Virtualization, Server Operating System and Management solutions while at Microsoft. Greg has been in the Technology industry for 9 years in Server Operations/Architecture Manager for Fortune 100 company, Technical Sales and Consulting. Prior to that he served as an Officer in the United States Navy and is a graduate of the U.S. Naval Academy. He currently lives in Suwanee, GA.
Hal Rottenberg
Hal Rottenberg is an Admin Frameworks MVP living in Woodstock, Georgia. He is well-known in sysadmin circles for co-hosting the PowerScripting Podcast and heading up the PowerShellCommunity.org website. He is also currently writing a book titles “Managing VMware Infrastructure with Powershell: TFM” to be published by SAPIEN Press.
Evan Orgel
Evan Orgel is a Senior Solutions Engineer for Acresso Software (The Software Business Unit formerly of Macrovision). He supports Enterprise and Government companies working with Adminstudio, InstallShield and Flex Software Licensing products. Prior to joining Acresso Software, Evan Orgel was the Windows Desktop Operation Manager for a large global investment bank where he was responsible for managing the SMS Infrastructure, Software Packaging, Software Deployments, and Security Patch Management. He has over 15 years experience in Windows Systems Management.
Troy Wilch
Intellinet, Consultant
MCSA, MCSE, MCTS:MDOP/ConfigMgr/DDPS
10 years experience in Enterprise level networks
Worked with Softgrid 3.2/4.0/4.1/4.5 since 2005
MDOP Charter program member
Softricity certified professional (before acquisition)
App-V blog columnist on MyItForum.com
Level 5 author on BlogcastRepository.com for App-V video instruction (releasing soon)
Jeremiah Beckett
Jeremiah Beckett is the founder and President of Secure Vantage Technologies Inc. a Microsoft Gold partner that specializes in security and compliance auditing software for System Center and Forefront technologies.
The SMUG agenda for the November 14th meeting. This meeting will be at the Microsoft Office in Alpharetta, GA. When the RSVP link is ready I'll post it. Breakfast and lunch will be provided, as well as some swag.
Special thank you goes out to our presenters, sponsors Acresso Software, Secure Vantage Technologies, and to Microsoft for hosting the meeting.
| Presenters |
Agenda |
Time Start |
Time End |
| SMUG |
Introduction |
9:00:00 |
9:10:00 |
| Mark Mears |
CCMWindows w/ SMS 2003 |
9:15:00 |
9:35:00 |
| Greg Cameron |
System Center Virtualization Management |
9:40:00 |
10:50:00 |
|
Break |
10:50:00 |
11:00:00 |
| Hal Rottenberg |
Managing VMware w/ Powershell (Lunch) |
11:00:00 |
12:10:00 |
| Evan Orgel |
Best Practices for Traditional and Virtual Application Management |
12:15:00 |
1:25:00 |
| Troy Wilch |
App-V / SoftGrid w/ SCCM 2007 R2 |
1:30:00 |
2:40:00 |
|
Break |
2:40:00 |
2:50:00 |
| Jeremiah Beckett |
ACS Design and Planning |
2:50:00 |
4:00:00 |
| SMUG |
Wrap Up |
4:00:00 |
4:05:00 |
Thank you,
Scott Moss - SMUG VP
Just got a reminder from Kevin Holman about where to give feedback to the OpsMgr Product team.
https://connect.microsoft.com/OpsMgrFeedback/Feedback
From the subjects that are already there it looks like some folks have taken them to task, but do not hesitate to give some constructive criticism.
The Microsoft Application Virtualization Management Pack for Systems Center Operations Manager 2007 MP was posted this past Friday. From the web page:
Overview
The Microsoft Application Virtualization 4.5 (App-V) Management Pack enables IT professionals to use Microsoft System Center Operations Manager 2007 to monitor App-V server systems. The Management Pack is designed to maximize Application Virtualization Server availability for handling Application Virtualization Client requests. This component delivers an enterprise-level solution to proactively monitor Microsoft Application Virtualization 4.5 server systems.
Feature Summary
- Monitor and detect Application Virtualization service failures.
- Monitor connectivity errors with external App-V dependent services such as SQL and Active Directory Domain Services.
- Monitor when the backlog of queued requests crosses thresholds.
- Monitor the general health state of the App-V Server.
- Monitor machine-wide health metrics as related to App-V Server components.
- Visually monitor trends in the backlog of queued requests on App-V Servers.
- Monitor the number and type of alerts across the App-V infrastructure.
- Monitor response time when communicating with external services.
We're trying to find presenters for the next Virtual System Center Users Group scheduled for Thursday Nov 13th at noon Central. If you have topics you'd like to present, please send them to admin@systemcenterusergroup.com and we'll work quickly to put together the new schedule and outline.
Please send in your topics by close of business Tuesday October 14th.
We are looking for presenters on topics that are new or current within the System Center management space. Usually there's about 25 to 30 minutes per topic, and the meeting will start Thursday, Nov 13th at noon Central, and will end around 2 pm Central.
If you have anything you'd like presented, please let us know. We look forward to hearing from you!
Take care all!
Scott Moss
Virtual Gopher
Virtual System Center Users Group
http://www.systemcenterusergroup.org
Mark your calendars, the next SMUG meeting will be Friday November 14th at the Microsoft Alpharetta Office. Details of this meeting are still being worked out. The registration link will be available at the end of the week on the SMUG blog; the agenda will also be available on the SMUG blog once it is finalized.
http://www.systemcenterusergroup.org/blogs/smug/default.aspx
Thank you for your Support!
Scott Moss - SMUG VP
Two new Operations Manager articles in the newest release of TechNet Magazine.
Granular Targeting In Operations Manager 2007
Steve Rachui
http://technet.microsoft.com/en-us/magazine/cc983816.aspx
Monitoring Windows Server 2008 with OpsMgr 2007
Pete Zerger
http://technet.microsoft.com/en-us/magazine/cc974507.aspx
More Posts
Next page »