Name: Episode 5: Optimize Database Performance Management with SolarWinds
Start: 2021-04-27T08:00:00Z
End: 2021-04-27T08:00:14.000Z
Location: BrightTALK

Our Easy-to-Use Products Scale with You as You Grow to Meet the Ever-Changing Needs of IT. We Design Products To Empower Technology Professionals To Do Their Jobs More Effectively.

Join SolarWinds CISO Tim Brown and CTO Sai Krishna for the SolarWinds Day Closing Keynote, where they share how SolarWinds is evolving from Secure by Design to AI by Design—a bold next step in building trusted, intelligent, and future-ready IT operations. 

As organizations adopt AI-driven systems, embedding trust, transparency, and accountability into product development becomes essential. In this forward-looking discussion, Tim and Sai reveal how the AI by Design framework ensures responsible AI adoption while enhancing performance, reliability, and security. 

Discover how AI, automation, and observability converge to create smarter, more resilient operations. You’ll leave with a blueprint for applying these principles to build sustainable, ethical, and efficient IT systems.

SolarWinds Day Closing Keynote: AI by Design

A modern service desk goes far beyond basic ticketing, serving as the central engine for IT operations. This THWACKcamp session from SolarWinds Day reveals how to streamline and standardize ITSM workflows, transforming the service desk into a strategic asset that eliminates administrative headaches. SolarWinds Sr. PMM Lauren Okruch and THWACK MVP Jeremy Mayfield, Director of IT at National Sugar Marketing, explore how modern service desks go beyond ticketing to become the hub of IT operations.  

Session topics include: 

• Centralizing and standardizing ITSM workflows for improved efficiency 
• Efficiently routing alerts, invoices, and vendor communications through the service desk 
• Building user-friendly, auditable service catalogs to support compliance and transparency 

Go beyond just managing tickets—turn your service desk into the operational heart of your IT business.

Shift Happens: How to Make Your ITSM Incidentally Awesome

Incidents happen — chaos doesn’t have to.  

In this THWACKcamp session from SolarWinds Day, discover how combining incident and observability data can turn reactive firefighting into proactive, intelligent operations. 

Join Amiya Adwitiya, SolarWinds Sr. Director of Product Management, and Holger Mundt, THWACK® MVP and Technical Architect at Loop1, as they demonstrate how to build smarter on-call rotations, cut down alert fatigue, and accelerate response times using Squadcast best practices. We’ll discuss how to correlate incidents and observability signals to create streamlined, data-driven workflows that keep your operations calm, efficient, and aligned with your service level objectives (SLOs). 

You’ll learn how to: 

• Correlate incidents and observability metrics to build smarter operational workflows 
• Automate escalation paths for faster, more effective incident response 
• Use observability data for proactive SLO management and downtime prevention

Incident vs Observability Data: KO Your SLO

Join SolarWinds Tech Evangelist Kevin Kline and CEO and Founder, Soaring Eagle Data Solutions Jeff Garbus, as they guide you through practical approaches for identifying bottlenecks, optimizing queries, and improving overall database efficiency. 

You’ll see how to apply tools like Database Performance Analyzer® (DPA) and SQL Sentry® to pinpoint problem areas, implement fixes quickly, and streamline troubleshooting. With real-world examples, we’ll illustrate how structured strategies can reduce downtime, accelerate performance, and make database management far less stressful. This THWACKcamp session from SolarWinds Day explores actionable methods to improve reliability, speed up queries, and enhance overall database efficiency. 

This session covers: 

• Identifying slow queries and problematic code paths 
• Using DPA and SQL Sentry for faster optimization 
• Practical strategies to improve database reliability and performance

SELECT Answers FROM DBA WHERE Users = 'Frustrated';

Observability doesn’t have to be a mystery.  
Join SolarWinds Tech Evangelist Chrystal Taylor and THWACK® MVP Jez Marsh, Owner of Silver Back Systems, as they crack the code on turning noisy data into actionable insights. 

