Operations Manager 2007 SQL Collection Article

June 5, 2008 at 7:27 am (SCOM, TSQL) (, , , )

It took me a while to find all the little pieces to put together a custom rule that used data collected through TSQL. In fact, because it took so much work to pull all the little pieces together, I wrote an article describing how I did it. This isn’t a wonderful new invention. It’s just the publication of a bunch of research. If you’re an Operations Manager expert, this isn’t for you. If you’re like I am, trying to find your way through the forest, this little bit of map will hopefully provide some assistance. Available at SQL Server Central.

Advertisements

Permalink 1 Comment

SCOM Custom Performance Collection

May 7, 2008 at 6:08 pm (SCOM) (, , )

I’ve spent five days struggling with this, but I finally have a custom performance collection up and running. The documentation available for Operations Manager 2007 (SCOM), especially for customization, especially for databases, is weak, and that’s being kind. However, there are some guys working hard out there to make a difference. If you need help, the System Center Forum is the place to go. In particular, this little ditty on using property bag objects finally cracked the code for me. The good news, I’m going to write this up in an article for Steve over at SQL Server Central. The better news, I can finally report progress in my daily stand-ups. Sheesh!

Permalink 1 Comment

SCOM VBScript Testing: The Answer

May 6, 2008 at 11:18 am (SCOM) (, , , )

It took a while, but I finally tracked down the information I needed. SCOM has an SDK. In the SDK is a nice little page showing how to test & debug scripts. One of the links on that page leads out here to a great article on the VBScript debugger. That’s what I needed (along with the DLL’s to register). Anyway, I’ve almost got my first monitoring script up & running. I’ll post it on here once I do.

Permalink 2 Comments

SCOM VBScript Testing

May 2, 2008 at 2:51 pm (SCOM) (, , , , )

Surely there’s an enterprising young developer (I’m out on two of those counts) who has written a testing engine to validate VBScripts for SCOM prior to implementing them. Where are you? I need you!

Permalink Leave a Comment

SCOM Solution

April 2, 2008 at 6:47 pm (SCOM) (, , )

I had posted a problem I was having with SCOM below. I got a good answer to the problem in the Microsoft discussion group. It was a silly little thing. The “SQL” alias inside the object needed a reference placed within the Management Pack definition. I’ve still go so much to learn about this tool.

Permalink Leave a Comment

System Center Operations Manager Unleashed

April 1, 2008 at 2:09 pm (SCOM) (, , )

I posted a small review of the book over on Amazon. I’ve found this a very useful resource towards getting SCOM up & running. That’s in the short time I’ve had it. I suspect it’ll become even more useful as the days go on.

Permalink 1 Comment

SCOM Problem

April 1, 2008 at 12:17 pm (SCOM) (, , , , )

I’m stuck. I posted this last week on the Microsoft SCOM newsgroup, but I’m not getting any responses. On the off chance that the 5 people a day who read this site might know the answer, here’s the question as posted:

I’m sure this is something fundamental and simple, but I’m honestly
stuck.
I’m attempting to capture a new Performance Counter, Plan Cache, Cache
Hit Ratio, Object Plans & SQL Plans. When I lay it out to create it, I
get the attached error. I’m assuming based on the “Unknown alias” and
the fact that I’m in a custom management pack, something is amiss with
the Management Pack. What? Any help at all would be appreciated.

Date: 3/28/2008 11:29:55 AM
Application: System Center Operations Manager 2007
Application Version: 6.0.6246.0
Severity: Error
Message:

: Processing the template failed. See inner exception for details.
Verification failed with [1] errors:
——————————————————-
Error 1:
: Verification failed for rule:
MomUIGeneratedRulea4c32409c6a04ff786d9570af7d90d5f

