The SQL Server 2014 feature that promises the greatest impact on performance—and not always for the best—isn’t Hekaton or SSD caching or Azure integration. For many, the new SQL Server 2014 Cardinality Estimator (CE) will prove more helpful than all these other features. For others, the new CE may actually hurt performance. To ensure that applications run at peak performance after upgrading to SQL Server 2014, you must understand: 1) How, why, and when SQL Server uses statistics, 2) When and where the new CE will be useful (or harmful) and 3) How to quickly verify the differences between the legacy CE and the new CE for any query. Attend this session with Thomas LaRock, Microsoft MVP and SolarWinds Head Geek, to learn how to prepare for the changes with SQL Server 2014 Cardinality Estimator and ensure your upgrade delivers the most benefit. See Questions and Answers from the August 27 live event.
As a Cloud provider, you may have just three seconds to keep a transaction--and a customer. And at least 70% of slow application performance issues is caused by the database tier. Simply throwing more hardware at the problem is expensive and doesn’t guarantee faster performance. Instead, Cloud business success demands clear understanding of the root cause of slow application performance and the role that the database plays in it. Armed with the right information, you can act quickly to address the issues that have the greatest impact on end-user experience. Join industry analyst Jeff Kaplan of the Cloud Computing Showplace and THINKStrategies for this live presentation. You’ll learn best practices for effectively scaling your SaaS IT infrastructure by optimizing applications for top performance.
Running apps on Microsoft Azure Virtual Machines is tempting; promising faster deployments and lower overall TCO. But how easy is it really to configure and run SQL Server in an Azure VM environment? This webinar will examine the critical facets beyond the mere provision of the SQL VM, and look at the characteristics and considerations for tuning, optimizing, and the key indicators for monitoring performance. We’ll look at special considerations for High-Availability and Disaster Recovery, and pay some special attention to scalability. Please join Scott Klein, Microsoft Data Platform Technical Evangelist, author and speaker, and Thomas LaRock, Sr. DBA, performance expert, and Head Geek at SolarWinds, for this live webcast. You will learn about best practices for SQL Server on Azure VM, including placement of data files, disk warmups, backups and more. See Questions and Answers from the July 23rd live event
According to a recent CIO Magazine survey, as much as 85% of the major IT projects that run over schedule are caused by delays in moving data between the development, test and production environments. How can a DBA speed application development by identifying and removing the bottlenecks in the data movement process? Please join Kyle Hailey, Performance Architect at Delphix and principal designer for the Oracle Enterprise Manager performance pages to learn how to identify these bottlenecks and assess their impact, how to use techniques like cloning to rapidly build and manage development and QA environments, and how to use metrics to track and validate the solutions.
When database performance slows, and the end users are rioting, the finger of blame often points at the storage infrastructure – which sparks an argument between the storage administrators and the DBA. The problem escalates because storage admins and DBAs speak different languages and use different monitoring tools. They lack visibility into each other’s worlds. It’s difficult to get to the root cause of the problem without a holistic view into the database and the storage infrastructure, so typically the solution is to over-provision hardware and resources. This masks the real problem and wastes IT dollars. Sound familiar? Please join George Crump, founder of Storage Switzerland and leading storage analyst, and Thomas LaRock, Sr. DBA, performance expert, and Head Geek at SolarWinds to learn how to assess the role storage plays in database response time, how to determine exactly where your IO contention is, and what types of hardware upgrades might be appropriate to address your issues. Most importantly, you will learn how to storage admins and DBAs can work together to fix problems and not just throw hardware at them. See Questions and Answers from the June 4th live event
Disk I/O can be a significant performance bottleneck for SQL Server. And when disk I/O is the suspected culprit, the first thought is to purchase more storage. But expensive hardware upgrades don’t necessarily ensure a faster database. So how do you determine how much disk I/O is contributing to poor performance? How can you assess the performance of a specific workload on different types of storage? And how do you decide which infrastructure design is best for a specific storage solution? Please join database performance experts and SolarWinds Product Managers, Brian Flynn and Kathy Gibbs, to learn the fundamentals of SQL Server storage and how it impacts SQL Server performance. See Questions and Answers from the April 23rd live event.
Increasingly, IT organizations are turning to VMware to virtualize their datacenters and the databases are the next logical step. But when you move your SQL Servers to a virtual environment, the performance metrics you typically used to troubleshoot performance issues become unreliable; such as O/S metrics, storage configurations, CPU allocation and more. SQL Server DBAs no longer have a clear, reliable view of the factors impacting database performance. Please join Janis Griffin, Senior DBA and performance expert, as she covers the fundamentals of monitoring databases in a VMware environment including the key differences between monitoring performance on a virtual machine vs. a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum SQL Server performance in a VMware environment. See Questions and Answers from the February 25 live event.
When moving databases to a virtual environment, the performance metrics DBAs typically use to troubleshoot performance issues become unreliable; such as O/S metrics, storage configurations, CPU allocation and more. DBAs no longer have a clear, reliable view of the factors impacting database performance. Please join Dean Richards, Senior DBA and performance expert, as he discusses the fundamentals of monitoring databases in a VMware environment including the key differences between monitoring performance on a virtual machine vs. a physical machine. He will cover the benefits of virtualization, explain terms and concepts, provide useful planning tips, and cover best practices for maintaining optimum Oracle database performance in a VMware environment.
CPUs are running faster now than ever before, solid-state drives are replacing spinning disks, and database servers have terabytes of RAM. And yet we still suffer from poor database performance. Why? Because a poorly written query will bring even the best hardware to its knees. For truly great performing systems there is no substitute for properly written queries and designed indexes. And for this, we rely on the skills and expertise of DBAs and database developers. Join Microsoft SQL Server Certified Masters, Tim Chapman and Thomas LaRock to learn how to spot common query performance killers and what you can do to make queries execute as fast as possible. See Questions and Answers from the January 29 live webinar.
Secret #1. Stop staring at that dashboard. You won’t find the answer there.
The cause of any performance degradation can be a combination of a dozen issues… or just one. But DBAs can’t waste time poking around trying to find a needle in a haystack. In fact, without using the proper tools 80% of the mean time to problem resolution is spent identifying the cause and only 20% is spent solving the issue. So how do the top SQL performance experts approach a problem? The key is root-cause analysis. Please join database performance expert, Jeff Garbus, as he shares dozens of real-life case studies to help illustrate his root cause analysis process and tuning techniques. See Questions and Answers from the December 11 live webinar.
Standard Edition (SE) is sometimes the neglected little brother of Enterprise Edition (EE). Sure, EE offers the maximum features and capabilities, but it also comes with a price tag. Where does it make sense to consider SE? SE still runs on the same core database. It provides High Availability (HA) solutions as well as the capacity for a robust Disaster Recovery (DR) environment. It is even possible to use Oracle RAC, and combined with a standby database, you can implement a powerful solution. Plus, there is the advantage of lower licensing cost. Whether you are a small business or enterprise, Oracle Certified Master Anton Els will help you understand the differences between the two and where it makes sense to consider using SE in your environment.
Join Confio Senior DBA, James Davis, for a 45 minute demonstration of Ignite. James presents product highlights, new features, and some SQL performance tuning best practices. Confio donated $10 to the United Ways of Colorado Flood Recovery Fund for each person that attended live or watched the recording of this special Ignite product demo by November 11, 2013. The donations support community organizations working with individuals and groups focused on long-term recovery.
Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. Join Sr. DBA and performance expert, Janis Griffin, as she takes you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Janis will use cases studies from real-life examples to demonstrate tips and tricks. See Questions and Answers from the October 30 live webinar.
NoSQL and Big Data claim that relational technology cannot handle the performance, scalability, and availability demands of a wired world. What does this mean for the Oracle DBA? Join Iggy Fernandez as he demystifies NoSQL and Big Data and surveys the new product landscape. Iggy will explain that the deficiencies of relational technology are actually a result of deliberate choices made by the relational movement in its early years. Iggy will also cover the differing approaches of internet giants Amazon and eBay, one of whom completely abandoned relational technology and one of whom continues to use it. See Questions and Answers from the October 10 Live Webinar
Data designers and DBAs need to understand the logical, physical, and technical differences in designing and managing Windows Azure SQL Databases (WASDs) and traditional, on-premise SQL Server databases. Join renowned data architect, Karen Lopez and Sr. DBA, Thomas LaRock as they review the concepts that still work in both and the features that need to be tailored to each target environment. You'll see demonstrations of the database design processes and gain best practices for model-driven development for each environment, including tool support. We will discuss tips and tricks for creating and maintaining WASD database designs. Tom and Karen finish up with 5 tips for designing and managing performance for both SQL Server and WASD. See Questions and Answers from the September 18 Live Webinar.
Query tuning often gives the biggest performance boost when trying to speed up Oracle processing time for end users. However, tuning can quickly eat up a lot of DBA and developer time without any real guarantee of improved performance. Join Sr Oracle DBA, Janis Griffin, to learn a method for determining the best approach for tuning queries. By utilizing response time analysis and SQL diagramming techniques, you will learn a quick, systematic approach that will lead you down the correct tuning path with no guessing! Whether you are a beginner or an expert, this approach will save you countless of hours of tuning while making the most impact on performance. See Questions and Answers from the August 21 Live Webinar.
Are you being inundated with messages about ‘Private Clouds’, ‘Public Clouds’, and ‘Platform as a Service’ encouraging you to virtualize today or be left behind tomorrow? Yes, there are benefits, but what are the risks? Can mission-critical Oracle databases even run on VMware? Indiana University (IU) grappled with these questions and more, ultimately arriving at a multi-year strategy which enabled IU to successfully migrate all enterprise class, mission-critical systems to VMware. Join IU’s Manager of Database Administration, Dan Young, as he explores Oracle database virtualization myths - both BUSTED and CONFIRMED - based upon IU's virtualized database experience. See Questions and Answers from the June 20 Live Webinar.
SQL Server Integration Services (SSIS) is an enterprise-class data integration tool available as part of SQL Server. SSIS makes it easy to build an extract, transform, and load (ETL) process. However, most users struggle with the performance tuning of ETL processes, in particular processes that are quite robust and complex.Join SQL Server MVP Thomas LaRock and Andy Leonard for this presentation on SSIS performance. With over three decades of performance tuning and ETL experience combined, Thomas and Andy will share their knowledge and experience. You will learn how to properly collect a baseline, where to focus your tuning efforts, and what tools will serve you best. See Questions and Answers from the June 13 Live Webinar.
All database monitoring tools are the same, right? WRONG. Picking the right database monitoring tool can increase the productivity and effectiveness of your IT organization and have a measurable economic impact on your bottom line. Join Forrester Principal Consultant, Michelle Bishop, as she presents the findings of A Forrester Total Economic™ Study commissioned by Confio Software. You'll learn how a Fortune 21 healthcare services firm used Confio Ignite to: accelerate problem resolution for resource savings, enhance collaboration across IT teams for increased productivity,reduce downtime of critical applications and avoid revenue loss, and shorten training time for new personnel.
Query performance revolves around proper indexing. Without smart indexing, the queries run slower and impact end-user experience and ultimately, your business’s bottom-line. A simple scenario: what is the cost to your business if you process only 300 orders an hour instead of 600? This in-depth session will instruct you on the best practices for indexing in SQL Server so you optimize performance and ensure productivity. Join renowned database performance expert, author, lecturer, and consultant, Jeff Garbus, as he discusses physical index structures, the differences between clustered and non-clustered indexes, and how they affect the optimizer’s index selection for performance. See Questions and Answers from the May 9 live webinar.
According to Bloor Research, a wait-based approach to measuring database performance is not only more intuitive, but is also more effective in identifying the root cause of database performance problems. Most database monitoring tools focus on server health. Server performance metrics provide a lot of information about what is happening but not about why it is happening. Please join Bloor Research Director, Philip Howard, for this recorded webinar. Mr. Howard will cover the three key elements for monitoring database performance and how a wait-based performance approach will help ensure optimum database performance. Sr. DBA and performance expert, Neil Hambly, will demonstrate how Confio Ignite, a wait-based performance monitoring tool, can be used to proactively manage database performance.
Oracle DBAs often find themselves at a disadvantage when trying to communicate the cause of performance problems to others in the IT organization such as network and I/O Administrators. Unless you have total confidence in your understanding of Oracle’s wait interface, you might find yourself losing arguments. Please join Oracle ACE and renowned performance expert, Craig Shallahamer to learn how Oracle determines wait time and how to use it in a time-based analysis. Craig will cover the various ways Oracle gathers wait time, its reliability, and some non-traditional, yet very useful, wait time applications.
Performance tuning is complex; it's hard to know which knob to turn or button to press that will give you the biggest performance boost. Join renowned performance tuning experts Thomas LaRock and Tim Chapman, as they share their 12 step method for query performance tuning. See Questions and Answers from the March 21 live webinar.
Advanced Index, Partitioning and Compression Strategies for Supercharged SQL Server PerformanceRegister Here
Good DBAs know indexing can be an effective approach to achieve higher performance levels in SQL Server, when you combine indexing with partitioning and/or compression, the performance gains are supercharged. Join SQL Server DBA and performance expert, Neil Hambly for a presentation on these advanced techniques.
A solid understanding of the operators and their order of execution makes a big difference in deciding the best execution plan – and ultimately how it affects the performance of your Oracle database. Sr. DBA and performance expert, Janis Griffin discusses the different operators found in an execution plan and how they consume resources. She also demonstrates the best methods for collecting execution plans, and provide tips on tuning the best execution plan. See Questions and Answers from the January 23 live webinar
Whether you are a developer or DBA, this presentation will outline a method for determining the best approach for tuning a query by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick and systematic approach will lead you down the correct tuning path with no guessing. No matter if you are a beginner or expert, this approach will save you countless hours of tuning a query.
See Questions and Answers from the December 13 live webinar
The waits and queues performance tuning methodology isn’t new, but the best SQL Server DBAs can quickly navigate through DMV tables to identify the waits causing the greatest performance problems, while skillfully ignoring those that don’t matter. Please join SQL Server Sr DBA and performance expert, Neil Hambly, for a detailed examination of SQL Server waits types and how they impact performance.
Are you struggling to resolve tough performance issues and your current tools just aren't providing the answers fast enough? It's time to find out what OEM is not showing you. This webinar outlines the best approach for quickly finding and resolving Oracle database problems by utilizing response time analysis.
You're moving your Oracle databases to VMware and you have QUESTIONS. Don't panic! The good news is you will achieve improved performance and high availability with Oracle on VMware, but you will need to learn some new tricks to ensure success. Please join Sr. DBA, Dean Richards, and Oracle Certified Master, Don Sullivan, to learn best practices for deployment on both standard and RAC systems, performance considerations, and dig into some of the finer implementation details.
Please join Sr. DBA Thomas LaRock (@SQLRockstar) to learn how smart, effective database design will ensure your databases perform at their peak efficiency. You will learn how to choose the best performing datatypes, how to measure their effectiveness, and how to correct bad datatypes decisions (decisions that were not, of course, made by you.)
Learn how to leverage RAC and vSphere capabilities to further enhance and stabilize the RAC failover and load balancing capabilities. Sr DBA, Kathy Gibbs, will show you how easy it is to scale a RAC environment by cloning an existing RAC VM in vSphere and quickly adding to the virtual environment. She'll also show you how to monitor RAC on VMware so you'll be confident that there are no performance problems running RAC on VM versus a physical host.
When moving databases to a virtual environment the performance metrics DBAs typically use to troubleshoot performance issues become unreliable; such as O/S metrics, storage configurations, CPU allocation and more. DBAs no longer have a clear, reliable view of the factors impacting database performance. Learn about best practices for maintaining optimum performance in VMware. See Questions and Answers from the live webinar.
Many organizations are migrating to Exadata to reduce costs, improve performance and availability, ensure disaster recovery, and more. But with any migration, there are a number of potential pitfalls and obstacles to avoid. The webinar will cover installation, resource management, administration, application design, performance, and DBA experiences. See Questions and Answers from the live webinar.
Using OEM to resolve performance issues? It’s not showing you everything. Learn new performance tuning techniques based on response time analysis. Real-life case studies are used to demonstrate the techniques.