SQLSatSac PreCon with Kalen Delaney: "SQL Server Internals for Performance"

Jul 27, 2018 · Sacramento, United States of America

Note: To attend this pre-con, you must register via the Eventbrite link provided below. Early bird pricing available - see Eventbrite for detail!

SQL Server Internals for Performance - Kalen Delaney
https://www.eventbrite.com/e/sqlsat-757-precon-sql-server-internals-for-performance-with-kalen-delaney-tickets-44366875519

ABOUT THE SESSION:
We all know that the answer to almost any SQL Server tuning question is “It Depends!”

In this seminar, I’ll tell you what you need to know in order to figure out what it actually depends on! How can you answer these “It Depends” questions in your own environment? We’ll look at what kinds of tuning changes can be made to enhance your system or application performance, and what areas of SQL Server Internals you need to understand to make the best choice for you when trying to answer the following questions:

+ Should we build a clustered, nonclustered or columnstore index? We’ll compare the structure of these different kinds of indexes and looks and the best practices for using each type.

+ Is reusing cached query plans a good thing? We’ll look at the different ways SQL Server can cache and reuse plans and discuss how to tell when reuse is desirable. We’ll explore how to encourage SQL Server to recompile a plan when that that is the best option.

+ Should Read Committed Snapshot Isolation be enabled? We’ll explore what exactly happens internals when RCSI is enabled and that the uses cases are for this option. We’ll also talk about situations in which you might not want to use this.

+ How many files should tempdb be configured with? To understand why tempdb has concurrency considerations that aren’t applicable to other databases, we need to understand some of SQL Server’s internal allocation algorithms. We’ll look at how pages are allocated for temp tables and what changed in SQL Server 2016. With this information, we’ll be able to consider the best practices recommendations and determine what is best in your environment.

If time allows, their might be a few other questions we could discuss!

ABOUT KALEN DELANEY:
Kalen Delaney has been working with SQL Server for over 30 years, and provides advanced SQL Server training to clients around the world. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US and multiple TechEd events in both the US and Europe. Kalen is the author or co-author of many books on SQL Server, the most recent being SQL Server 2016 Internals: In-memory OLTP, from Red Gate.

SQL Server Internals for Performance - Kalen Delaney
https://www.eventbrite.com/e/sqlsat-757-precon-sql-server-internals-for-performance-with-kalen-delaney-tickets-44366875519

Event organizers
  • Sacramento SQL Server User Group

    The Sacramento SQL Server User Group is a local chapter of the Professional Association for SQL Server (PASS). The mission of PASS is to empower data professionals who leverage Microsoft technologies to connect, share, and learn through networking, knowledge sharing, and peer-based learning. We meet the first Wednesday of each month (6PM to 8PM) to discuss anything SQL Server.  Additionally, we host a SQLSaturday event every July. We are new to Meetup.com, but we are not a new group; we've been meeting si

    Recent Events
    More

Are you organizing SQLSatSac PreCon with Kalen Delaney: "SQL Server Internals for Performance"?

Claim the event and start manage its content.

I am the organizer
Social
Rating

based on 0 reviews