Part of the THWACKcamp lineup from SolarWinds Day, in this session you’ll learn how to analyze raw logs and metrics to uncover trends, catch issues early, and make smarter, faster decisions. Discover practical techniques for linking cloud and on-premises data, reducing false alerts, and automating repetitive tasks with tools like Custom Properties. 

You’ll also get an inside look at new SolarWinds platform upgrades—including Dark Theme and enhanced scalability—built to speed up monitoring and simplify your day-to-day operations.

Observabili-Mystery Solved: From Clues to Answers in 3, 2, 1…

Get a front-row seat to the future of IT operations — powered by AI, automation, and full-stack observability.

During the SolarWinds Day Keynote, on October 8, we unveiled our latest innovations in AI and automation for predictive insights and end-to-end visibility. Discover how these advancements empower IT teams to optimize performance, streamline ITSM, and simplify database management—all without disrupting existing systems.

Hear directly from SolarWinds leadership as they share our three-year vision, the strategic thinking behind our roadmap, and a major announcement shaping the next era of IT.

In this session, you’ll:
• Discover how SolarWinds AI predicts and prevents issues before they impact performance
• Learn how to modernize operations without overhauling your stack
• Hear from industry leaders on tackling real-world IT challenges with intelligence and agility

SolarWinds Day Keynote: The Future of IT Has Arrived

What if you could work towards giving your service teams hours back each week—without hiring more agents? In the final chapter of our Effortless ITSM series, we shift from strategy to execution, showing how you can translate ITSM best practices into real, measurable results inside SolarWinds Service Desk. 


This session goes beyond theory to give you concrete, in-product strategies that dramatically reduce time spent per ticket—without sacrificing quality or control. We'll walk through high-impact workflows, AI-powered automations, and smart configurations that cut down resolution time, eliminate repetitive tasks, and keep agents focused on what matters most. 


Join us to learn how to: 

Automate smarter – Use intelligent workflows and rules to triage and route tickets instantly. 

Eliminate redundant effort – Tap into AI, dynamic forms, and self-service to reduce back-and-forth. 

Surface what matters – Leverage asset and knowledge integration to accelerate decision-making and resolution. 

Design once, reuse often – Build modular automation and templates that scale across teams and request types. 

Track the impact – Use reporting to prove and improve your time savings and performance over time. 


Whether you're a current SolarWinds customer or just exploring new tools, this session will help you unlock the full potential of your ITSM platform—so your teams can save time, reduce stress, and deliver exceptional service with ease.

Effortless ITSM: Save HOURS Per Ticket with SolarWinds Service Desk

Modern observability teams are overwhelmed—too many alerts, not enough clarity, and growing pressure to respond faster than ever. Unified visibility is only the beginning. Once your metrics, logs, and traces are connected you face a new challenge, noise. A single database failure can trigger alerts across servers, networks, apps, and support channels, overwhelming teams and hiding the real issue. 

In this master class, you'll learn how to turn an alert storm into clear, actionable insights. You’ll learn how service mapping and systems thinking can help you understand how your systems connect, which alerts matter, and how to respond with confidence. We’ll also explore how Squadcast can support intelligent incident response so the right teams can focus on the right issues at the right time. 

You’ll walk away with:

• Practical ways to reduce alert noise by understanding service dependencies
• How to build a smarter escalation and triage plan
• Why true intelligent response requires more than just monitoring
 
If alert fatigue is slowing your team down, this master class is your roadmap to cutting through the chaos and taking back control.

Session 2: Go from "Uh-oh" to "All-Fixed" in the Age of Alert Fatigue

In the race to meet service level agreements (SLAs), every second counts. But meeting—or surpassing—your SLAs isn’t just about speed; it’s about efficiency, precision, and the right technology. In this webinar, SolarWinds will dive deeper into how you can leverage AI, automation, and modern UX to crush your SLAs and ensure exceptional service delivery every time.

In this session, we’ll cover:

• Why SLAs Matter: Understand the critical role SLAs play in maintaining high-quality IT service and the direct impact they have on your organization’s reputation and success.

