Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Back
SQLServerCentral
Register
Home
»
SQLServerCentral.com
»
Editorials
»
Don't Build a Monitoring System
Don't Build a Monitoring System
Post reply
Like
163
Add to Briefcase
1
2
3
4
Next
Don't Build a Monitoring System
View
Options
Author
Message
Grant Fritchey
Grant Fritchey
Posted 9 years ago
#786917
SSC Guru
Group: General Forum Members
Points: 276010
Visits: 33835
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
6
Quote
SQLNightOwl
SQLNightOwl
Posted 9 years ago
#787068
Ten Centuries
Group: General Forum Members
Points: 1260
Visits: 538
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
9
Quote
Steve Jones
Steve Jones
Posted 9 years ago
#787074
SSC Guru
Group: Administrators
Points: 403518
Visits: 20462
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
10
Quote
giaks0wn
giaks0wn
Posted 9 years ago
#787283
SSC Rookie
Group: General Forum Members
Points: 29
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.
10
Quote
Dave Poole
Dave Poole
Posted 9 years ago
#787285
SSC-Forever
Group: General Forum Members
Points: 42324
Visits: 3857
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
14
Quote
Grant Fritchey
Grant Fritchey
Posted 9 years ago
#787347
SSC Guru
Group: General Forum Members
Points: 276010
Visits: 33835
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
9
Quote
Grant Fritchey
Grant Fritchey
Posted 9 years ago
#787351
SSC Guru
Group: General Forum Members
Points: 276010
Visits: 33835
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
10
Quote
scott mcnitt
scott mcnitt
Posted 9 years ago
#787404
SSChasing Mays
Group: General Forum Members
Points: 622
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.
10
Quote
Jack Corbett
Jack Corbett
Posted 9 years ago
#787405
SSC Guru
Group: General Forum Members
Points: 125712
Visits: 15067
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
Consultant
Straight Path Solutions
Dont 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
13
Quote
Grant Fritchey
Grant Fritchey
Posted 9 years ago
#787415
SSC Guru
Group: General Forum Members
Points: 276010
Visits: 33835
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
10
Quote
Go
Post reply
Like
163
Add to Briefcase
1
2
3
4
Next
Post quoted reply
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
SQL Server 2017
SQL Server 2017 - Administration
SQL Server 2017 - Development
SQL Server 2016
SQL Server 2016 - Administration
SQL Server 2016 - Development and T-SQL
SQL Server 2014
Administration - SQL Server 2014
Development - SQL Server 2014
SQL Server 2012
SQL 2012 - General
SQL Server 2012 - T-SQL
SQL Server vNext
SQL Server 15 - Administration
SQL Server 15 - Development
SQL Server 2008
SQL Server 2008 - General
T-SQL (SS2K8)
June 2007 CTP
Working with Oracle
July CTP
SQL Server Newbies
Security (SS2K8)
SQL Server 2008 High Availability
SQL Server 2008 Administration
Data Corruption (SS2K8 / SS2K8 R2)
SQL Server 2008 Performance Tuning
Cloud Computing
SQL Azure - Development
SQL Azure - Administration
Amazon AWS and other cloud vendors
General Cloud Computing Questions
CosmosDB
Azure Data Lake
Azure Machine Learning
Reporting Services
Reporting Services
Reporting Services 2005 Administration
Reporting Services 2005 Development
Reporting Services 2008/R2 Administration
Reporting Services 2008 Development
SSRS 2012
SSRS 2014
SSRS 2016
Programming
Connecting
General
SMO/RMO/DMO
XML
Service Broker
Powershell
Testing
TFS/Data Dude/DBPro
SSDT
Continuous Integration, Deployment, and Delivery
R Services and R Language
Data Warehousing
Integration Services
Strategies and Ideas
Analysis Services
Data Transformation Services (DTS)
Performance Point
Data Mining
PowerPivot
R language
Machine Learning
Database Design
Disaster Recovery
Design Ideas and Questions
Relational Theory
Hardware
Virtualization
Security and Auditing
SQLServerCentral.com
Anything that is NOT about SQL!
Contests!
Editorials
SQLServerCentral.com Announcements
SQLServerCentral.com Website Issues
Suggestions
Tag Issues with Content
Podcast Feedback
SQLServerCentral.com Test Forum
Articles Requested
SQL Server 2005
Administering
Backups
Business Intelligence
CLR Integration and Programming.
Data Corruption
Development
Working with Oracle
SQL Server 2005 Compact Edition
SQL Server 2005 General Discussion
SQL Server 2005 Security
SQL Server 2005 Strategies
SS2K5 Replication
SQL Server Express
SQL Server 2005 Performance Tuning
SQL Server 2005 Integration Services
T-SQL (SS2K5)
SQL Server Newbies
SQL Server 7,2000
Administration
Backups
Data Corruption
General
Globalization
In The Enterprise
Working with Oracle
Security
Strategies
SQL Server Newbies
Service Packs
SQL Server CE
Performance Tuning
Replication
Sarbanes-Oxley
T-SQL
SQL Server Agent
SQL Server and other platforms
MySQL
Oracle
PostgreSQL
DB2
SQL Server and Sharepoint
Older Versions of SQL (v6.5, v6.0, v4.2)
Older Versions of SQL (v6.5, v6.0, v4.2)
Career
Certification
Employers and Employees
Events
Job Postings
Resumes and Job Hunters
Presentations and Speaking
Retired Members
Testing Center
Question of the Day (QOD)
SQL Server Security Skills
Microsoft Access
Microsoft Access
Products and Books
Third Party Products
CA
SQLCentric
Extreme Technologies.
Innovartis
Embarcadero
SQL Sentry
Golden Gate Software
Idera
Lumigent
Red Gate Software
Quest Software
ApexSQL
Sonasoft
Discussions about Books
Discuss Programming Books
Discuss XML Books
Discuss Data Warehousing Books
Discuss T-SQL Books
Discuss DTS Books
Discuss SQL Server 2000 Books
Discuss SQL Server 7.0 Books
Notification Services
Administration
Article Discussions
Future Versions
SQL 12
Narrow your search by forum
Explore
Home
Latest
Popular
Calendar
Members
Who's on
Moderators
Forums
SQL Server 2017
SQL Server 2017 - Administration
SQL Server 2017 - Development
SQL Server 2016
SQL Server 2016 - Administration
SQL Server 2016 - Development and T-SQL
SQL Server 2014
Administration - SQL Server 2014
Development - SQL Server 2014
SQL Server 2012
SQL 2012 - General
SQL Server 2012 - T-SQL
SQL Server vNext
SQL Server 15 - Administration
SQL Server 15 - Development
SQL Server 2008
SQL Server 2008 - General
T-SQL (SS2K8)
June 2007 CTP
Working with Oracle
July CTP
SQL Server Newbies
Security (SS2K8)
SQL Server 2008 High Availability
SQL Server 2008 Administration
Data Corruption (SS2K8 / SS2K8 R2)
SQL Server 2008 Performance Tuning
Cloud Computing
SQL Azure - Development
SQL Azure - Administration
Amazon AWS and other cloud vendors
General Cloud Computing Questions
CosmosDB
Azure Data Lake
Azure Machine Learning
Reporting Services
Reporting Services
Reporting Services 2005 Administration
Reporting Services 2005 Development
Reporting Services 2008/R2 Administration
Reporting Services 2008 Development
SSRS 2012
SSRS 2014
SSRS 2016
Programming
Connecting
General
SMO/RMO/DMO
XML
Service Broker
Powershell
Testing
TFS/Data Dude/DBPro
SSDT
Continuous Integration, Deployment, and Delivery
R Services and R Language
Data Warehousing
Integration Services
Strategies and Ideas
Analysis Services
Data Transformation Services (DTS)
Performance Point
Data Mining
PowerPivot
R language
Machine Learning
Database Design
Disaster Recovery
Design Ideas and Questions
Relational Theory
Hardware
Virtualization
Security and Auditing
SQLServerCentral.com
Anything that is NOT about SQL!
Contests!
Editorials
SQLServerCentral.com Announcements
SQLServerCentral.com Website Issues
Suggestions
Tag Issues with Content
Podcast Feedback
SQLServerCentral.com Test Forum
Articles Requested
SQL Server 2005
Administering
Backups
Business Intelligence
CLR Integration and Programming.
Data Corruption
Development
Working with Oracle
SQL Server 2005 Compact Edition
SQL Server 2005 General Discussion
SQL Server 2005 Security
SQL Server 2005 Strategies
SS2K5 Replication
SQL Server Express
SQL Server 2005 Performance Tuning
SQL Server 2005 Integration Services
T-SQL (SS2K5)
SQL Server Newbies
SQL Server 7,2000
Administration
Backups
Data Corruption
General
Globalization
In The Enterprise
Working with Oracle
Security
Strategies
SQL Server Newbies
Service Packs
SQL Server CE
Performance Tuning
Replication
Sarbanes-Oxley
T-SQL
SQL Server Agent
SQL Server and other platforms
MySQL
Oracle
PostgreSQL
DB2
SQL Server and Sharepoint
Older Versions of SQL (v6.5, v6.0, v4.2)
Older Versions of SQL (v6.5, v6.0, v4.2)
Career
Certification
Employers and Employees
Events
Job Postings
Resumes and Job Hunters
Presentations and Speaking
Retired Members
Testing Center
Question of the Day (QOD)
SQL Server Security Skills
Microsoft Access
Microsoft Access
Products and Books
Third Party Products
CA
SQLCentric
Extreme Technologies.
Innovartis
Embarcadero
SQL Sentry
Golden Gate Software
Idera
Lumigent
Red Gate Software
Quest Software
ApexSQL
Sonasoft
Discussions about Books
Discuss Programming Books
Discuss XML Books
Discuss Data Warehousing Books
Discuss T-SQL Books
Discuss DTS Books
Discuss SQL Server 2000 Books
Discuss SQL Server 7.0 Books
Notification Services
Administration
Article Discussions
Future Versions
SQL 12
SQLServerCentral
Register
Search
Narrow your search by forum
Unthreaded, ascending
Unthreaded, descending
Subscribe to topic
Print topic
RSS feed
Go to topics forum
Jump to page
Jump to page
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.