Failed to verify referenced module : ID=DSInvalid configuration
specified for Module [DS]Cannot resolve identifier [SQL!
Microsoft.SQLServer.DBEngine] in the context of ManagementPack
[FMG.SQL.Management.Pack]. Unknown alias [SQL]
——————————————————-
Verification failed for rule:
MomUIGeneratedRulea4c32409c6a04ff786d9570af7d90d5f
Failed to verify referenced module : ID=DSInvalid configuration
specified for Module [DS]Cannot resolve identifier [SQL!
Microsoft.SQLServer.DBEngine] in the context of ManagementPack
[FMG.SQL.Management.Pack]. Unknown alias [SQL]
: Verification failed with [1] errors:
——————————————————-
Error 1:
: Verification failed for rule:
MomUIGeneratedRulea4c32409c6a04ff786d9570af7d90d5f

Failed to verify referenced module : ID=DSInvalid configuration
specified for Module [DS]Cannot resolve identifier [SQL!
Microsoft.SQLServer.DBEngine] in the context of ManagementPack
[FMG.SQL.Management.Pack]. Unknown alias [SQL]
——————————————————-

Verification failed for rule:
MomUIGeneratedRulea4c32409c6a04ff786d9570af7d90d5f
Failed to verify referenced module : ID=DSInvalid configuration
specified for Module [DS]Cannot resolve identifier [SQL!
Microsoft.SQLServer.DBEngine] in the context of ManagementPack
[FMG.SQL.Management.Pack]. Unknown alias [SQL]
: Verification failed for rule:
MomUIGeneratedRulea4c32409c6a04ff786d9570af7d90d5f

Failed to verify referenced module : ID=DSInvalid configuration
specified for Module [DS]Cannot resolve identifier [SQL!
Microsoft.SQLServer.DBEngine] in the context of ManagementPack
[FMG.SQL.Management.Pack]. Unknown alias [SQL]
: Failed to verify referenced module : ID=DS
Invalid configuration specified for Module [DS]Cannot resolve
identifier [SQL!Microsoft.SQLServer.DBEngine] in the context of
ManagementPack [FMG.SQL.Management.Pack]. Unknown alias [SQL]
: Invalid configuration specified for Module [DS]
Cannot resolve identifier [SQL!Microsoft.SQLServer.DBEngine] in the
context of ManagementPack [FMG.SQL.Management.Pack]. Unknown alias
[SQL]
: Cannot resolve identifier [SQL!Microsoft.SQLServer.DBEngine] in the
context of ManagementPack [FMG.SQL.Management.Pack]. Unknown alias
[SQL]

Permalink 6 Comments

New SCOM Book

March 28, 2008 at 12:04 pm (SCOM) (, , , , )

I got a new SCOM book in the mail yesterday, System Center Operations Manager Unleashed. It’s friggin’ huge. I’ve just started reading through it and it looks pretty good. So far, it’s much more thorough than the only other book available for SCOM, Mastering System Center Operations Manager 2007. I’m going to ready through more of it before I post a review to Amazon. I think I’ll write up a review for the PASS book reviews too. Hey, if you have time on your hands, get on over there, request a book and write up your own review.

Permalink Leave a Comment

SCOM As a Code Source

March 25, 2008 at 2:28 pm (SCOM) (, , , , )

A friend has had an article posted over on SQL Server Central that’s worth a read. Scott Abrants outlines the type of code that SCOM uses for SQL Server auditing and how you can leverage that outside of SCOM for other work you may be doing. As noted in the comments, it’s also worth taking a look at how Microsoft set up it’s rules and monitors as a method for setting up your own.

Permalink Leave a Comment

SCOM SQL Agent Job Defaults

March 18, 2008 at 5:19 pm (SCOM) (, , )

I’m working through implementing SCOM, specifically the SQL Server Management Packs. I’ve been tweaking and tuning and for the most part I’m really impressed with how MS configured the defaults. Until today. Since I’ve hit all the really big and important monitors & rules (at least the ones that have caused problems) I’m starting to drill down a bit. I just hit the Duration monitor for SQL Agent Jobs. The run time for a warning state is 1 minute and an error state in 2 minutes. OK. So any backup on a database over about 2gb in size is going to go into a warning state? I don’t think so. What the heck were these guys thinking of?

Permalink Leave a Comment