• How SLAs Affect Resolution Times: Learn how SLAs influence response and resolution speeds and how optimizing them can drastically improve service efficiency and business outcomes.

• Solutions, Strategies, and Tools for Enhancing SLAs: Discover how automation, AI, knowledge management, asset management, and self-service portals can elevate your ability to meet SLAs faster and with greater accuracy.

• The Right Technology Is Key: Learn how SolarWinds’ solutions can empower your IT teams to meet SLAs effortlessly, combining the power of intelligent automation and a user-friendly experience.

This session is essential for IT leaders looking to level up their service delivery and create an efficient, responsive ITSM operation that consistently exceeds expectations.

Effortless ITSM: Crush your SLAs with AI, Automation, and UX

A problem is a problem even if you can’t see it

Does your IT team lose hours every week chasing down problems they can’t see? Are blind spots in your network, infrastructure, or cloud delaying your response times?

Introducing The Observability Masterclass—a new expert-led series designed to help IT professionals make sense of observability in today’s complex, hybrid environments.

In session one, you’ll learn: 
• What “visibility” means across network, infrastructure, and cloud environments
• Where visibility commonly breaks down—and why
• Real-world consequences of blind spots (e.g. performance hits, longer MTTR, silos) 

You’ll also see a practical demo and hear from our panel in a dynamic discussion aimed at helping you take control of your hybrid IT stack.

Hosted by SolarWinds Product Evangelist Chrystal Taylor, this series brings together SolarWinds experts and guest speakers to unpack core observability concepts, share real-world experiences, and show you how to turn insights into action across your hybrid IT environment.

The Fundamentals of Unified Visibility: Why It Matters Across Your Hybrid Stack

In this 45-minute session, Technical Evangelist, Database at SolarWinds, Kevin Kline, teaches critical techniques to transform database efficiency. Learn how to write SQL SELECT statements for maximum efficiency.

Optimizing Database Performance - Episode 2: SQL Best Practices

The Era of Operational Resilience is Here. Are You Ready?

Despite digital transformation, cost optimization, and tool consolidation, some organizations' IT systems still fall apart when something goes wrong. Why? Because hybrid IT ecosystems are evolving at an unprecedented pace. IT teams need a new approach to observability and service management.

Join us for our SolarWinds Day: The Era of Operational Resilience virtual event and be among the first to hear our exciting announcement—where we finally bring IT all together. By connecting people, processes, and technology, we enable learning and adaptation to build a more agile, future-ready IT ecosystem. 

You will... 
- Discover the latest innovations in our artificial intelligence-powered observability, database, and service management portfolios. 
- Get a first look at Squadcast, the newest addition to SolarWinds, designed to enhance operational resilience and transform incident response.  
- Engage in a round table discussion featuring Torsten Volk, principal analyst from Enterprise Strategy Group, that will explore the evolving IT landscape and the future of hybrid IT. 

Overcome complexity and take control of hybrid IT environments with a more innovative

SolarWinds Day: The Era of Operational Resilience

In this 45-minute session, Technical Evangelist, Database at SolarWinds, Kevin Kline, teaches critical techniques to transform database efficiency. Learn how strategic design drives database performance, scalability, and resilience.

What We'll Cover:
- Key Design Principles: The foundational elements for creating efficient tables and indexes.
- Transaction Workflows: Understanding how relational databases utilize memory, CPU, and I/O to handle workloads.
- Performance Pitfalls: Strategies to prevent locking, blocking, and deadlocking by making smarter design choices.

At the end of the session, Kevin will be available to answer your database design questions!

Prerequisites: Basic SQL skills

Presenter Bio: Kevin Kline is a database expert with 35 years of experience. Kevin is an 18-time Microsoft Data Platform MVP, dedicated to empowering database professionals through technology leadership and innovative solutions.
See less

Optimizing Database Performance - Episode 1: The Solid Foundations of Database Design

SolarWinds' own tech evangelist, Kevin Kline discusses how database performance is often difficult to ensure, but it's even harder when the database server is misconfigured. Unfortunately, most SQL Servers are misconfigured right out of the box. In this discussion you learn about which problematic default settings should always be set manually.

