SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Operations Manager Custom Collection


Operations Manager Custom Collection

Author
Message
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: General Forum Members
Points: 42417 Visits: 32667
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:

- 
Microsoft.SQLServer.Library
6.0.6247.5
XXXXXX




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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
j.bradshaw
j.bradshaw
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 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:

- 
Microsoft.SQLServer.Library
6.0.6247.5
XXXXXX




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
j.bradshaw
j.bradshaw
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 172
Nope...Can't get anything to populate.
Any ideas as to what is missing??
Thx,
JB
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: General Forum Members
Points: 42417 Visits: 32667
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
j.bradshaw
j.bradshaw
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 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
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: General Forum Members
Points: 42417 Visits: 32667
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
j.bradshaw
j.bradshaw
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 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
FreeHansje
FreeHansje
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1285 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
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: General Forum Members
Points: 42417 Visits: 32667
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
FreeHansje
FreeHansje
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1285 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search