We Need Diverse Ya Sale

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    The Powell's Playlist | June 29, 2015

    Roger Hobbs: IMG Soundtrack of Macau: Roger Hobbs's Playlist for Vanishing Games

    My new novel, Vanishing Games, is a heist thriller set in the gambling city of Macau, China. I lived there briefly while researching the book and... Continue »
    1. $18.17 Sale Hardcover add to wish list

      Vanishing Games

      Roger Hobbs 9780385352642


This item may be
out of stock.

Click on the button below to search for this title in other formats.

Check for Availability
Add to Wishlist

Expert SQL Server Performance Engineering

Expert SQL Server Performance Engineering Cover


Synopses & Reviews

Publisher Comments:

Expert SQL Server Performance Engineering is a practical book with collected knowledge from more than a decade of SQL Server performance engineering and benchmarking that explains how to architect, design, build, and configure SQL Server Infrastructure, starting at the core with CPU and memory and going all the way to I/O and storage. The book explains available modern hardware in a vendor independent way, shows how to monitor and compare performance, helps you to configure SQL Server options and select hardware. It shows practical examples for all kinds of workloads and server sizes. It also provides in-depth information on topics like future expandability of systems and solid state storage devices. There are many books out there that approach performance issues from the query and index optimization point of view. What if your queries are already optimized? Expert SQL Server Performance Engineering starts on the other end of the performance management spectrum and provides in depth information on how to get the most (and in some cases the last bit of) performance out of your existing or future SQL Server infrastructure. Shows how to compare, benchmark, and select server and storage hardware. Provides insight on garnering every last bit of performance from your system. Enables you to design and build the infrastructure needed to run your workload. What you?ll learn Choose appropriate hardware for the workload at hand. Reconfigure existing hardware to be more performing end efficient. Understand how SQL Server storage engine works and stores data. Implement more effective database file group and file layouts. Understand and implement service level agreements. Monitor and compare SQL Server performance. Who this book is for

Expert SQL Server Performance Engineering is for the database administrator who wants to get the most out of server and storage hardware while maintaining or even increasing availability and reliability. The book will provide information for existing infrastructure and also help the reader with planning and designing future systems. It also provides valuable information for system, server, network, and storage administrators wanting to provide better services for their database teams by learning how to optimize infrastructure for SQL Server.

Product Details

Database design
Publication Date:

Related Subjects

Computers and Internet » Computers Reference » General
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management

Expert SQL Server Performance Engineering
0 stars - 0 reviews
$ In Stock
Product details pages Apress - English 9781430241430 Reviews:
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.