The Data Table - Misconfigured Database Servers

SolarWinds' own tech evangelist, Kevin Kline discusses how Database Administrators (DBA) are responsible for keeping database systems available, recoverable, and performing well. Database Engineers (DBE) are responsible for moving data between systems, transforming data for ingestion into other systems, and orchestrating the resulting complexities. In this session, we will explain the overlap and the differences between the two careers.

The Data Table - From DBA to DBE

SolarWinds' own tech evangelist, Kevin Kline discusses how automation is the most important skill for database professionals to scale up their work. And the most popular tool for automation of DBA work is PowerShell. In this webcast you will learn the basics of PowerShell with SQL Server & Azure SQL.

The Data Table - PowerShell Unveiling the Basics

SolarWinds' own tech evangelist, Kevin Kline, discusses a variety of techniques to save big money on your licensing costs for SQL Server on-premises and in the cloud, and much more!

The Data Table - Leap into Savings: Unleashing Database Cost Optimization

SolarWinds' own tech evangelist, Kevin Kline, discusses how any IT pro who has worked on-call shifts will tell you it is one of the least favorite parts of the job. Kevin discusses what steps we can take to reduce late-night interruptions and improve work-life balance, with a variety of solutions and partial solutions, such as smarter alerting, change control management, and anomaly detection.

The Data Table - Pull the Plug on Pager Duty Regain Your Nights and Weekends

SolarWinds' own tech evangelist, Kevin Kline discusses how Gen AI products like ChatGPT are taking the world by storm but haven’t yet become entrenched in D&A scenarios, and what we should expect from gen AI in the near future, and how can we take advantage of it.

The Data Table - Unlocking Gen AI in the Analytics for Optimal D&A Performance

SolarWinds' own tech evangelist, Kevin Kline discusses how Broadcom bought VMware in late 2023 and immediately began to slash jobs and change long-standing ways of doing business with VMware. We will dive deep into what this meant for you if you built your D&A infrastructure on VMware.

The Data Table - VMware 2024 - What Does the Future Mean for Your Databases Running on VMware?

SolarWinds' own tech evangelist, Kevin Kline discusses how more data professionals are working in cloud environments, either in a fully cloud enterprise or hybrid cloud/on-premises infrastructure. Consequently, more data professionals are included in difficult budget planning and cost optimization projects. In this session Kevin discusses what's new in IT financial operations (FinOps), along with tips and best practices for forecasting and optimizing costs.

The Data Table - FinOps for the Data Profession

SolarWinds' own tech evangelist, Kevin Kline discusses managing and monitoring multi-database platforms; research shows that around 70% of Fortune 1000 enterprises use multiple relational database platforms. In many of those enterprises, the DBAs themselves are specialists in only one of their supported DBs. Kevin explains how DBAs can better manage large numbers of databases provided by many different vendors.

The Data Table - Database Juggling Made Easy

Enterprises worldwide are adopting more selective stances toward their cloud solutions, with a greater emphasis on meeting strategic business goals and increasing flexibility, scalability, and cost-effectiveness. This shift involves more rigorous evaluations of ROI and, in situations where the ROI is inadequate, uprooting cloud-based applications, workloads, and data from the cloud back to local infrastructure – a process known as cloud repatriation.  

Cloud repatriation is driven by several factors, including security, compliance, performance, and internal policies. However, the number one reason for cloud repatriation is cost. This session will cover the five most important steps you can take to optimize your cloud spend before taking the drastic step of repatriation.  

In this session, you’ll learn how to:
• Right-size and match the instance types and sizes to your specific workloads while including spot, reserved, and standard instances in your analysis 
• Enable smart autoscaling and microservices to enable workloads to dynamically adjust consumption on demand 
• Be vigilant for unused resources since you must pay for everything running in the cloud, even if unused or unattached 
• Tune existing applications and databases for poor-quality SQL code and database designs since every cycle wasted on CPU, Storage, Memory, and I/O adds cost 
• Assess the cost-benefit choices between cloud VMs and managed services 

