Operations Manager Custom Collection

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Grant Fritchey » Operations Manager Custom Collection

76 posts, Page 2 of 8

««1 2 3 4 5 »»»

Operations Manager Custom Collection

Rate Topic

Display Mode

Topic Options

Author

Message

Grant Fritchey

Posted Monday, June 09, 2008 5:45 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 13,436, Visits: 25,281

File groups, I'm working on. Several people have asked the same question. I'll post something as soon as I have a complete story.

Custom reporting, since these properties are collected just like any other, you can easily and quickly create a view in the Monitoring console. Otherwise, the data is stored into the datawarehouse in the same manner as all the other rules and so, if you've figured out how to query data from there, you can pull this data too. This could be an article too. No one from MS has published a model on how to do this. I've got some custom reports working from data collected, but it was labor to get them going.

----------------------------------------------------
"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 #513638

Grant Fritchey

Posted Monday, June 09, 2008 7:07 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 13,436, Visits: 25,281

I'm not sure why you'd want to manage by FileGroup, but... What if you set up the same process that I outlined, but used this query to gather the data. I think it'd do what you want.

SELECT  fg.GroupName
       ,SUM(f.size / 128.) AS TotalSizeInMB
       ,SUM(CAST(FILEPROPERTY(f.NAME, 'SpaceUsed') AS INT) / 128.) AS SpaceUsedInMB
       ,SUM(f.size / 128. - CAST(FILEPROPERTY(f.NAME, 'SpaceUsed') AS INT) / 128.) AS FreeSpaceInMB
FROM    dbo.sysfiles f
JOIN [dbo].sysfilegroups fg
ON f.groupid = fg.groupid
GROUP BY fg.GroupName

----------------------------------------------------
"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 #513684

SQLEngine

Posted Monday, June 09, 2008 7:35 AM

Valued Member

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:29 AM
Points: 53, Visits: 224

:)Grant, that's the join I was looking for, thanks.

I could use it in the same VBS you posted earlier, absolutely. The chellenge I am facing now is reporting on this.

I tried creating a view, scope on the same target as the Rule is on, and check "collected by specific rule". But I get 'No Performance Counter is Selected...' And the legend is empty, so I think no data is being gathered. I'll play with this a little more, but your help is aappreciated!

Thanks

Post #513703

Grant Fritchey

Posted Monday, June 09, 2008 7:54 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 13,436, Visits: 25,281

The first time I created the rule, it took a while for it to actually gather the data. I'm assuming that was time spent sending everything out to all the various agents. Also, since I only collect data once a day, the default on the views is to show only a day's worth of data, but if the process hasn't run yet today, it just shows as blank. Changing the date range to two or more days makes the difference.

Good luck. Let me know if you run into any other issues.

----------------------------------------------------
"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 #513723

Marios Philippopoulos

Posted Thursday, August 07, 2008 7:27 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 2:25 PM
Points: 1,825, Visits: 3,484

Grant Fritchey (6/5/2008)

Thanks guys. I realize it's kind of an obscure topic, but I had such a hard time tracking down the individual pieces of information that I felt compelled to share it so the next person has a slightly easier time.

Great article, thanks for writing about SCOM. I've been having a hard time working with SCOM, since, as you yourself mention, information is not well organized out there. It's been very frustrating.

Please keep those SCOM articles coming, they are a valuable resource.

__________________________________________________________________________________

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 #548798

Grant Fritchey

Posted Friday, August 08, 2008 5:56 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 13,436, Visits: 25,281

Thanks. I'm glad it was at all helpful. Keep an eye out for Thomas LaRock articles too. I know he's got a new one coming becuase he let me review it before he sent it in to Steve. He's been working with OpsMgr quite a while longer than I have, so he's worth listening to.

----------------------------------------------------
"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 #549033

Marios Philippopoulos

Posted Friday, August 08, 2008 10:31 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 2:25 PM
Points: 1,825, Visits: 3,484

Grant Fritchey (8/8/2008)

That's great to hear.

Please guys, keep these articles coming. I'm working with MS support right now on creating custom functionality similar to yours, and I'm frustrated to no end. They in effect told me that what I'm trying to do (create a custom rule/monitor based on a vbs script) is not possible. Instead I should create a SQL job that runs on a schedule and writes the information to the Event Log for SCOM to pick it up! What's even the point of using SCOM if I have to rely on a SQL Server job for monitoring? Crazy

I can live with poor documentation, but when even MS support does not help me, then that's the ultimate...

__________________________________________________________________________________

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 #549406

Grant Fritchey

Posted Friday, August 08, 2008 10:35 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 13,436, Visits: 25,281

Yeah, that's pretty common. We have a Microsoft consultant who comes in on site to help us with OM issues. I showed him what I was doing and he started taking notes. It didn't fill me with confidence.

Say, you wouldn't know if there was a rule or monitor in place that caught logged errors with a severity greater than, say, 17?

----------------------------------------------------
"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 #549409

Marios Philippopoulos

Posted Friday, August 08, 2008 10:42 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 2:25 PM
Points: 1,825, Visits: 3,484

Grant Fritchey (8/8/2008)

:D That's hilarious!

Somewhere someone has documented all this stuff about context parameters etc. Why hasn't Microsoft bothered to put it up on msdn? w00t

My initial answer would be they want to make $$$ off support fees.
But, now I'm not so sure after the experience I've been having...

Regarding your question, I don't know of anything like this at the moment, but will let you know if I come across anything.

__________________________________________________________________________________

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 #549413

SQLEngine

Posted Friday, August 08, 2008 3:11 PM

Valued Member

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:29 AM
Points: 53, Visits: 224

Marios, I agree completely. I've had some "challenges" dealing with MS support as well, and have found lack of documentation and expertise... So that's why these posts, blogs, forums etc are priceless, way more useful than PSS.;)

Post #549610

« Prev Topic | Next Topic »

76 posts, Page 2 of 8

««1 2 3 4 5 »»»

Permissions