|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 13,371,
Visits: 25,145
|
|
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
|
|
|
|
|
Forum 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
|
|
|
|
|
Forum 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
|
|
|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 13,371,
Visits: 25,145
|
|
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
|
|
|
|
|
Forum 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
|
|
|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 13,371,
Visits: 25,145
|
|
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
|
|
|
|
|
Forum 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
|
|
|
|
|
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
|
|
|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 13,371,
Visits: 25,145
|
|
|
|
|
|
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
|
|
|
|