Join SolarWinds and the experts from Soaring Eagle to learn more about the world of cloud cost optimization from top experts in the field!

Stop Wasting Money: Five Ways to Reduce Cloud Database Spend

It’s rare to find a database completely free from the ills of poor design and/or inefficient queries. The result? Typically, higher I/O, longer user wait times, greater amounts of blocking, and increased resource consumption and contention.   
 
So, what’s the best way to tackle the issues and maximize return on time invested? Tune the SQL statements? Add another index? Add more columns to an existing index?   
 
Join database experts Kevin Kline, technical evangelist for database technology at SolarWinds, and Kellyn Gorman, director of data and AI at Silk, for a discussion about optimizing PostgreSQL database performance. Kevin and Kellyn will cover a variety of critical insights into query efficiency and table indexing on PostgreSQL, such as:  

*Assess query inefficiencies by reading execution plans.  
*Review table and index design for optimal performance.  
*Determine the priority of what options to tune first by reviewing overall workload behavior.  

 Finally, Kevin will demonstrate the newest features in Database Performance Analyzer (DPA) that make the entire performance tuning process faster and easier!

Turn the Tables on Poor Database Performance

The adoption of containerization and orchestration platforms, such as Kubernetes, has grown quickly as DevOps teams look to build scalable and resilient applications. Container environments consist of many moving parts. For example, in a busy application environment, hundreds of pods, the smallest execution unit in Kubernetes, are continuously being launched and decommissioned.

In this complex and dynamic environment, monitoring the health of your application infrastructure and troubleshooting issues can quickly become challenging. Between resource allocation issues that can cause pod eviction events, an unexpected termination scenario due to a spot instance availability, or CrashLoopBackOff errors arising from missing dependency that results in repeated failed launches; the sheer scale and complexity of a Kubernetes-back application requires more than standard monitoring and alerting to ensure optimal performance and health.

However, automation done well is more than just setting a SQL Agent task to take nightly database backups. Smart automation incorporates aspects of monitoring enabling your automations to respond dynamically and flexibly to the situation at hand.

You have a lot of choices in how you automate your workflows in SQL Server. There are tools to help you write your automation code, products to set-it-and-forget-it, and everything in between. Join Database Evangelist Kevin Kline to discuss where monitoring ends and automation begins.

In this session, you’ll learn:
• How database automation and better monitoring can support trouble-free operations
• Which tasks should you consider automating, on which servers, and in which order?
• The difference between PowerShell/korn/bash scripting, Microsoft CoPilot for SQL Server, Power Automate, DIY scripting, and an enterprise product
• Resources available to you to continue to learn about SQL Server automation

Join us to learn more about the world of SQL Server automation from experts in the field.

Mastering SQL Server: The Art of Smart Automation

Do you have a cost-saving strategy to replace legacy Oracle databases with open-source PostgreSQL? 

If so, you might be thinking about the following: 
• What monitoring and tuning tool options exist for PostgreSQL? 
• How do I pinpoint where (and why) PostgreSQL is performing better or worse than Oracle? 
• Do I have to leave my Oracle tooling behind after we migrate? 
• How will my Oracle tuning and troubleshooting skills transfer to PostgreSQL? 

In this webcast, PostgreSQL experts Ash Recksiedler and Robert Mandeville will answer those questions and others. 

They’ll share their knowledge of the PostgreSQL monitoring and tuning tool landscape and their advice on how to “tool up” to help ensure your Oracle-to-PostgreSQL migration goes smoothly.

Tooling Tips For A Successful Oracle to PostgreSQL Migration

Are you curious about the evolving landscape of database administration and data professionals? Have you heard of job roles like database engineer (DE), database reliability engineer (DBRE), and data steward? 

Wondering how to stay ahead in a rapidly changing industry?  

Join industry experts Bob Ward, Kevin Kline, and Blythe Morrow as they delve into the exciting prospects that lie ahead for DBAs and data pros in our field. 

