Transcription
Data performance management—fast and simple.
PurposeSentryOne improves the quality of life for the Microsoft data professional.MissionSentryOne empowers the Microsoft data professional to achieve breakthrough performanceacross physical, virtual, and cloud environments.ValuesInnovationQualityAgilityWe create inspired, visionarysolutions and take on thechallenges that others won’t orcan’t.We embrace excellence by“getting it right” the first time.We respond and adapt quickly tothe needs of our clients.
SentryOne was founded as SQL Sentry by Greg Gonzalez, who ran ahosting company and couldn’t find the type of database monitoringsolution he needed—one with truly actionable information— so he builtit himself. The current consolidated S1 lineup empowers Microsoft datapros to optimize data systems across their Microsoft environments.Company History2008201120152018Performance Advisor(PA) releaseRelease of Plan Explorer,query analyzer with 100Kdownloads to dateSupport for Azure SQLDB/DW, APS, VMware,Hyper-VExpansion into EMEAwith opening ofDublin office200420092013SQL Sentry releasesfirst product, EventManager (EM)Release of PA and EM forSQL Server AnalysisServices (SSAS)Release of PAand EM forWindows25M investmentfrom MainsailPartners2016Rebranding toSentryOneAcquisition ofPragmatic WorksSoftware
Who We AreSentryOne helps data pros develop, test, document, and monitor SQLServer, Azure SQL Database, and the Microsoft Data Platform.
SentryOne DevOps & Data Performance tor, diagnose,optimize performancePlan ExplorerQuery analysis and tuningTask FactoryHigh-performing SSIScomponentsLegiTestPragmatic WorkbenchMonitorAutomated testingReconcile production dataBI xPressBuild BI packagesGenerate test dataDeploy BI packagesDBA xPressSchema inspectorData inspectorData space analyzerDOC xPressLineage and impactanalysisManage databasemetadata anddocumentation
Faster, more accurate data managementSentryOnePlatformSentryOneTask FactorySentryOnePragmatic WorkbenchThe SentryOne platformhelps data professionalsmonitor, diagnose, andmonitor the Microsoftdata platform.Task Factory offers essential, highperformance components andtasks for SSIS that eliminate theneed for programming.Pragmatic Workbench helpsDevOps teams easily develop,test, document and monitorthe Microsoft Data Platform.
S1 Provides End-to-End Visibility Across the Data PlatformMonitor, diagnose, andoptimize SQL Serverperformance.Find and fix SQL ServerAnalysis Services (SSAS)performance problemsMonitor resource utilization(memory, CPU, network,storage) of virtualizedenvironment.Keep Azure SQL Databasesrunning at peak efficiency withperformance metrics includingDTU usage.Accelerate Azure SQL DataWarehouse performance withvisibility into workloadimpacts.See performance informationfor Microsoft Analytics Platformsystem, including datamovement and details aboutdistributed queries.Boost Windows Serverand Hyper-V virtualizedenvironment performance.
MDO Methodology Monitor. Diagnose. Optimize.Go from reactive database firefighting mode to proactively optimizing data system performance.OOptimizeProactiveDM4Monitor2 GeneralPerformanceReactive1 VisibilityDashboardStandard reportsOutlook-styleevent calendarDiagnose3 SpecificPerformanceDashboardTop SQLDashboardVMware/Hyper-VCalendarSSASAlertsQuery analysis(Plan Explorer)Top wer BIcontent packSQL Server datamining5EnhancementsAdvisory ConditionsBaselinesEvent chainsFragmentationanalysis
SentryOne Task FactoryHigh-performance components and tasks for SSIS that eliminate the need for programmingConnectivityPull information using SSIS fromplatforms such as Hadoop, SharePoint,Salesforce, and morePerformanceTask Factory componentsare optimized to run much fasterthan the native SSIS components.ProductivityWith over 60 components, Task Factorycan increase productivity, improveperformance and increase your ROI.Data WarehouseSSIS components designed to easily loadand manage your data warehouse.
SentryOne Pragmatic WorkbenchDevelop, Test, Document, and Monitor the Microsoft Data PlatformManage database and BIdocumentation and metadataReal-time monitoring andnotifications for SSIS packagesAutomated testing for SQL Serverdatabases, SSAS, SSRS, and moreSimplify developing and monitoringSQL Server databases
SuperiorCapabilitiesExtremeScalabilityWhy merSuccess
S1 Delivers Superior CapabilitiesWhat S1 DeliversWhat This Means to YouS1 delivers the highest granularity ofperformance metrics in the industryYou can pinpoint the root cause of the mostcomplex database problemsEasy-to-use “Jump To” navigationYou can quickly switch views to see key metricsacross your database systems that help you identifyand address problemsLimitless, easy-to-configure customizationYou can tailor the S1 dashboard views, alerts, andAdvisory Conditions to fit your needsEnvironmental Health Overview providesa real-time, at-a-glance snapshot of yourentire data estateYou can dramatically cut your time spent on routinedatabase tasks by clearly seeing the problem areasyou need to address“SentryOne massivelyspeeds our ability to findand fix performanceproblems.”—Karl GrambowCoeo
S1 Delivers Extreme ScalabilityWhat We DeliverWhat This Means to YouProven ability to scale to hundredsof serversYou can be confident that our solutions can handleenterprise-level workloadsEnd-to-end visibility across yourenvironmentYou can easily identify and address performance problemsthat lie outside the SQL Server database—for example, in the virtual environmentLow overhead—minimal“observer effect”You won’t need additional resources (hardware, CPU) just torun SentryOne—our performance monitoring platform willnot cause performance problemsContinuous engagement with ourteam of data experts through JointTechnical ReviewsYou’ll have consistent, experienced guidance on optimizingyour organization’s data performance and you’ll have directfeedback from our team and influence on futureimprovements“SentryOne has horizontalscalability, demonstratedhigh availability, andagentless design.SentryOne is a great toolfor an enterprise-scaleenvironment.”—Derik HammerData Manager, Subway
S1 Has Unmatched ExpertiseOur ExpertiseWhat This Means to YouFounder Greg Gonzalez built SentryOnebased on his experience running ahosting company and the need for aneffective database monitoring solutionYou’ll know that SentryOne is built by dataexperts for data experts—with continuous productevolution guided to this day by the founder9 Microsoft Data Platform MVPs onstaff—more than any other database monitoringcompanyYou’ll have ready access to our team of Microsoftexperts, who have Microsoft market knowledgeas well as S1 expertiseS1 team members interact constantlywith data pros through data communityevents, blogs, and social mediaYou’ll know that the S1 team has a continuous feedbackloop from data pros like you—so our solutions evolve tomeet real-world challengesS1 has laser focus on the Microsoft data platformand SQL Server—thefastest-growing database platformYou’ll experience faster time to value because of ourextensive experience with Microsoft data systems,including Azure SQL Database and Azure SQL DataWarehouseGreg GonzalezFounder & CTOMicrosoft MVPThe S1 team shares data expertiseat:SentryOne Team BlogSQLPerformance.comAnd at various events listed at:SentryOne Events
S1 Has Unrivaled Customer Success FocusSQL Sentry ScorecardS1 Customer Success ProofWhat This Means to YouS1 has a high Net Promoter Score (NPS)of 66—the software industry average is 44.You’ll experience the same focus on your success thathas earned S1 respect and loyalty from our customers.SQL Sentry has an 8.8 (out of 10) ratingwith 110 reviews to date on TrustRadius,independent review site for business technology.You can verify the success of S1 implementationsthrough unbiased ratings and comments fromreal-world data professionals.S1 has 100% customer satisfaction ratingfor customer support tickets: Nearly halfof tickets are resolved in under one hour.You’ll know that the S1 will respond quickly toyour database performance problems—we won’t leaveyou s
How S1 Helps You SucceedWhat We DoWhat You GetProof of Concept (POC)evaluationsConfidence that our solutions are a perfect match for your environment and workloadsConsistent engagement with our team of S1 experts for faster time to valueDocumented recommendations for optimal S1 deployment for your organizationTraining ResourcesHundreds of self-paced learning resources from our SQL Server experts, including eBooks, web seminars, andvideos2-Minute Tuesdays video series: Quick demos of valuable S1 capabilities to get you up to speed faster1:1 training with our experts, by requestHealth Checks and JointTechnical ReviewsScheduled engagements with our experts to ensure your S1 solutions are optimized for your environmentGet expert guidance from SentryOne through our Professional Services offerings:Professional ServicesSmart Start: Fast, expert SentryOne rolloutPerformance Assessment: Expert help with specific SQL Server performance problemsCustom Consultation: Program designed to address specific data-driven initiatives, from specialized training to datamining projectsSentryOne Premiere: End-to-end engagement to solve your business-critical data performance needs
Why Switch from Idera?ProblemS1 SolutionYou’re experiencing gaps inmonitoring data.S1 minimizes gaps in monitoring data by collecting metrics based on volatility, resulting in loweroverhead and higher performance.You’re not sure which Idera productsyou actually need.S1 was built from the ground up on the Microsoft platform, so all solutions work togetherseamlessly with no redundancy.You are becoming overwhelmedwith alerts.Our revolutionary Advisory Conditions can be tailored to the environment for optimal, proactivemonitoring.You can’t get your support issuesresolved.S1 has an on-site support team staffed with SQL Server experts, 100% customer satisfaction ratingfor support calls, and resolution within one hour for 50% of our tickets.You’re finding the interface hard touse, with core options and behaviorshidden in nested sub-menus.S1 has an intuitive interface that displays a dashboard of overall environment health, withhorizontal Jump To navigation that simplifies investigating problems across systems.SentryOne Success Story: Find out why Subway switched from Idera to SentryOne
Why Switch from SolarWinds DPA?ProblemS1 SolutionYou’re discovering that DPA’s reliance on wait stats as the keyperformance metric is leading to incorrect (and maybe costly)conclusions.S1 provides the most accurate performance analysis, with an efficientinterface that allows drill-down into relevant details with just a few clicks.Your team is suffering from excessive, meaningless alerts.Our customizable alerting systems focuses on actionable information,which combats “alert fatigue.”You have no visibility into whether SSAS is causing performanceproblems.S1 was the first in the industry to offer monitoring for SSAS Tabular andMultidimensional modes.You’ve realized that DPA offers no index analysis capabilities.S1 Indexes tab displays index-related statistics and charts, from the targetlevel down to the individual index level.You can’t get your support tickets resolved.S1 has an on-site support team staffed with SQL Server experts, 100%customer satisfaction rating for support calls, and resolution within onehour for 50% of our tickets.
Why Switch from Quest?ProblemS1 SolutionYou’re having trouble getting a consistent historical view of databaseperformance.Our dashboard and navigation make it easy to pinpoint when an eventoccurred that caused a performance problem.You’re having difficulty keeping track of tasks in Spotlight.Our Outlook-style calendar shows all events across monitored servers inone view, and Jump To navigation lets you easily switch views acrosssystems and resolve problems faster.You have no way to set performance baselines.S1 has advanced capabilities for setting baselines for proactive databaseperformance monitoring.You’re having doubts about Spotlight’s ability to scale.S1 has agentless architecture, which facilitates low performanceoverhead (“observer effect”), and our solutions are proven to scale to100s of servers.
Why Switch from Redgate?ProblemS1 SolutionSQL Monitor isn’t giving you the details you need to pinpointthe problem.Deep performance analysis with an efficient interface—drill down intorelevant details in a few clicks.You have no visibility into whether SSAS is causing performanceproblems.S1 was the first in the industry to offer monitoring for SSAS Tabular andMultidimensional modes.You’re not getting the information you need abouthigh-impact queries.Our revolutionary Top SQL interfaces provides unparalleled visibility into thedatabase environment, allowing you a deeper understanding of problemqueries with just a few clicks.You need a no-fail solution for AlwaysOn monitoring.S1 supports AlwaysOn monitoring with a view of data movements andtopography.You suspect your performance problems are attributable tothe virtualized environment, but can’t verify with SQL Monitor.S1 includes host and guest monitoring for VMware and Hyper-V.You don’t have a way to manage SQL Server Jobs withSQL Monitor.S1 shows all events happening across the environment---not just SQL Serverjobs—in an Outlook-style calendar view.
Proof of ConceptThe SentryOne Proof of Concept process isa simple, proven framework for evaluatingSentryOne solutions.What You’ll Get with an S1 POC:Confidence that our solutions are a perfectmatch for your environmentand workloads.Consistent engagement with our team of S1experts for faster time to value.Documented recommendationsfor optimal S1 deployment for yourorganization.
Companies with High Demand for Database Performance ChooseSentryOneFinancialHealth & InsuranceTechnologyFood & Restaurants
Success Story: SubwayChallengeSubway (44K shops in 112 countries) experienced databaseperformance problems resulting in ordering delays for thousandsof customers using the online ordering platform.SolutionSubway switched from Idera to SentryOne solutions to monitor,diagnose, and optimize QA testing and production databases.ResultsUsing SentryOne, Subway reduced the time spent collecting dataand diagnosing each production performance problem from anhour to about five minutes, a 92% reduction.“SentryOne speeds the detection ofperformance problems by showing youthe execution plans and giving you thedetails so you can get to the root of theproblems.”—Derik Hammer, Data Manager, Subway
Success Story: Republic BankChallengeRepublic Bank needed to better manage data processing resources forits traditional banking transactions and its tax-based business, whichgenerates a four-month surge in processing demand each year.SolutionRepublic Bank implemented SQL Sentry for database monitoring and VSentry for visibility into resource utilization across the company’sVMware environment.ResultsThe Republic Bank data team used SentryOne solutions to closegaps in monitoring data and now proactively manages a dataestate of 1,500 SQL Server databases across 100 servers with afour-DBA team.“SentryOne has enabled us to prepare forseasonal spikes in processing pressure so wecan publish data faster.”—Chris Yates, Assistant Vice President,DBA Manager, Republic Bank
Success Story: Tableau SoftwareChallengeTableau Software DBA Nick Duckstein and team members wereforced to sift through thousands of emails documentingperformance problems with SQL Server data that is replicated toa series of clustered reporting servers being constantly hit withad-hoc queries.SolutionThe Tableau team used SentryOne SQL Sentry to significantlyreduce time spent triaging database alerts.ResultsSentryOne performance monitoring and intelligent alertingcapabilities gave Tableau a 90 percent reduction in time spentresponding to database alerts, without adding performanceoverhead.“We needed knowledge and experience withintelligent alerting, and we got that withSentryOne.”—Nick Duckstein, DBA, Tableau Software
SentryOne the Data CommunityLongtime PASS Global AlliancePartner and sponsor of the PASSWomen in Technology GroupMaker of the industry’s favoritequery analyzer, Plan Explorer,which has more than 100,000downloadsMore Microsoft MVPs onstaff than any other databasemonitoring companyOperator ofSQLPerformance.com,a blog offering dataperformance guidelineswritten by some of the mostesteemed voices in the datacommunity.
Thank you!Michele CrockettDirector of Product Marketing970-682-5511mcrockett@sentryone.com
monitor, diagnose, and monitor the Microsoft data platform. SentryOne Task Factory Task Factory offers essential, high-performance components and tasks for SSIS that eliminate the need for programming. SentryOne Pragmatic Workbench Pragmatic Workbench helps DevOps teams easily develop, test, document and monitor the Microsoft Data Platform.
