August 12, 2008 at 9:45 am
Here's the bad news, the amount of good information in a single source on writing custom reports in OpsMgr is even less than that for programming against it.
Have fun!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2008 at 9:52 am
Grant Fritchey (8/12/2008)
Hopefully, you're right. It does seem like this one may have missed a point or two. Something to keep in mind for the next one.
You've definitely written more than I have, but if you set a goal to present concept A and you presented concept A clearly then you have not missed anything. Now if readers add concept B or are looking for concept B, then you now have an opportunity for follow-up. If the point of an article is to show how to do a full database backup and restore and people then ask about Transaction Log backup restore, it doesn't mean the author missed anything, it means that they left the readers wanting more. Remember the old show biz. adage, "Always leave them wanting more".
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 12, 2008 at 9:55 am
Grant Fritchey (8/12/2008)
Here's the bad news, the amount of good information in a single source on writing custom reports in OpsMgr is even less than that for programming against it.Have fun!
Rats, back to cursing then!! :crazy:
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
August 12, 2008 at 10:04 am
Lots of cursing. If you run out of good words, let me know. I used to be a sailor.
😉
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2008 at 10:07 am
Grant Fritchey (8/12/2008)
Lots of cursing. If you run out of good words, let know. I used to be a sailor.😉
Maybe that's the recipe of success with SCOM, I'll keep it in mind... 😛
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
August 12, 2008 at 11:19 am
Grant, your article is VERY helpful, and I found more useful stuff in it than in Microsoft "documentation". So, thank you for that. I can't wait till the next one:)
August 12, 2008 at 11:44 am
Thanks.
I've been remiss in my writing just lately (Tom, who I'm supposed to be working with, is going to kick my butt). There will be another OpsMgr article in the future though. I'm just not sure when.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2008 at 11:46 am
Grant Fritchey (8/12/2008)
Thanks.I've been remiss in my writing just lately (Tom, who I'm supposed to be working with, is going to kick my butt). There will be another OpsMgr article in the future though. I'm just not sure when.
I'm even thinking of writing one myself.
Making SCOM work properly feels like having superhuman abilities...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
August 12, 2008 at 11:59 am
Go for it. The more knowledge that gets out there, the better.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2008 at 1:43 pm
Grant Fritchey (8/12/2008)
Sorry I haven't been taking part in the discussion. Rhode Island celebrates VJ Day so I had the day off... Whatever.Adding in reporting or views would be a good idea, but they were so easy to do after all the work around getting the data into a property bag, that it just didn't occur to me.
The goal of my process here was to gather data for long term reporting and trending, not as a monitor and response. That dictated the use of the Probe. That exposes the property bag object which is how you get data into OpsMgr for long term storage and management. The first time I created the rule and the scripts, I didn't get data because I had it set to run once a day. To verify it was working correctly, I initially created it with data collection for once every 5 minutes. Within a while, I think about 45 minutes, of creating the rule, I began to see data. It took a while for it to send it out to all the servers and then begin collecting.
The report I'm running currently is just a query using the RuleRowId to identify the appropriate rule. It'll be different in every system, so just query the vRule view to see which one is appropriate. I was also able to create view by selecting the rule name. It should be available after the data collection starts. If it isn't, there may be a problem with the script, or the Probe definition. I had a lot of trouble figuring out how to get the Probe definition right.
I'm sorry the article wasn't clear enough on these points. I was really hoping to help people who had been stuck like I was. It seems I may have just muddied the waters more.
To get any SCOM configuration changes, such as a rule change, to be propagated to the managed objects as quickly as possible, restart the OpsMgr Health Service on the managed computer(s). This will force the agent(s) to retrieve the changes from the RMS.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
August 13, 2008 at 6:41 am
Good to know. Unfortunately, with the division of labor where I work, I don't have the ability to do that. But if I really need it, I know what to ask for now, thanks.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 13, 2008 at 7:32 am
Grant Fritchey (8/13/2008)
Good to know. Unfortunately, with the division of labor where I work, I don't have the ability to do that. But if I really need it, I know what to ask for now, thanks.
We actually have a sandbox SCOM environment where I am allowed to play at will. Once my functionality is ready to deploy I export my MPs and ask our Windows sysadmins to import to the production SCOM.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
August 27, 2008 at 8:07 pm
Hi Grant
Brilliant article and very timely. We have a number of SQL 2005 servers that do not have legacy components installed, hence no DMO. This means database space information is not available.
I have used your script to gather the DB space information and it is working beautifully.
My question is, how can I also monitor the DB space as well as view it? Do I have to duplicate the entire script in a monitor as well as a rule? I want to have an alert fire when DB free space gets less than 10% on data files or logs.
Cheers
Luke
August 31, 2008 at 7:49 am
I would to research it to verify for sure, but I think you can simply point a monitor at a rule and respond to the data collected there. No extra scripting should be required.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 2, 2008 at 3:42 pm
Grant, could you polease clarify what you mean by "pointing the monitor at the rule"? When creating a unit monitor I don't see anything that looks like Rule based monitor. I see:
SNMP
WMI PERF counters
Log Files
Windows Events
Windows Services
Windows perf Counters
Scripting
WMI Events
Which one of these did you mean?
Tnx
Viewing 15 posts - 31 through 45 (of 75 total)
You must be logged in to reply to this topic. Login to reply