Agenda: 

Introduction: The changing role of DBAs in the tech landscape. 

Exploring Tasks: Unpacking the future tasks that will define the data professional's role. 

Skill Development: Discovering the essential skills to stay ahead in an evolving environment. 

Marketplace Preparedness: Proactive steps to take now to navigate future marketplace shifts. 

Microsoft's Vision: Aligning with Microsoft's product direction to empower data pros and organizations. 

Don't miss this opportunity to gain a competitive edge in your DBA career. Be part of the discussion that shapes the future of data professionals.

Shaping Your Career: Adapting to the Future of Microsoft Data Management Roles

In today's data-driven world, achieving optimal database performance is critical. However, complex modern database systems bring challenges. Downtime, data loss, and security worries underline the need for innovative solutions. 

Introducing our latest offering, SolarWinds Database Observability. 

Built for the cloud on the SolarWinds Platform and our SolarWinds Observability Solution, Database Observability helps to ensure optimal performance by providing full visibility for all major open-source databases.

Empowering DBAs and Engineers for Optimal Performance

Join us for this live webcast in partnership with Data WIT, celebrating the women speakers in our community. The final webcast in a series of four live digital webcasts, we’ll bring you deep technical content and awareness of women’s issues in data. 

Developing databases and Azure Data Factory pipelines is just the beginning. Once the code has been committed to source control, moving code between environments can be cumbersome in a manual environment. When multiple databases are involved or database changes need to be deployed with ADF pipeline changes, tracking the proper builds of each solution is critical. Otherwise, the quality assurance team may test incompatible builds, leading to wasted time and potentially allowing unsupported changes to be deployed together. 
 
This session will introduce database developers and administrators to build and release pipelines in Azure Data Factory. Participants will gain hand-on experience, working with a demonstration database and a set of Data Factory artefacts to deploy to a target environment. Additionally, PowerShell will be used to do basic tests to ensure the database and ADF artifacts were deployed correctly. There are many nuances and advanced settings in Dev Ops, which will not be covered in this course.

Automate Database Deployments with Azure Pipelines

Are you struggling with performance issues in your Azure® Synapse Dedicated SQL Pools? Or are you looking to optimize your environment for better results? 

Register for our webcast to learn about common performance issues that can impact effective use and get insights into how to resolve them. 

Join Steve Wright, senior solutions architect, as he discusses: 

• MPP architecture and key components of Synapse Dedicated SQL Pools, laying the groundwork for troubleshooting. 
• How to identify issues and discover common performance bottlenecks that can hinder the effectiveness of your Azure Synapse Dedicated SQL Pools, and the options to resolve them. 
• Get introduced to the basics of data warehousing in Microsoft Fabric and how these concepts might translate to Microsoft's latest Analytics Platform 

We’ll also answer any questions you might have about how to get optimal performance of your Synapse SQL Pools.  

Please note if you cannot attend this webcast live, a recording will be sent directly to your inbox so you can catch up on this not to be missed session in your own time.

Troubleshooting Common Issues with Synapse Dedicated SQL Pools

Discover the Latest Enhancements in SQL Sentry

Since the acquisition of SentryOne by SolarWinds, a lot of development work has gone into SQL Sentry. With each release, we aim to continue empowering Microsoft Data Professionals to achieve breakthrough performance across physical, virtual, and cloud environments. 

In this webcast, we’ll discuss some of the newest features added to SQL Sentry over the last few releases. During the webcast, we’ll be discussing the following:

• The new Enhanced Environment Health Overview dashboard built to help surface the most important information about your database environment
• The addition of SQL Server Wait Stat as part of our Top SQL monitoring to help provide users with troubleshooting and performance tuning
• Monitoring of Azure Synapse as a target, providing detailed visibility into the queries, loads, backups, and restores of all your data
• A whole host of enhancements we’ve added to our SQL Sentry Portal web client and how it’s modernized the product

During this webcast, the product leadership team of SQL Sentry will join to discuss the product roadmap and their vision for the product.

