SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Don't Build a Monitoring System


Don't Build a Monitoring System

Author
Message
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)

Group: General Forum Members
Points: 73101 Visits: 32913
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
SQLNightOwl
SQLNightOwl
SSC-Addicted
SSC-Addicted (482 reputation)SSC-Addicted (482 reputation)SSC-Addicted (482 reputation)SSC-Addicted (482 reputation)SSC-Addicted (482 reputation)SSC-Addicted (482 reputation)SSC-Addicted (482 reputation)SSC-Addicted (482 reputation)

Group: General Forum Members
Points: 482 Visits: 517
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
Steve Jones
Steve Jones
SSC Guru
SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)SSC Guru (107K reputation)

Group: Administrators
Points: 107704 Visits: 19342
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
My Blog: www.voiceofthedba.com
giaks0wn
giaks0wn
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 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.
Dave Poole
Dave Poole
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13019 Visits: 3383
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
www.simple-talk.com
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)

Group: General Forum Members
Points: 73101 Visits: 32913
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)

Group: General Forum Members
Points: 73101 Visits: 32913
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
scott mcnitt
scott mcnitt
SSC-Enthusiastic
SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)

Group: General Forum Members
Points: 198 Visits: 437
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.
Jack Corbett
  Jack Corbett
SSC-Dedicated
SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)

Group: General Forum Members
Points: 31302 Visits: 14918
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)SSC Guru (73K reputation)

Group: General Forum Members
Points: 73101 Visits: 32913
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search