Presented by Ben DeBow
Running Time: 178 minutes
Some say performance tuning SQL Server is an art; others say it’s a science. It’s a bit of both of those, but also more. Many factors determine how well (or poor) SQL Server will perform, and it starts well before any application database is installed into an instance. Whether you’re a DBA/IT focused person or a developer, to properly provide your end users with the performance the business requires, you must ensure that not only do you pay attention to the application and things like queries and indexes, but also things like hardware, the OS, and basic configuration. The little things matter.
Over these three sessions, SQLHA’s Ben DeBow will take you on a journey through not only SQL Server-specific factors that you must take into account, whether deploying a brand new solution or troubleshooting an existing database or query, but also how hardware, the underlying operating system, architectures, and configurations all relate to SQL Server. The goal is to give you solid fundamentals that you can use every day. If you truly want a solid performance methodology for SQL Server and not just a one-off fix, sign up today.
Session 1: Where Is My Performance Issue?
When someone comes to you and says their application or database is slow, they are assuming that SQL Server must obviously be the cause. Most DBAs even think that way. However, what seems to manifest itself as a problem in SQL Server (such as a slow query) could really be due to other external factors such as a suboptimal configuration of the underlying server either at the operating system or hardware levels. Improving performance involves much more than tuning queries and indexes – you need to know about Windows, disk, network, and other things to determine where your bottlenecks are and how to overcome them. This session will discuss some of the most common methods for troubleshooting SQL Server performance issues and provide practical advice for solving many non-SQL Server related causes of slow performance.
Session 2: Remove Your SQL Server Performance Barriers
The previous session focused on the non-SQL Server causes for performance issues, but it is still necessary to be able to diagnose and resolve issues within SQL Server. Whether you are seeing things like blocking, deadlocks, or poorly written queries or code, these can impact not only the end user experience for an application, but also things like blowing agreed upon service levels for performance, response time, and availability. This session will tell you how to approach, diagnose, and resolve some of the most common problems that afflict SQL Servers of all sizes.
Session 3: Index Tuning Foundations
Last, but certainly not least, any DBA worth his or her salt knows that one of the most important methods for achieving good performance is to have the right indexes. An index is like a map for your queries – the right one can direct the query to a specific bit of data quicker. Without it, SQL Server will search until it finds the data. Instead of leading the relational engine on an archeological dig, this session will discuss how DBAs should approach an indexing strategy. When and where do you need them? When is an index effective and when can it be removed? How will having benchmarking and baselining help paint a picture of a database or instance’s performance? These and other topics will be addressed so that you look like an index hero.
Ben DeBow is a consultant who works with customers of all sizes on their mission-critical applications and SQL Server deployments. His versatility allows him to assist with everything from virtualization and consolidation to schema design, performance tuning, disk architectures, and everything in between. He has tuned and deployed some of the largest and most complex SQL Server solutions in the world. An active member of the SQL Server community, Ben is also an MCDBA, MCSE, and MCITP. He is also the co-founder of SQLHA with Allan Hirt. You can reach Ben at http://www.sqlha.com
If you have any questions regarding this On Demand event or the registration process, please contact us directly.
Phone: 800-262-1954 or 913-967-1719