Leveraging Memory With The Database Engine

Chris Adkin “In memory” is a hot topic in the database world at present, but how do modern servers CPUs utilise memory, does the story end with main memory ?, what about NUMA and the memory hierarchy on the actual CPU. Do memory access patterns matter ? does the CPU socket certain workloads are executed[…]

Superscaling SQL Server Singleton Inserts

Chris Adkin This session covers tuning what is superficially the simple exercise of getting the maximum throughput out of a concurrent insert workload, from key construction, logging to tuning spinlocks. The session will look at two of the key spinlocks which influence of OLTP workload performance, namely XDESMGR, LOGCACHE_ACCESS and how they influence OLTP workload[…]

Top 10 Clustering Dos and Don’ts

Allan Hirt Clustering SQL Server still vexes many in one way or another. For some, it is even worse now that both AlwaysOn features – clustered instances (FCIs) and availability groups (AGs) – require an underlying Windows Server failover cluster. Storage, networking, Active Directory quorum, and more are topics that come up quite often. Learn[…]

What the Hekaton?!

Kalen Delaney SQL Server Hekaton, aka In-Memory OLTP, will completely change the way you think about data management. As a DBA, you’ll need to analyze your memory and storage needs completely differently. All Hekaton data is always stored in memory, and the data stored on disk is basically just a REDO log used to regenerate[…]

Are You Optimistic About Concurrency?

Kalen Delaney What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012’s SNAPSHOT Isolation optimistic? How can SQL Server 2014’s In-Memory OLTP provide truly optimistic concurrency? In this session, we’ll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the[…]

About

Given our vast knowledge and prior experience in organizing “SQLDay” and “DeveloperDays” conferences, including “.NET DeveloperDays”, “Mobile DeveloperDays” as well as “InfrastructureDays”, we have now created a new conference dedicated to SQL Platform. The SQL Platform conference is specifically designed for: programmers and database administrators software engineers architects and designers of database systems During the[…]

Sessions

  SPEAKER SESSION LANGUAGE Kalen Delaney Are You Optimistic About Concurrency? Kalen Delaney What the Hekaton?! Kalen Delaney Locking and Blocking Allan Hirt Top 10 Clustering Dos and Don’ts Allan Hirt What’s New for High Availability in SQL Server 2016 and Windows Server 2016 Chris Adkin Leveraging Memory With The Database Engine Chris Adkin Superscaling[…]