If you are an existing user of SQL Sentry or considering it as a monitoring tool for your environment, this webcast is not to be missed.

What’s New in SQL Sentry

Now more than ever, it is important for professionals across various roles, levels, and functions to easily access and use operational tools designed to add value and accelerate the business. To achieve this, tools must be simple to use and integrate.  

Join us for our next SolarWinds Day virtual event, where we will share how we are making it easier than ever to access and use IT operational tools. We will introduce our latest innovations that expand the availability of our Service Desk and Database Management solutions beyond IT.   

During the event, you will:    
• Learn how we are expanding the availability of SolarWinds Service Desk to additional functions across the enterprise, standardizing processes and enhancing the delivery and management of their services.     
• Discover how we are making it easier than ever for database professionals to quickly detect, remediate, and prevent issues with the latest SQL Sentry® release. 
• See live demos and get your questions answered by subject matter experts.

SolarWinds Day: ITSM & Database Monitoring For All

DevOps is a widespread and popular set of practices, tools, and philosophies used to improve and accelerate the system's development life cycle. DevOps automates and integrates the processes between software development teams (“Dev”) and IT administration teams (“Ops”).  

While DevOps is popular for full-stack software development, it is also excellent for database development and can help reduce or eliminate many database performance issues before they ever deploy to production. Unfortunately, this practice isn’t widespread. But it should be! 

In this two-part webcast, you will learn how developers using Visual Studio “quality gates” can integrate with SolarWinds DPA and SQL Sentry to make that happen. Without this integration, undetected performance problems can lead to lost productivity and even lost data, as well as significant time spent by developers and database administrators (DBAs) chasing down performance problems.  

Packed with demos in Visual Studio and both DPA and SQL Sentry, you will see how to identify SQL Server performance problems in the development cycle, before the changes hit production.  

PREREQUISITES: Basic proficiency with core SQL statements, like CREATE, ALTER, DROP, GRANT, SELECT, INSERT, UPDATE, and DELETE

How to: Improve DevOps with Database Integrated Monitoring

As a DBA, it can be frustrating to get assigned a ticket suggesting something is wrong with the database, and after you spend the time you don't have, it becomes clear it wasn't the database at all. It was the underlying infrastructure, network, etc. In this video, we show how SolarWinds® Server & Application Monitor (SAM) can enable your IT team to monitor the health and availability of your Microsoft® SQL Server and other database instances. SAM in the hands of your IT support and monitoring teams provides broad visibility across the stack. It can make it easy for the team to identify the underlying cause for database availability and performance problems. SAM gives you visibility to the underlying elements with an impact on database availability and performance. It also looks up at the applications the databases are supporting, helping eliminate wasted time and resources, finger-pointing, slow time to repair, and unhappy customers.

It’s the Database. Or Is It? Put an End to Finger Pointing!

In this webcast, Steven Wright will review some of the most common SSAS performance killers as well as useful metrics to monitor in SSAS Tabular model, which is now the default installation option in SQL Server.

Getting Peak Performance for SQL Server Analysis Services (SSAS)

Join SolarWinds and their partner Clever Distribution in a discussion on Simplifying Database Performance Management with SolarWinds.

In traditional database analysis, application performance is often put off until the deployment phase, which can often be too late. Fast access to query performance on production servers incorporates application performance in the development cycles, so you can more easily optimize database performance.

SolarWinds® Database Performance Analyzer (DPA) is built to monitor development, test, and production servers with less than a 1% load. With the DPA dashboard, DBAs can more easily visualize the production database to understand how code is performing.

About the presenter: John O'Callaghan, Director, Partner Development, SolarWinds joined SolarWinds in January 2018 and is responsible for Partner development across EMEA since March 2021. Prior to that John led product marketing in the international markets.

Episode 6: Simplify Database Performance Management with SolarWinds

Database Webcast Series

Join SolarWinds and their partner Clever Distribution in a discussion on Maximizing Your Network Performance With SolarWinds - On-Demand!

