Episode 23: IO, IO, It's Off to Tune We Go

Episode 23: IO, IO, It's Off to Tune We Go

If I were a betting man, I would wager your disk IO system is probably the biggest bottleneck in your SQL Server right now. Sure, there are lots of moving pieces, but if you can tame the IO situation, you are putting yourself in the drivers seat. So how do you go about putting together the pieces you need identify your IO constraints?

I chat with Theresa Iserman, a premier support engineer at Microsoft about some of her thoughts and why IO in general is an issue. She gives us some guidelines and even some metrics to check out. Join us in the conversation, and I'll see you on the SQL trail . . .

As always you can check out the show notes at http://sqldatapartners.com/2015/12/22/iotuning/

Jaksot(287)

Episode 127: Developing in the database

Episode 127: Developing in the database

There has been a remarkable shift introduced in the new features of SQL Server--programming languages have been embedded into the database. This has led to a few "What are you thinking" questions fro...

15 Maalis 201853min

Episode 126: SQLSaturday Edition

Episode 126: SQLSaturday Edition

Have you attended a SQLSaturday? They are great events and in this episode we chat with a few organizers about what goes into putting on an event and what they think the future of these events looks l...

8 Maalis 20181h

Episode 125: You must be an engineer

Episode 125: You must be an engineer

Have you ever found it difficult to explain how something works to a co-worker?  What about reading documentation?  We have all been there before and in this episode we chat with Ray Kim about his tho...

28 Helmi 201841min

Episode 124: Beyond the runbook; DR Organization

Episode 124: Beyond the runbook; DR Organization

Perhaps you have heard about a runbook--the documented instructions you should follow in the event of a disaster or some situation where an outage occurs.  Instructions are great for IT folks as they ...

21 Helmi 201842min

Episode 123: Top 5 things to know when getting admin access

Episode 123: Top 5 things to know when getting admin access

Listener Eduardo Cervantes wanted to get our take on what developers should do when they get admin access to a database.  We take on this challenge and I give 5 points you might consider if you are a ...

14 Helmi 201820min

Episode 122: Isolation Levels

Episode 122: Isolation Levels

Does not play well with others. Is this description appropriate for some of the queries in your database?  In this episode, we explore the role behind isolation levels--why they are important, what th...

21 Joulu 201741min

Episode 121: What makes a good manager?

Episode 121: What makes a good manager?

I have heard it said "People don't quit jobs--they quit managers".  At a recent event, I decided to ask people what they thought the qualities of a good manager are.  Perhaps you aren't thinking of ge...

14 Joulu 201731min

Episode 120: SQL Injection

Episode 120: SQL Injection

Shouldn't they have fixed that instead of putting out all these new features?  That might be what you are thought when you saw the title for today's episode.  SQL Injection is still a big deal in toda...

7 Joulu 201753min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
adhd-podi
rss-rahamania
rss-niinku-asia-on
rss-liian-kuuma-peruna
rss-valo-minussa-2
rss-tietoinen-yhteys-podcast-2
jari-sarasvuo-podcast
rss-vapaudu-voimaasi
kesken
rss-uskonto-on-tylsaa
rss-narsisti
psykologia
rss-arkea-ja-aurinkoa-podcast-espanjasta
rahapuhetta
ihminen-tavattavissa-tommy-hellsten-instituutti
rss-luonnollinen-synnytys-podcast
rss-hereilla