Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««45678»»

Operations Manager Custom Collection Expand / Collapse
Author
Message
Posted Tuesday, August 25, 2009 7:34 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:51 AM
Points: 14,788, Visits: 27,264
Nah, let's keep it on here. If the article wasn't clear, this can help to explain the issues for someone else.

No, don't put in the name of a single server. You're right, that's not how it's supposed to work. This is from our local management pack:

- <Reference Alias="SQLServer3">
<ID>Microsoft.SQLServer.Library</ID>
<Version>6.0.6247.5</Version>
<PublicKeyToken>XXXXXX</PublicKeyToken>
</Reference>

That Reference Alias, that's what you need from your own management pack. I had a hard time figuring that part out too.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #777206
Posted Wednesday, August 26, 2009 2:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 01, 2010 7:05 PM
Points: 9, Visits: 172
Grant Fritchey (8/25/2009)
Nah, let's keep it on here. If the article wasn't clear, this can help to explain the issues for someone else.

No, don't put in the name of a single server. You're right, that's not how it's supposed to work. This is from our local management pack:

- <Reference Alias="SQLServer3">
<ID>Microsoft.SQLServer.Library</ID>
<Version>6.0.6247.5</Version>
<PublicKeyToken>XXXXXX</PublicKeyToken>
</Reference>

That Reference Alias, that's what you need from your own management pack. I had a hard time figuring that part out too.


Thx again Grant. tantalisingly close.
I am using R2 for SCOM and the latest SQL(2005) MP.
For this exercise a new MP was created SQLa.
I can do everything EXCEPT enter parameters.

If the parameters are left out, I can save the new rule, no proplems.
I can also from the Properties of the rule, Edit the script and select Parameters from the little Target button. They work fine. I can then save the rule.

BUT, when I try to enter the two lines as mentioned previously, SCOM spits the dummy and won't save the rule.

So I went in to the XML for the new MP and can't find Microsoft.SQLServer.Library that looks like the example given.

Mine looks like:

Reference Alias="MicrosoftSQLServerLibrary6066480">
Microsoft.SQLServer.Library
6.0.6648.0
31bf3856ad364e35


So I cut out the MicrosoftSQLServerLibrary6066480 and get

$Target/Host/Property[Type="MicrosoftSQLServerLibrary6066480!Microsoft.SQLServer.DBEngine"]/ConnectionString$
$Target/Property[Type="MicrosoftSQLServerLibrary6066480!Microsoft.SQLServer.Database"]/DatabaseName$

That then saves OK! Seems like a strange string to paste in.
Let's see what populates.
Now to get the view working....
Thx,
John Bradshaw
Post #777856
Posted Wednesday, August 26, 2009 6:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 01, 2010 7:05 PM
Points: 9, Visits: 172
Nope...Can't get anything to populate.
Any ideas as to what is missing??
Thx,
JB
Post #777978
Posted Thursday, August 27, 2009 5:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:51 AM
Points: 14,788, Visits: 27,264
Yep, you found your alias (there is a way to edit that, but I'm not sure what it is). If it saved, you should be there. You mapped the property bag to get the data out? After that, you should be able to create a view based on the rule. It'll take a little while for the rule to populate out to the servers and then a while for the data to start coming back, but usually I've seen results back into the database within 45 minutes or so.

You might need to go on to one of your servers and see if errors are being generated. There's no easy way to debug these things. We don't even bother setting up a dev/test/staging process to get new rules into production.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #778191
Posted Thursday, August 27, 2009 4:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 01, 2010 7:05 PM
Points: 9, Visits: 172
Still no data. The mapping seems fine. Script is there. But can't see anything in a Performance view. Then I thought i would take a look at what the MS SQL management pack offered and there was a Performance view for Database free Space. Looks like they have incorporated this in the latest MP as standard.
Of-course the DBA's now want it in a table format rather than a performance view......
Thx for all the help Grant. I learnt a lot.
JB
Post #778791
Posted Thursday, August 27, 2009 7:06 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:51 AM
Points: 14,788, Visits: 27,264
j.bradshaw (8/27/2009)
Still no data. The mapping seems fine. Script is there. But can't see anything in a Performance view. Then I thought i would take a look at what the MS SQL management pack offered and there was a Performance view for Database free Space. Looks like they have incorporated this in the latest MP as standard.
Of-course the DBA's now want it in a table format rather than a performance view......
Thx for all the help Grant. I learnt a lot.
JB


Did you create a new view specifically for this rule? It didn't sound like it based on what you said.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #778847
Posted Thursday, August 27, 2009 7:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 01, 2010 7:05 PM
Points: 9, Visits: 172
Hi Grant,
Yes I did, and I could select the rule I created, but still nothing came through.
Seems so close, but I cannot find what I am doing wrong.
Thx,
John Bradshaw
Post #778849
Posted Monday, October 05, 2009 6:20 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 06, 2012 8:30 AM
Points: 879, Visits: 810
General question:
I would like to check on the rules of MP for SQL Server for SCOM, but sofar I have not been able to find anything on this, not even on the Microsoft site. Is there a list somewhere, or do I really have to install a trial version in order to look at those standard rules?!




Greetz,
Hans Brouwer
Post #797810
Posted Monday, October 05, 2009 7:13 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:51 AM
Points: 14,788, Visits: 27,264
You don't need to install Operations Manager. You can download the sql server management pack and then review what it does.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #797859
Posted Monday, October 05, 2009 8:24 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 06, 2012 8:30 AM
Points: 879, Visits: 810
Hm, maybe I misunderstand what you mean: I have downloaded this managementpack(we have SCOM installed) but in the readable objects I cannot find a list with rules for SQL Server, only a general overview of what can be monitored and how to set this up.


Greetz,
Hans Brouwer
Post #797935
« Prev Topic | Next Topic »

Add to briefcase «««45678»»

Permissions Expand / Collapse