RetiredDBA.com

RetiredDBA.com provides tidbits, ideas and insights to all things Microsoft SQL Server.

Home / SQL Server / DBAs are you good enough?

DBAs are you good enough?

/
/
/



Webinar review: When “Good Enough” is costing you money by Kevin Kline and Steve Wright. Kevin Kline is a Principal Program Manager at SentryOne and Steve Wright is the Director of Sales Enablement at SentryOne. Webinar link can be found at: https://www.sentryone.com/resources

The webinar premise is there are numerous tools and methods to monitor your data estate. SQL Server DBAs want to be alerted as soon as possible, troubleshoot and resolve those issues as quickly as possible, and improve long term performance.

These are some of the bullet points as discussed by Kline and Wright in the webinar.

Good enough monitoring tools problems

  • Does it cause as many problems as they help solve?
  • Does it fail to provide actionable details to pinpoint the root cause?
  • Is it difficult to maintain?
  • Does it scale to your data estate’s expected growth?
  • Does it work in all environments (on-prem, virtual, multi-cloud)?

The cost of downtime is not good enough

  • Average cost of IT downtime is $5600/min
  • Fortune 500 company average cost is $50,000/min

Good enough application performance monitors (APM)

  • According to a Gleanster Research APM survey…
  • 88% said the most common source of APM issues was the database
  • 71% said the current APM tools provide hints but rarely identify the root cause
  • 71% said that manual analysis of log data is frequently necessary

Good enough custom scripts

  • Used to augment an inadequate monitoring tool
  • Maintenance is difficult and becomes a full-time job
  • Rarely provide valuable granularity and/or significant historical detail

Wait statistics are not good enough

  • Overly simplistic focus on waits
  • A complete picture and root cause requires more information
  • Focusing on waits keeps you in reactive state

Good enough monitoring tools and custom scripts have hidden costs

  • Requires multiple servers for multiple databases to handle 100+ monitored servers
  • Agents must be installed on every monitored server
  • Dedicated full-time administrators might be needed for the monitoring tools

I give the webinar: “When Good Enough is costing you money” a thumbs up! Right?

There is a SentryOne SQL Server monitoring platform demo at the end of the webinar. It’s worth watching so you can compare to your existing monitoring tools.

This div height required for enabling the sticky sidebar

Advertisers



Programmer Solutions Inc Websites

BUSINESS
CITY JOB RESOURCES
MIDWEST JOB RESOURCES
SOUTH JOB RESOURCES
WEST JOB RESOURCES
Industrial Supply DealsChicago Job ResourceKansas Job ResourceAlabama Job ResourceAlaska Job Resource
Office Supply DealsWashington, DC Job ResourceIllinois Job ResourceArkansas Job ResourceArizona Job Resource
EDUCATION
SPECIAL JOB RESOURCES
Indiana Job ResourceDelaware Job ResourceCalifornia Job Resource
Back To School MallDiversity Job ResourceIowa Job ResourceFlorida Job ResourceColorado Job Resource
SHOPPING
First Job ResourceMichigan Job ResourceGeorgia Job ResourceHawaii Job Resource
Health Care and FitnessFreelance Job ResourceMinnesota Job ResourceKentucky Job ResourceIdaho Job Resource
Just Best GiftsIntern Job ResourceMissouri Job ResourceLouisiana Job ResourceMontana Job Resource
Just Clearance SalesSeasonal Job ResourceNebraska Job ResourceMaryland Job ResourceNevada Job Resource
Just Comparison ShoppingSenior Job ResourceNorth Dakota Job ResourceMississippi Job ResourceNew Mexico Job Resource
Just OutletsVolunteer Job ResourceOhio Job ResourceNorth Carolina Job ResourceOregon Job Resource
Luxury Matters
TARGETED JOB RESOURCES
South Dakota Job ResourceOklahoma Job ResourceUtah Job Resource
Tradin StuffBlue Collar Job ResourceWisconsin Job ResourceSouth Carolina Job ResourceWashington Job Resource
Value BuyersExecutive Job Resource
NORTHEAST JOB RESOURCES
Tennessee Job ResourceWyoming Job Resource
TECHNOLOGY
Finance Job ResourceConnecticut Job ResourceTexas Job Resource 
FrontPage HelpHealthcare Job ResourceMaine Job ResourceVirginia Job Resource 
MCDBA DirectoryIT Job ResourceMassachusetts Job ResourceWest Virginia Job Resource 
Retired DBAPink Collar Job ResourceNew Hampshire Job Resource  
SQL Server DirectorySports Job ResourceNew Jersey Job Resource  
Transact SQL DirectoryWhite Collar Job ResourceNew York Job Resource  
  Pennsylvania Job Resource  
  Rhode Island Job Resource  
  Vermont Job Resource