Stop throwing hardware at the problem !

I've been in more than one situation where I was asked to tune a system where they had thrown a years salary in hardware at the problem already. Only to find out that the app would run just 3% faster or even 10% slower !
I'll bring some examples and will show you what I did and why. This is not just for DBA's, DEV's should also get at least one usefull thing out of this session.
Presented by Andre Kamman at SQLBits IV
Tags (no tags)
  • Downloads
    Video available WMV Video 93 MB
  • SpeakerBIO

    I’m a SQL Server consultant based in the Netherlands. I’m a SQL Server MVP and I’m the co-founder and current chairman of the Dutch PASS Chapter and a member of the volunteer team for the Dutch SQL Saturday’s. I’ve done a whole lot of pure DBA work managing 100′s of servers and learning something new every day.

    These days I spend a lot of time on just a few servers containing some large databases and the better part of the day is spent with SSIS. In both roles I’ve been using Powershell a lot. I joke sometimes that I replaced myself with a powershell script when leaving the DBA role, but these days I automate so much that I have to watch myself and not actually do just that

    http://andrekamman.com http://andrekamman.com/feed
  • Video