Name: Troubleshooting Common Issues with Synapse Dedicated SQL Pools
Start: 2023-11-03T15:00:00Z
End: 2023-11-03T15:01:02.000Z
Location: BrightTALK
Rating: 0

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.

In an evolving, complex, distributed, and dynamic IT environment, security observation is necessary to make everything in IT more secure. Currently, IT teams focus on continuous monitoring as it is the most effective way to manage an environment proactively. However, SecObs helps organizations better understand their environments' complexities and security threats while providing real-time visibility to help prevent, detect, and remediate security issues.  

This webcast will discuss the importance of Security Observability and how customers can identify risks, vulnerabilities, and compliance status on a dedicated security dashboard. Learn more about: 

• Free Vulnerability Dashboard Integration in Hybrid Cloud Observability Advanced 
• Upgrades in Security Access Rights Manager and Patch Manager 

From managing access rights across the infrastructure to actively monitoring for suspicious activity and responding to real-time threats to compliance reporting, these solutions can help security teams increase productivity while keeping security costs in check.

Step Up Threat Detection with Security Observability

We have entered the age of artificial intelligence.  

AI and machine learning promises to transform numerous domains in the coming years. And while there are plenty of reasons to be excited, no shift this significant comes without potential pitfalls.  

Understanding these challenges begins with an open dialogue. This SolarWinds Day, we’re scouting ahead to map the future of AI in IT. In fireside chats with industry leaders, we’ll explore strategies for optimizing how your enterprise uses AI and identify the risks of this new technology—before they impact your organization.  

We’ll tackle questions like… 

• What are the critical factors to consider when selecting AI technologies for IT implementation? Are you confident that AIOps is supporting your organization's needs? 
• What cybersecurity risks are associated with AI, including vulnerabilities to hacking, data breaches, or adversarial attacks? 
• How can organizations navigate regulatory considerations when implementing AI technologies? 
• What ethical dilemmas might arise from using AI in IT, such as algorithmic bias, privacy concerns, or job displacement, and how can organizations address these challenges proactively? 
• What key skills will IT professionals need to develop as AI becomes more prevalent in the industry? 

We hope you can join us for this timely conversation, aimed at equipping you with the tools and resources you need to navigate the intricacies of the AI revolution.

SolarWinds Day AI: Friend or Foe?

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.

Join SolarWinds as we discuss how SolarWinds Observability provides single-pane of glass monitoring of your infrastructure and applications to provide you with visibility across complex Kubernetes workloads deployed across a multi-layered stack of AWS or Azure cloud services. We will demonstrate how SolarWinds Observability can:

• Detect a failing Kubernetes pod using pod health and performance metrics 
• Detect resource allocation issues such as CPU and memory utilization using threshold alerting
• Connect user-facing availability and latency issues to node and cluster-level health metrics 
• Monitor Kubernetes cluster, node, and pod-level performance metrics over time to optimize performance.

Operationalize Kubernetes Performance Monitoring with SolarWinds Observability

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

You can’t manage what you can’t monitor and observe.

IT ecosystem complexity is a part of operating in a hybrid multi-cloud, containerized microservices, digital transformation world, and the complexity is not magically going away.

Join us for our next SolarWinds Day virtual event on March 27, where you’ll experience how SolarWinds is solving what others can’t – abstracting the complexity, increasing visibility, and automating remediation across on-premises, hybrid, and cloud-native estates. 

During the event, you will:    
• Learn how SolarWinds can equip you to monitor and observe your way -- whether inside the firewall, natively in the cloud, or a combination of both. 
• See demonstrations covering the latest innovations in our self-hosted and cloud-native monitoring and observability solutions.
• Gain insights to help you and your teams move from reactive to proactive with AIOps.

Register today.

SolarWinds Day: Observe, Automate, and Optimize

SolarWinds Day APJ: Observe, Automate, and Optimize

2023 saw hiring slowdowns and budget cuts with higher demands on IT teams, leading to teams feeling understaffed, underequipped, overcapacity, overwhelmed, and falling behind. 

Sound familiar?

If this past year was a struggle, we want to show you that 2024 doesn’t have to be. SolarWinds customers found repeated success and we want to show you how. We’ll talk about what got these companies through and how they’re preparing for the year ahead, as well as how SolarWinds Service Desk aided in their adjustments.

