Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
Don't Build a Monitoring System
39 posts, Page 1 of 4
1
2
3
4
»
»»
Don't Build a Monitoring System
Rate Topic
Display Mode
Topic Options
Author
Message
Grant Fritchey
Grant Fritchey
Posted Saturday, September 12, 2009 3:30 PM
SSChampion
Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 13,383,
Visits: 25,187
Comments posted to this topic are about the item
Don't Build a Monitoring System
----------------------------------------------------
"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 #786917
SQLNightOwl
SQLNightOwl
Posted Sunday, September 13, 2009 3:37 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, April 22, 2013 3:55 PM
Points: 179,
Visits: 391
Sounds like a good plan. Do a tool comparison but don't select a "winner" because that's a matter of preference. Then drill in with a how to on each one.
--Paul Hunter
Post #787068
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Sunday, September 13, 2009 4:01 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 12:01 PM
Points: 31,436,
Visits: 13,750
We've tried to figure out how to do this well here for years, but never came up with a good way. Plus we were bound by advertising contracts, which could have influenced us.
I think part of the issue is that many people don't want to push a particular product since people will assume they are being compensated somehow. Lots of MVPs fight this image, despite all the complaints they publicly make about Microsoft products.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #787074
giaks0wn
giaks0wn
Posted Monday, September 14, 2009 3:58 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, April 15, 2011 4:59 AM
Points: 3,
Visits: 60
Reminds me of a corporate finance class with the instructor determined to make sure you could recite the formulas. Sure, everyone knew which calculator button to push and in the order necessary to get the answer, but he was determined we should know the behind the keypad process in case we needed to calculate in a moment the return value or PI. Does the same theory apply here? If you work in consultancy, could you enter any company, without your favorite monitoring app, and tell them if "everythings OK"? Discuss the benefits of third party solutions, but ceasing to teach and reinforce the fundamentals would be a grave loss.
Post #787283
David.Poole
David.Poole
Posted Monday, September 14, 2009 4:01 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 8:46 AM
Points: 2,750,
Visits: 1,410
If I am a fan of a tool then I have no qualms about pushing that tool regardless of who produces it.
There will always be people who complain about a reviewer "selling out" or being partisan. They are noisy but in the minority.
Most readers will simply use a review to supplement (but not replace) their own research.
There will always an element of personal preference. I personally like the Quest tools but find their UI a bit fiddly and counter-intuitive, someone else may disagree on either or both points. If the reviewer sticks with the facts and keeps the emotives to the minimum then what is the problem?
LinkedIn Profile
Post #787285
Grant Fritchey
Grant Fritchey
Posted Monday, September 14, 2009 5:38 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 13,383,
Visits: 25,187
giaks0wn (9/14/2009)
Reminds me of a corporate finance class with the instructor determined to make sure you could recite the formulas. Sure, everyone knew which calculator button to push and in the order necessary to get the answer, but he was determined we should know the behind the keypad process in case we needed to calculate in a moment the return value or PI. Does the same theory apply here? If you work in consultancy, could you enter any company, without your favorite monitoring app, and tell them if "everythings OK"? Discuss the benefits of third party solutions, but ceasing to teach and reinforce the fundamentals would be a grave loss.
That's an excellent point. It really is important that people understand the fundamentals, whether they use a tool or not. But it's especially important if they use a tool that understand what it's doing, what it can do, why, what it can't do, why, and where it derives the information it presents. This makes you into an adminstrator of the tool, not simply a user. Great 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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans
Product Evangelist for
Red Gate Software
Post #787347
Grant Fritchey
Grant Fritchey
Posted Monday, September 14, 2009 5:40 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 13,383,
Visits: 25,187
David.Poole (9/14/2009)
If I am a fan of a tool then I have no qualms about pushing that tool regardless of who produces it.
There will always be people who complain about a reviewer "selling out" or being partisan. They are noisy but in the minority.
Most readers will simply use a review to supplement (but not replace) their own research.
There will always an element of personal preference. I personally like the Quest tools but find their UI a bit fiddly and counter-intuitive, someone else may disagree on either or both points. If the reviewer sticks with the facts and keeps the emotives to the minimum then what is the problem?
I do agree, but see Steve's point. I have my preferred tools, and anyone who has been around me for a presentation or a chat could figure them out PDQ. But, I don't want to be associated with any one company because I recognize good in almost all the companies whose tools I've worked with or evaluated. It's just way to easy to be associated with only one organization (although, I freely admit to being pretty much a shill for Microsoft, can't help that one).
----------------------------------------------------
"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 #787351
scott mcnitt
scott mcnitt
Posted Monday, September 14, 2009 6:50 AM
SSC Rookie
Group: General Forum Members
Last Login: 2 days ago @ 2:25 PM
Points: 29,
Visits: 272
I am not an official DBA but a database developer that wears the DBA hat a lot in what I do. In my production support role, I needed help in being more proactive in monitoring and addressing issues in our database applications. I also wanted some of the expertise that can sometimes come “built-in” to these monitoring tools. So I pushed to buy a tool.
Regardless of if the tool is one that I purchase or build myself, don’t I still have some work to do and decisions to make in how to use the tool or what the data actually means? It would be great to have guidance and recommended best practices, without necessarily having to deal with how I am getting the data.
Perhaps even something as simple as the pro / con of deploying the tool on the same server that it is monitoring.
Post #787404
Jack Corbett
Jack Corbett
Posted Monday, September 14, 2009 6:50 AM
SSChampion
Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571,
Visits: 11,871
We had short debate about this in planning for SQLSaturday #21 - Orlando. One of the sponsors wanted to have some time to do a demo of one of their products, beyond a table at the event. IMO, there is nothing wrong with an event providing that time, provided it is made clear that this is a vendor sponsored session and will be a bit a of a sales pitch.
I know I would appreciate articles/sessions on a specific product. Comparisons articles are great, but you can't really be an expert on each of the products, so I'd just assume learn about why you chose the one you are using, how you are using it, and what are your favorite and least favorite features.
I'd personally accept a session to an event that was something like, How [Insert Product Here] helped me do X, provided it was submitted by someone not employed by the vendor.
Jack Corbett
Applications Developer
Don't let the good be the enemy of the best. --
Paul Fleming
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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #787405
Grant Fritchey
Grant Fritchey
Posted Monday, September 14, 2009 7:05 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 13,383,
Visits: 25,187
Jack Corbett (9/14/2009)
We had short debate about this in planning for SQLSaturday #21 - Orlando. One of the sponsors wanted to have some time to do a demo of one of their products, beyond a table at the event. IMO, there is nothing wrong with an event providing that time, provided it is made clear that this is a vendor sponsored session and will be a bit a of a sales pitch.
I know I would appreciate articles/sessions on a specific product. Comparisons articles are great, but you can't really be an expert on each of the products, so I'd just assume learn about why you chose the one you are using, how you are using it, and what are your favorite and least favorite features.
I'd personally accept a session to an event that was something like, How [Insert Product Here] helped me do X, provided it was submitted by someone not employed by the vendor.
You would, and I would, but the big conferences and most of the smaller conferences, won't. And I think that's a pity. I can go to a session on how Tom LaRock uses Microsoft Operations Manager within his enterprise. But I can't go to one where MVP X uses Product Y within his enterprise, as a part of the show. It's only going to be at the booth or in a side program at lunch or something. I just don't like it.
On the other hand, I don't want the conferences to turn into an extended sales pitch in every single session, and they could.
----------------------------------------------------
"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 #787415
« Prev Topic
|
Next Topic »
39 posts, Page 1 of 4
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.