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 Monday, October 5, 2009 10:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 13,890, Visits: 28,285
The management pack is an XML definition. You can read through the XML directly to see the list of rules & monitors. I meant you could go there.

I tried searching. There used to be a list of what was monitored in a management pack. I can't see my old docs because I'm packed up for a move, but I'm pretty sure MS had something online at one point.


----------------------------------------------------
"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
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 #798063
Posted Tuesday, October 6, 2009 10:04 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 12:34 PM
Points: 1,865, Visits: 3,615
Try this:

http://technet.microsoft.com/en-us/library/dd767418.aspx


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #798653
Posted Monday, November 1, 2010 3:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 2, 2010 9:30 AM
Points: 1, Visits: 3
I am using the latest version of operations manager and have imported the sql server 2008 managament pack.

I am getting an error with the input parameter because sql 2008 does not have an entry for DatabaseName$.

Any ideas?

Thanks,
Leo Cono, http://www.YouLoveMe.com - Free Dating
Post #1014174
Posted Monday, November 1, 2010 7:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 1, 2010 7:05 PM
Points: 9, Visits: 172
Hi Rapiddata,
U could try posting to the SCOM forum....
http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/threads

Cheers,
John Bradshaw
Post #1014232
Posted Wednesday, January 11, 2012 1:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 1:00 AM
Points: 1, Visits: 144

I have modified script as per my envrionment

' Param 0: The SQL connection string for the server
' Param 1: The Database to use
Option Explicit

If WScript.Arguments.Count = 2 then
Dim oAPI
Set oAPI = CreateObject("MOM.ScriptAPI")

'Connect to the database
Dim cnADOConnection
Set cnADOConnection = CreateObject("ADODB.Connection")
cnADOConnection.Provider = "sqloledb"
cnADOConnection.ConnectionTimeout = 15
Dim ConnString
ConnString = "Server=" & WScript.Arguments(0) & ";Database=" & WScript.Arguments(1) & ";Integrated Security=SSPI"
cnADOConnection.Open ConnString

'Connection established, now run the code
Dim oResults
Set oResults = cnADOConnection.Execute("name AS 'File Name' , physical_name AS 'Physical Name',
Round((size/128)/1024,2) AS 'Total Size in GB',
Round((CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0)/1024,2) AS 'Used Space in GB',
([size] - Round((CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0)/1024,2)) as 'Free Space In GB'
FROM sys.database_files ORDER BY [Name] ASC")

Dim oBagTotalSize
Dim oBagSpaceUsed
Dim oBagFreeSpace

'Walk the result set
Do While Not oResults.EOF
Set oBagTotalSize = oAPI.CreateTypedPropertyBag(2)
call oBagTotalSize.AddValue("DBName",Cstr(WScript.Arguments(1)))
call oBagTotalSize.AddValue("LogicalName" ,CStr(oResults(0)))
call oBagTotalSize.AddValue("TargetName","TotalSizeInGB")
call oBagTotalSize.AddValue("perfValue",Cstr(oResults(2)))
oAPI.AddItem(oBagTotalSize)

Set oBagSpaceUsed = oAPI.CreateTypedPropertyBag(2)
call oBagSpaceUsed.AddValue("DBName",Cstr(WScript.Arguments(1)))
call oBagSpaceUsed.AddValue("LogicalName" ,CStr(oResults(0)))
call oBagSpaceUsed.AddValue("TargetName","SpaceUsedInGB")
call oBagSpaceUsed.AddValue("perfValue",Cstr(oResults(3)))
oAPI.AddItem(oBagSpaceUsed)

Set oBagFreeSpace = oAPI.CreateTypedPropertyBag(2)
call oBagFreeSpace.AddValue("DBName",Cstr(WScript.Arguments(1)))
call oBagFreeSpace.AddValue("LogicalName" ,CStr(oResults(0)))
call oBagFreeSpace.AddValue("TargetName","FreeSpaceInGB")
call oBagFreeSpace.AddValue("perfValue",Cstr(oResults(4)))
oAPI.AddItem(oBagFreeSpace)

oResults.MoveNext
Loop
cnADOConnection.Close

'return the property bag objects
Call oAPI.ReturnItems
End If


Post #1233765
Posted Wednesday, January 11, 2012 4:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 13,890, Visits: 28,285
And is it working for you?

----------------------------------------------------
"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
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 #1233880
« Prev Topic | Next Topic »

Add to briefcase «««45678

Permissions Expand / Collapse