January 2008
Intermediate to advanced
575 pages
16h 10m
English
book
Professional SQL Server® 2005 Performance Tuning
by Steven Wort, Christian Bolton, Justin Langford, Michael Cape, Joshua J. Jin, Douglas Hinson, Haidong Ji, Paul A. Mestemaker, Arindam Sen
Content preview from Professional SQL Server® 2005 Performance Tuning
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 1. Performance Tuning
SQL Server 2005 works great right out of the box. For most SQL Server users, performance is never an issue. They install SQL Server, load up their data, and the system works just great. Over the past few years, however, there has been an explosion in database size and in the hardware performance that is available to small and medium-sized businesses. This has allowed many more users to build larger and larger systems. Many of today's systems are now larger than yesterday's enterprise class systems that required mainframe class hardware. This explosion in size and performance is pushing more users against the limits of the out-of-the-box performance of SQL Server. This means that more and more SQL Server users are having to start learning about a side of SQL Server that they never needed to know about — performance tuning.
The good news is that as with the out-of-the-box experience, the SQL Server team has spent a lot of time working on making SQL Server an easy database system to performance tune. Unlike many of SQL Server's competitors, where you need many highly trained and very expensive consultants to diagnose and finetune performance problems, SQL Server has the tools and information available so that just about anyone can jump in and start tuning their databases.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.