Join us in this webcast, to hear from one of our Solutions Architects and expert in this field, David Russel, as we dive into how SolarWinds customers still find success despite strong headwinds. David will be joined by RJ Gazarek, Principal Product Marketing Manager for ITSM.

We’ll talk about:

* What success looked like for customers in 2023
* How they’re set up even better in 2024
* The power of Automations, Workflows, and Runbooks

Too Many IT Requests? Automate Your Way to Success

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

46% of organizations will increase their spending on application modernization, according to the 2023 Gartner CIO and Technology Executive Survey results. Leveraging Gartner’s Evaluation Framework, we will discuss how to choose the right approach for each application – rehost, replatform, rearchitect, rebuild, and replace. Choosing the right approach is essential. The downside of choosing the wrong approach can result in the following:

* Unforeseen costs
* Poor/slow application delivery
* Minimal business benefits
* Unmaintainable code
* Potentially killing modern application initiatives

Software engineering leaders must establish a clear understanding of each approach. Join us as we dive into recommendations from Gartner's report: How to Choose the Right Approach for Application Modernization and Cloud Migration.

In this webcast, you will learn:

* How to identify issues using the six (6) drivers for modernization.
* Differences in scope, effect, risk, cost, and impact of the five (5) approaches.
* How to choose the right approach for each of your applications.

5 Approaches for Successful Application Modernization and Cloud 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

Given the ongoing challenge of identifying application and database performance issues, IT teams require a unified solution for increased visibility, intelligence, and productivity.

In this session, we'll take you through a real-world use case: a critical customer onboarding application experiences downtime, leading to customer registration issues, potential churn, revenue loss, and harm to the business's reputation.

Discover how Hybrid Cloud Observability and Database Performance Analyzer work together to resolve these challenges by:
• Identifying performance issues and configuration conflicts
• Providing detailed database insights with anomaly detection and using tuning advisors to take corrective actions

Using Observability for Performance Monitoring (Episode 2)

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

Your IT service management (ITSM) teams leverage a set of practices, policies, and processes to design, deliver, manage, and improve the IT services they provide to other employees. 

Now it’s time to take what you do well and go beyond IT.

In this hands-on webcast, we’ll cover the benefits of bringing multiple departments to an ITSM platform with Enterprise Service Management (ESM) capabilities and provide real-world examples of how ESM gives your departments the power of: 
• Accelerated service delivery: Streamlined service delivery times, leading to quicker resolutions and improved user satisfaction. 
• Data privacy: Protection of sensitive information, handled with the same level of security and compliance throughout the organization. 
• Structured service delivery: A way to provide consistent processes across all departments, reducing operational chaos and ensuring standardized service delivery. 
• Service accessibility: Enable employees to request services from multiple domains through a single, user-friendly interface accessible by a centralized company-wide service portal. 
• Visibility of service quality: Provide real-time insights into service quality and enable proactive improvements.

Build Efficient Service Processes Across the Enterprise

This webcast dives into the evolving complexities of networks, applications, and databases and how organizations can increase visibility, intelligence, and productivity through a unified platform.

Learn how SolarWinds Hybrid Cloud Observability integrates with Database Performance Analyzer to enhance database performance by
• monitoring and optimizing applications, servers, and databases
• tracking configurations
• offering performance monitoring for virtual machines and hypervisors.

Simplification is the key benefit here as Hybrid Cloud Observability will help IT teams eliminate tool sprawl, accelerate issue resolutions, control costs, and reduce business risks.

Using Observability for Performance Monitoring (Episode 1)

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

SolarWinds Day: ITSM & Database Monitoring For All

How to: Improve DevOps with Database Integrated Monitoring

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

Getting Peak Performance for SQL Server Analysis Services (SSAS)

Episode 6: Simplify Database Performance Management with SolarWinds

Episode 5: Optimize Database Performance Management with SolarWinds

Database Webcast Series

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

Database Management

SSaS

SQL Sentry

Data Best Practices

Data Analysis

Cloud Data

MySQL

Data Migration

Azure

Synapse Dedicated SQL Pools

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.

Troubleshooting Common Issues with Synapse Dedicated SQL Pools

Presented by

About this talk

More from this channel