About the presenter: John O'Callaghan, Director, Partner Development, SolarWinds joined SolarWinds in January 2018 and is responsible for Partner development across EMEA since March 2021. 

In traditional database analysis, application performance is often put off until the deployment phase, which can often be too late. Fast access to query performance on production servers incorporates application performance in the development cycles, so you can more easily optimize database performance.

SolarWinds® Database Performance Analyzer (DPA) is built to monitor development, test, and production servers with less than a 1% load. With the DPA dashboard, DBAs can more easily visualize the production database to understand how code is performing.

Join us for our latest on-demand webinar to find out more about DPA and how it can be used to help you gain the most out of your databases.

Episode 5: Optimize Database Performance Management with SolarWinds

Database Management

Database Performance

IT as a Service

IT Asset Management

IT Management

IT Monitoring

IT Operations

Monitoring

Performance Management

SQL server

Are you an IT service management professional interested in developing your knowledge and improving your job performance? Join the IT service management community to access the latest updates from industry experts. Learn and share insights related to IT service management (ITSM) including topics such as the service desk, service catalog, problem and incident management, ITIL v4 and more. Engage with industry experts on current best practices and participate in active discussions that address the needs and challenges of the ITSM community.

IT Service Management

Cloud computing has exploded over the past few years, delivering a previously unimagined level of workplace mobility and flexibility. The cloud computing community on BrightTALK is made up of thousands of engaged professionals learning from the latest cloud computing research and resources. Join the community to expand your cloud computing knowledge and have your questions answered in live sessions with industry experts and vendor representatives.

Cloud Computing

The IT security community on BrightTALK is composed of more than 200,000 IT security professionals trading relevant information on software assurance, network security and mobile security. Join the conversation by watching on-demand and live information security webinars and asking questions of experts and industry leaders.

IT Security

The data center management community focuses on the holistic management and optimization of the data center. From technologies such as virtualization and cloud computing to data center design, colocation, energy efficiency and monitoring, the BrightTALK data center management community provides the most up-to-date and engaging content from industry experts to better your infrastructure and operations. Engage with a community of your peers and industry experts by asking questions, rating presentations and participating in polls during webinars, all while you gain insight that will help you transform your infrastructure into a next generation data center.

Data Center Management

Enterprise applications have become a crucial piece of infrastructure for many businesses. The enterprise applications community on BrightTALK features the latest insights in enterprise application integration, enterprise application architecture and EAS software. Join the community to gain access to thousands of videos and webinars presented by recognized enterprise information systems experts and arm yourself with the knowledge you need to succeed.

Enterprise Applications

Join thousands of engaged IT professionals in the application management community on BrightTALK. Interact with your peers in relevant webinars and videos on the latest trends and best practices for application lifecycle management, application performance management and application development.

Application Management

Network infrastructure professionals understand that a reliable and secure infrastructure is crucial to enabling business execution. Join the network infrastructure community to interact with thousands of IT professionals. Browse hundreds of on-demand and live webinars and videos to learn about the latest trends in network computing, SDN, WAN optimization and more.

Network Infrastructure

Welcome to the big data and data management community on BrightTALK. Join thousands of data quality engineers, data scientists, database administrators and other professionals to find more information about the hottest topics affecting your data. Subscribe now to learn about efficiently storing, optimizing a complex infrastructure, developing governing policies, ensuring data quality and analyzing data to make better informed decisions. Join the conversation by watching live and on-demand webinars and take the opportunity to interact with top experts and thought leaders in the field.

Big Data and Data Management

Get powerful help desk and support insights from influential experts. Connect with thought leaders and colleagues to get the most up-to-date knowledge on the help desk and support strategies that effect business value and growth.

Help Desk and Support

As an IT professional, many of the problems you face are multifaceted, complex and don’t lend themselves to simple solutions. The information technology community features useful and free information technology resources. Join to browse thousands of videos and webinars on ITIL best practices, IT security strategy and more presented by leading CTOs, CIOs and other technology experts.

Episode 5: Optimize Database Performance Management with SolarWinds

Presented by

About this talk

SolarWinds