SQLProxy_SQLDay2015.pdf

(1057 KB) Pobierz

Media Partners

Introducing SQLProxy

Maciej Pilecki

Microsoft Certified Master

About me...

•

Microsoft Certified Master in SQL Server

•

I’ve been a SQL Server consultant for quite a while...

•

Working on large-scale SQL Server deployments worldwide

–

Large-scale is not the same as big-data

–

It’s the workload that matters most

•

I’ve seen my share of scalability problems

SQLDay 2015

THE PROBLEM WITH DATABASE SCALABILITY

Everything changes at large scale

•

As the workload increases and becomes more complex, you face more

and more contention on various resources:

–

Locks

Latches

Spinlocks

Memory

Tempdb

Even the Query Optimizer itself

SQLDay 2015