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 this webcast we discuss the outlook for artificial intelligence in SolarWinds and in the IT sector in the Asia-Pacific & Japan (APJ) region.

This webcast is based on the SolarWinds 2024 IT Trends Report called “AI - Friend or Foe?”, for which we surveyed nearly 700 IT experts globally—including in APJ.

There is significant support for government regulation of AI. Despite concerns regarding privacy, job displacement, and data security, the overall sentiment towards AI among IT leaders and professionals is optimistic.  

The consensus is that AI will play a pivotal role in IT operations, with a strong desire for faster implementation of AI technologies, particularly AIOps, within organizations.

Don’t miss this opportunity to learn more about our findings on AI within the IT industry.

IT Trends Report: AI – Friends or Foe?

SolarWinds is expanding its cloud-monitoring capabilities across our self-hosted and SaaS observability offerings.
In this video, we'll explore new and expanded capabilities for our observability solutions and learn how this increased functionality enables IT teams or organizations to decide for themselves how they monitor and manage their hybrid IT.

We'll cover... What’s new with our comprehensive observability offerings
How to achieve comprehensive, full-stack hybrid IT visibility
How AI-assisted ITSM capabilities can help you generate faster issue resolution
How SolarWinds customer and THWACK MVP, Jake Muszynski with Nationwide Children’s Hospital, is addressing complexities within a hybrid IT environment. We're also excited to welcome Doug Bennett, Sr. Partner Development Manager at AWS, to share his insight on how AI can add value with observability.

Join us for this timely conversation and see how our solutions give you the utmost flexibility no matter where you are in your IT journey!

SolarWinds Day: Observability Anywhere. Precision Everywhere.

Organizations grapple with the complexities of overseeing IT health, performance, and security in today's Hybrid, dynamic digital environment, and choosing the right Observability solution can be key to success.  

The decision between embracing a cloud-based SaaS solution or opting for the familiarity of a self-hosted setup becomes pivotal. Our webcast, Observability Dilemma: To SaaS or Not to SaaS, That is the Question!  sets out some thought-provoking insights to help you make informed decisions for your business, help you succeed now, and plan for future success. A few of the areas we will cover: 

Organizations grapple with the complexities of overseeing IT health, performance, and security in today's Hybrid, dynamic digital environment, and choosing the right Observability solution can be key to success.  

The decision between embracing a cloud-based SaaS solution or opting for the familiarity of a self-hosted setup becomes pivotal. Our webcast, Observability Dilemma: To SaaS or Not to SaaS, That is the Question! sets out some thought-provoking insights to help you make informed decisions for your business, help you succeed now, and plan for future success. 

A few of the areas we will cover: 

• Understanding Observability and how it goes beyond mere monitoring to provide insights that surpass ordinary oversight. 
• A closer look at the advantages and limitations of SaaS and self-hosting solutions, understanding how each aligns with the critical role of Observability. 
• Points to consider when deciding on and planning for the right path for your IT journey. 
• Gain insights into phased cloud migration approaches, minimizing risks and ensuring a seamless transition without compromising Observability.

The Observability Dilemma: To SaaS or Not to SaaS, That is the Question!

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

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)

Automate Database Deployments with Azure Pipelines

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