No More SQL Run As Account?

A good friend of mine, Ralph Kyttle, who works at Microsoft as an MCS Consultant in the DC area, recently pinged me about a new configuration he was testing which circumvented the use of a traditional SQL Run As Account.  Rather than configuring the traditional SQL Run As Account (we all know how much fun that is), the Health Service was configured to use a Service Security Identifier (SID) which allows the SCOM agent to monitor SQL server without all of the tedious permission configuration.  To add even more value, Kevin Holman published a great blog post yesterday highlighting the details of this configuration and added a really cool monitor and tasks to help ensure that this configuration is functioning properly. Very cool stuff!

Have a look at Kevin’s blog post here for more details.


Azure Automation PowerShell ISE add-on

Very cool feature blogged on the MSOMS blog on Friday.  Microsoft has released a PowerShell ISE add-on for Azure Automation which allows us to easily work from a local PowerShell ISE session and it automatically downloads the subscription, automation account, certificate thumbprint information, existing runbooks, etc.  I was able to download the module and start working in less than 10 minutes.  Click the link below to read more!

Creating an Exchange Solution in OMS

With the recent release of View Designer in OMS, we now have the capability to use the power of log search to create our own custom solutions.  This capability is very powerful and allows us to create single pane of glass dashboards across data sets for any technology for which we are collecting data.  Nice! 

For the purpose of this demo, I will create a custom Exchange solution, but it’s important to note that this same process can be used for any application or technology.

There are a few good blogs out there which detail how to pull Exchange performance and event data into OMS. I want to take this functionality a bit further and detail how we can utilize this data to create a custom Exchange solution in OMS using the newly released View Designer. For the purpose of this demo, I will configure OMS to collect 4 specific mailbox performance KPIs, configure a custom solution to visualize the data, and add a few saved queries to a List Of Queries blade which will link to performance graphs for root cause analysis and monitoring.  It’s important to note that this process can be used to create a custom solution for any technology.  If the data is collected by OMS, it can be utilized in a solution. 

 Note: The KPIs and logs used in this example are for demonstration only.  Any KPIs or logs can be substituted to suit your particular monitoring requirements.

Let’s get started!

Continue reading