Toronto Roadshow


View the Agenda and Presenters

Thursday, August 16, 2018


LUNCH SESSION: 11:30 AM - 1:00 PM

Data Drives the Business: How Fast Data Optimizes Business Value



Beyond SQL Server Monitoring: Advanced Data Performance Management

You may choose to attend either session—or both.

 1087 Queen St W, Toronto, ON M6J 1H3, Canada

FREE event | Lunch provided at 11:30 am
Afternoon workshop ends with a social hour and Q & A
On-site parking available | Parking validation provided




LUNCH SESSION: 11:30 am to 1:00 pm

Data Drives the Business: How Fast Data Optimizes Business Value

Presenter: Andy Mallon

Why should companies care about faster database performance? Because every business is data-driven.

Explore how SentryOne helps companies drive business value by removing data performance barriers and accelerating delivery of business-critical information.

Targeted to CIOs, CTOs, and data managers who are exploring SentryOne capabilities for delivering rapid business value, this session will cover:

  • Why optimized database performance is critical to business success
  • How enterprise-ready database performance management solutions keep mission-critical data flowing
  • How to maximize the productivity of database teams by equipping them with proactive database monitoring solutions
  • How to realize massive ROI through solutions that are built from the ground up to work seamlessly together

Join SentryOne data experts for this information-packed session that will help you break through your Microsoft data platform barriers, whether the problems persist in your SQL Server, SQL Server Analysis Services, or VMware or Microsoft virtual environment.



AFTERNOON WORKSHOP: 1:30 pm to 4:45 pm

Beyond SQL Server Monitoring: Advanced Data Platform Performance Management

Proactive database performance management goes far beyond monitoring a few performance counters. Our experts will conduct a deep dive into how data professionals can use SentryOne to accelerate business value through rapid data delivery, free up time to focus on strategic goals, and sleep better at night knowing the company’s data is flowing at peak performance. This deep-dive workshop is targeted to DBAs, IT managers, DevOps teams, and BI pros who want to investigate the full range of SentryOne capabilities for database performance management across the Microsoft data platform.

Afternoon Workshop Sections:

1:30 pm to 2:30 pm

Advanced SQL Server Performance Optimization

Presenter: Andy Mallon

SentryOne experts provide proven guidelines for proactive database management:

  • Strategies for successfully tracking production environments with multiple SQL Servers and SQL Server Agent Jobs
  • Guidelines for understanding and managing resource utilization problems across systems that are causing slow-running processes
  • How to use SentryOne capabilities for proactive database performance management so that you can free up time for strategic initiatives, career-advancing projects—and life outside of work. We’ll cover:
    • Using Event Chains to manage the order of SQL Server Jobs execution
    • Setting alerts to avoid alert fatigue
    • Using Advisory Conditions for proactive monitoring
    • Setting and tracking performance baselines


2:30 pm to 2:50 pm

Uncovering Performance Problems Lurking in Your Virtual Environment

Presenter: John Sirmon

Sometimes your performance problems lie beyond your SQL Servers. Our data experts will help you uncover performance problems in your VMware and Windows virtual environment, whether the trouble stems from a host that doesn’t provide sufficient resources, a host server conserving memory by “ballooning,” or other problems that can be tricky to discover. 


3:15 pm to 4:15 pm

Boosting Performance of SQL Server Analysis Services

Presenter: John Sirmon

Troubleshooting performance problems with SQL Server Analysis Services (SSAS) can be a frustrating exercise. Learn time-saving tips for tracking trace events and troubleshooting SSAS bottlenecks for both MDX and Tabular modes. We’ll show you some handy tools for uncovering SSAS performance problems.


4:15 pm to 4:45 pm

Networking and Q & A Session with SentryOne Experts

Join the SentryOne team for happy hour and informal networking, with an opportunity to ask our experts your specific database performance questions.

Meet Our Presenters



Andy Mallon is a SQL Server DBA and Microsoft Data Platform MVP who has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He is the SentryOne 2016 Community Influencer of the Year, the founder of Boston SQL, past organizer of SQLSaturday Boston, and a speaker at SQL Server user groups and SQLSaturdays. Unlike most “accidental DBAs,” Andy knew early on that he loved SQL Server and wanted to become a SQL Server DBA. He shares his passion for SQL Server by blogging at and


John Sirmon is the Senior Product Manager on SentryOne's Product Team. Prior to SentryOne, John spent nearly two decades with Microsoft, most recently as Senior Program Manager with the Azure Customer Advisory Team. John is responsible for product initiatives related to Advanced Analytics, Big Data, and Business Intelligence, both on-premises and in-cloud.