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/

Avsnitt(287)

Episode 55: The new and improved SQL Server Reporting Services

Episode 55: The new and improved SQL Server Reporting Services

SQL Server reporting services hasn't changed in what seems like 10 years.  The rest of the reporting environment at Microsoft has seen some MEGA changes and it seems like we could use a few updates to...

3 Aug 201641min

Episode 54: An Executive Panel Interview

Episode 54: An Executive Panel Interview

What is the leadership of your company thinking about the future of data and the role you will play?  To help give some insight into that question we have and executive pane on episode 54.  Andrew Ros...

27 Juli 201638min

Episode 53: THE Argenis Fernandez interview on storage

Episode 53: THE Argenis Fernandez interview on storage

In Episode 53 Steve Stedman and I chat with THE Argenis Fernandez, storage guru and PASS Director-at-Large about what else? Storage.  Steve and I learn something new from Argenis every time we talk to...

20 Juli 201646min

Episode 52: Statistics are coming to the DB R you ready?

Episode 52: Statistics are coming to the DB R you ready?

Since Microsoft purchases the R language they have been baking it into their products and SQL Server is on the list.  SQL Server 2016 now has support for R and I know I have had people approach me abo...

13 Juli 201631min

Episode 51: A PowerShell Story

Episode 51: A PowerShell Story

I am always amazed at how people can use technology to solve different problems and in today's episode, my friend Jana shares with us a problem he solved with PowerShell.  The setup of this is differe...

6 Juli 201626min

Episode 50: SQL Server Settings

Episode 50: SQL Server Settings

As database administrators, we want to get as much performance as we can out of our SQL Servers.  Microsoft has provided a few knobs for us to tweak in the Operating System, the local security policy,...

29 Juni 201637min

Epsidode 49: Temp Tables VS Table Variables

Epsidode 49: Temp Tables VS Table Variables

When you code and you need to use a temporary object what do you use in SQL Server--temp tables or a table variable?  There is plenty of conventional wisdom out there and my guest Wayne Sheffield and ...

22 Juni 201635min

Episode 48: Is the Data Warehouse Dead?

Episode 48: Is the Data Warehouse Dead?

Over the last few years we have seen an explosion of new technologies and processes to manage data. Episode 48 asks the question--Is the Data Warehouse dead? I chat with MVP Tim Mitchell about the s...

15 Juni 201633min

Populärt inom Utbildning

historiepodden-se
rss-bara-en-till-om-missbruk-medberoende-2
det-skaver
alska-oss
harrisons-dramatiska-historia
nu-blir-det-historia
johannes-hansen-podcast
rss-foraldramotet-bring-lagercrantz
roda-vita-rosen
rss-viktmedicinpodden
not-fanny-anymore
sektledare
rss-sjalsligt-avkladd
i-vantan-pa-katastrofen
sa-in-i-sjalen
allt-du-velat-veta
rib-podcast
rss-basta-livet
rss-max-tant-med-max-villman
rss-traningsklubben