June 17, 2008 at 3:43 pm
In the Authoring pane I created an override for the Blocking monitor under the SQL 2005 DB Engine target: set the wait time to 1 min. to be alerted if blocking exceeds 1 min.
However, I cannot get the alert to work. I am simulating a blocking simulation on the test machine and I see no alert after 1 min.
What am I missing?
__________________________________________________________________________________
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]
June 18, 2008 at 7:44 am
I think the frequency is also going to affect this. You would have to check often enough to catch the event as it occurs.
"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
June 18, 2008 at 7:47 am
Grant Fritchey (6/18/2008)
I think the frequency is also going to affect this. You would have to check often enough to catch the event as it occurs.
Thank you, do you know where I can get info on each of the individual override parameters? Some of them, eg. "enabled", are self-explanatory but not others, such as frequency.
I haven't been able to find this info anywhere...
__________________________________________________________________________________
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]
June 18, 2008 at 8:16 am
There's not a good source for this information. Experimentation is how I'm getting by.
I can recommend three sources that can help, in addition to posting here (althouth only a few of us are using SCOM). First, get a copy of "System Cetner Operations Manager 2007 Unleashed". Great book. Unfortunately it doesn't cover the SQL Server management pack all that well. SystemCenter.Org is completely indespensible. Again, their coverage of the SQL Server management pack is a bit sparse. Finally, microsoft.public.opsmgr.sql has very good information. What few Ops Manager MVP's that I've seen around all post there.
Watch for articles by Tom LaRock. He really knows what he's talking about. He's presenting again this year at the PASS summit. I went last year. It was helpful.
"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
June 18, 2008 at 8:21 am
Grant Fritchey (6/18/2008)
There's not a good source for this information. Experimentation is how I'm getting by.I can recommend three sources that can help, in addition to posting here (althouth only a few of us are using SCOM). First, get a copy of "System Cetner Operations Manager 2007 Unleashed". Great book. Unfortunately it doesn't cover the SQL Server management pack all that well. SystemCenter.Org is completely indespensible. Again, their coverage of the SQL Server management pack is a bit sparse. Finally, microsoft.public.opsmgr.sql has very good information. What few Ops Manager MVP's that I've seen around all post there.
Watch for articles by Tom LaRock. He really knows what he's talking about. He's presenting again this year at the PASS summit. I went last year. It was helpful.
Thank you for all this info, it's great!
I have the "Unleashed" book, it's very good, but, as you say, light on SQL.
I am frustrated that BOL is so poor on SCOM, this info should all be there!
Luckily I also have access to online MS support, and I intend to use it to the hilt! 🙂
__________________________________________________________________________________
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]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply