Whether you’re a sysadmin, developer, or DBA, you’re probably interested in my session at TechEd in Orlando and Amsterdam this month. Here’s the abstract:
SQL Server speed boils down to how fast we can get data in and out of storage. Sooner or later, we’re going to run out of memory to cache. In this session, we take a lesson from Microsoft’s blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries. I’ll show you how to test your own servers and compare them to servers I’ve worked with in the field.
The agenda includes:
- Define common SQL Server use patterns
- Understand the right hardware for each pattern
- Recognize the server designs from Microsoft and hardware partners that we can reuse
- Learn how to test our own hardware
Sysadmins will walk out armed with the right combination of memory and storage throughput for their database servers. DBAs will leave understanding how to test their platforms against those from other companies. Developers will know whether they’re wasting time trying to code fixes that $10k worth of hardware will completely erase.
Add this session to your TechEd North America schedule by clicking on that link and clicking Add Session on the left side.