Nevarez High Performance SQL Server

The Go Faster Book
1. Auflage 2016
ISBN: 978-1-4842-2271-3
Verlag: APRESS
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 201 Seiten

Reihe: Professional and Applied Computing

Performance is the perennial problem that database administrators face in keeping their systems up and running at a capacity to support the mission-critical applications on which today's businesses are built. Initial system configuration is foundational to getting the desired performance out of a new system, and that foundation is precisely what this book helps database administrators get right--and get right the first time.  High Performance SQL Server is one of the few books on the market to focus on the foundation ahead of the traditional tuning and optimization efforts that happen downstream, and only after problems develop. This is a book about configuring ahead of time and delivering the right business results from the very beginning.

Zielgruppe

Professional/practitioner

Autoren/Hrsg.

Nevarez, Benjamin

Inhaltsverzeichnis

1. How SQL Server Works.- 2. Analyzing Wait Statistics.- 3. The Query Store.- 4. SQL Server Configuration.- 5. tempdb Troubleshooting and Configuration.- 6. SQL Server In-Memory Technologies.- 7. Performance Troubleshooting.- 8. Indexing.- 9. SQL Server Storage.

Über Autor(innen)

Benjamin Nevarez is an independent consultant based in Los Angeles, California. He specializes in SQL Server query tuning and optimization. Nevarez is author and coauthor of several books, including SQL Server 2014 Query Tuning & Optimization, Inside the SQL Server Query Optimizer, and SQL Server 2012 Internals. He has been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections, and SQLBits.