Updating SQL Server Analysis Services Via PowerShell

If you use the GUI install both the SQL Database Engine and SQL Analysis Services in the same server by clicking "Ok" and "Next" a lot, the default memory settings used by the DB Engine and SSAS allow for a risk of them starving each other and/or the operating system of memory.  This can be…

0

Azure Storage Analytics Metrics Management Pack

This is a draft of a SCOM management pack I made for Azure Storage Analytics Metrics.  It's not up to the quality of an officially released MP, but feel free to use/share/dissect at your own discretion. This MP requires version 1.1.42.0 or higher of the Windows Azure MP found here: http://www.microsoft.com/en-us/download/details.aspx?id=38414 It will not work with…

0

Read the Azure Storage Analytics Metrics Table with PowerShell

Another script I recently needed to read Azure Storage Analytics Metrics. Here is the table schema if you need additional or different information. http://msdn.microsoft.com/en-us/library/azure/hh343264.aspx Please note that metrics are calculated when an aggregation period ends and are not available immediately.  If you run my script as-is, it will attempt to get blob metrics from the…

2

Query Azure Storage with PowerShell but without the SDK or Cmdlets

I had a need to query Azure Storage via PowerShell, but I was not guaranteed that the machines I'd be running from would have either the Azure SDK or the Azure PowerShell Cmdlets installed. The script below (and in the attached .ZIP file) does not require the Azure SDK or the Azure PowerShell Cmdlets The…

0

Discovery Does Not Work in ADFS 2012 R2 MP

UPDATE Version 7.1.10100.1 of the management pack, published on June 16, 2014 has addressed the specific issue I called out in the post below.  I have tested this version and confirmed that (at least for my systems) discovery now works without my work-around. I know there are other concerns raised for the MP, but in…

12

Use PowerShell to Create and Update Performance Counters

SCOM has a wonderful ability to take data from custom data sources, such as scripts, and treat them as performance counters with the System.Performance.DataGenericMapper module.  For more information please see http://msdn.microsoft.com/en-us/library/ee692961.aspx However, sometimes you might need to create a "real" performance counter that people can see with PerfMon for real-time debugging. Below is a simple…

0

PrincipalName and NetworkName

One of the most commonly used classes in SCOM is Microsoft.Windows.Computer from the Microsoft.Windows.Library management pack.  It has a number of properties including: Microsoft.Windows.Computer PrincipalName DNSName NetbiosComputerName NetworkName The property of NetworkName has caused me a lot of grief because some (poorly written?) management packs use it interchangeably with PrincipalName.  I'm not exactly sure how…

0