High Performance SQL Server The Go Faster Book / by Benjamin Nevarez.

Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given i...

Full description

Saved in:
Bibliographic Details
Main Author: Nevarez, Benjamin (Author)
Corporate Author: SpringerLink (Online service)
Format: eBook
Language:English
Published: Berkeley, CA : Apress : Imprint: Apress, 2016.
Edition:1st ed. 2016.
Series:Springer eBook Collection.
Subjects:
Online Access:Click to view e-book
Holy Cross Note:Loaded electronically.
Electronic access restricted to members of the Holy Cross Community.

MARC

LEADER 00000nam a22000005i 4500
001 b3299151
003 MWH
005 20191023202803.0
007 cr nn 008mamaa
008 161123s2016 xxu| s |||| 0|eng d
020 |a 9781484222713 
024 7 |a 10.1007/978-1-4842-2271-3  |2 doi 
035 |a (DE-He213)978-1-4842-2271-3 
050 4 |a E-Book 
072 7 |a UN  |2 bicssc 
072 7 |a COM021000  |2 bisacsh 
072 7 |a UN  |2 thema 
072 7 |a UMT  |2 thema 
100 1 |a Nevarez, Benjamin.  |e author.  |4 aut  |4 http://id.loc.gov/vocabulary/relators/aut 
245 1 0 |a High Performance SQL Server  |h [electronic resource] :  |b The Go Faster Book /  |c by Benjamin Nevarez. 
250 |a 1st ed. 2016. 
264 1 |a Berkeley, CA :  |b Apress :  |b Imprint: Apress,  |c 2016. 
300 |a XXII, 201 p. 54 illus., 42 illus. in color.  |b online resource. 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file  |b PDF  |2 rda 
490 1 |a Springer eBook Collection 
505 0 |a 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. 
520 |a Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload. You’ll learn advanced configuration options, in-memory technologies, storage and disk configuration, and more, all toward enabling your desired application performance and throughput. Configuration doesn’t stop with implementation. Workloads change over time, and other impediments can arise to thwart desired performance. High Performance SQL Server covers monitoring and troubleshooting to aid in detecting and fixing production performance problems and minimizing application outages. You'll learn a variety of tools, ranging from the traditional wait analysis methodology to the new query store, and you'll learn how improving performance is really an iterative process. High Performance SQL Server is based on SQL Server 2016, although most of its content can be applied to prior versions of the product. This book is an excellent complement to performance tuning books focusing on SQL queries, and provides the other half of what you need to know by focusing on configuring the instances on which mission-critical queries are executed. Covers SQL Server instance-configuration for optimal performance Helps in implementing SQL Server in-memory technologies Provides guidance toward monitoring and ongoing diagnostics. 
590 |a Loaded electronically. 
590 |a Electronic access restricted to members of the Holy Cross Community. 
650 0 |a Database management. 
650 0 |a Computer system failures. 
690 |a Electronic resources (E-books) 
710 2 |a SpringerLink (Online service) 
773 0 |t Springer eBooks 
830 0 |a Springer eBook Collection. 
856 4 0 |u https://holycross.idm.oclc.org/login?auth=cas&url=https://doi.org/10.1007/978-1-4842-2271-3  |3 Click to view e-book  |t 0 
907 |a .b32991514  |b 04-18-22  |c 02-26-20 
998 |a he  |b 02-26-20  |c m  |d @   |e -  |f eng  |g xxu  |h 0  |i 1 
912 |a ZDB-2-CWD 
950 |a Professional and Applied Computing (Springer-12059) 
902 |a springer purchased ebooks 
903 |a SEB-COLL 
945 |f  - -   |g 1  |h 0  |j  - -   |k  - -   |l he   |o -  |p $0.00  |q -  |r -  |s b   |t 38  |u 0  |v 0  |w 0  |x 0  |y .i22123131  |z 02-26-20 
999 f f |i 7d5f2595-4602-5da8-bc0e-d173c53a9022  |s 177a46cf-53e8-5a7a-a83f-2283c1a9dbed  |t 0 
952 f f |p Online  |a College of the Holy Cross  |b Main Campus  |c E-Resources  |d Online  |t 0  |e E-Book  |h Library of Congress classification  |i Elec File