Microsoft SQL Server Performance Tuning, Live

preview_player
Показать описание
Brent's session at Microsoft Ignite 2015 in Chicago. He covers trace flag 4199, columnstore indexes, scaling out to AG secondaries, Cardinality Estimator changes, delayed durability, in-memory OLTP, Buffer Pool Extensions, and more.
Рекомендации по теме
Комментарии
Автор

This is a super performance lecture. Good job .

taiwoajibode
Автор

Excellent stuff ... keep educating us thanks

TechandArt
Автор

You should create a few SQL 'LeetCode' problems that are solved but need tuning

scott.schmidt
Автор

Very helpful in understanding the concepts

sasigotlagunta
Автор

Hey Brent, great video, do you have any recommendations on training for developers to learn techniques like queuing inserts? Is queuing of inserts something I’d need to build on my own or does sql have this ability built in? I’ve tried googling this technique but I don’t seem to be finding anything related. Thanks!

TheFunVampire
Автор

What's wrong with AdventureWorks...Just want to understand
Why did you turn off Read_Committed_Snapshot Isolation

shatabdidey
Автор

SQL Super Please come to India....I want to meet you....

Shanmugamanickavel
Автор

Iam from India, I have frequently getting issue on cpu utilization took 100% in the production server... memory consumption is 95% which is from sqlserver.exe .... I do not know how to troubleshoot the cpu consumption in live production... could you pls explain

udhayashankar
Автор

Does it make sense to do column index on stojou tables?

juanpablogallardov
Автор

Great video Brent!
Cant seem to find resources on the provided link, is it still there? or am I too late?
P.S: Love your work and humor!

alepan
Автор

I cannot find sp_askBrent
Could you help to provide this procedure for me ! pls

radatann