Atjaunināt sīkdatņu piekrišanu

E-grāmata: High Performance SQL Server: The Go Faster Book

3.82/5 (14 ratings by Goodreads)
  • Formāts: PDF+DRM
  • Izdošanas datums: 21-Nov-2016
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781484222713
Citas grāmatas par šo tēmu:
  • Formāts - PDF+DRM
  • Cena: 59,47 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
  • Šī e-grāmata paredzēta tikai personīgai lietošanai. E-grāmatas nav iespējams atgriezt un nauda par iegādātajām e-grāmatām netiek atmaksāta.
High Performance SQL Server: The Go Faster BookPalielināt
  • Formāts: PDF+DRM
  • Izdošanas datums: 21-Nov-2016
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781484222713
Citas grāmatas par šo tēmu:

DRM restrictions

  • Kopēšana (kopēt/ievietot):

    nav atļauts

  • Drukāšana:

    nav atļauts

  • Lietošana:

    Digitālo tiesību pārvaldība (Digital Rights Management (DRM))
    Izdevējs ir piegādājis šo grāmatu šifrētā veidā, kas nozīmē, ka jums ir jāinstalē bezmaksas programmatūra, lai to atbloķētu un lasītu. Lai lasītu šo e-grāmatu, jums ir jāizveido Adobe ID. Vairāk informācijas šeit. E-grāmatu var lasīt un lejupielādēt līdz 6 ierīcēm (vienam lietotājam ar vienu un to pašu Adobe ID).

    Nepieciešamā programmatūra
    Lai lasītu šo e-grāmatu mobilajā ierīcē (tālrunī vai planšetdatorā), jums būs jāinstalē šī bezmaksas lietotne: PocketBook Reader (iOS / Android)

    Lai lejupielādētu un lasītu šo e-grāmatu datorā vai Mac datorā, jums ir nepieciešamid Adobe Digital Editions (šī ir bezmaksas lietotne, kas īpaši izstrādāta e-grāmatām. Tā nav tas pats, kas Adobe Reader, kas, iespējams, jau ir jūsu datorā.)

    Jūs nevarat lasīt šo e-grāmatu, izmantojot Amazon Kindle.

Tagline: Bringing consistent response time to mission-critical applications

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 configuring for virtualized environments such as VMWare
  • Provides guidance toward monitoring and ongoing diagnostics
What You Will Learn
  • Understand SQL Server's database engine and how it processes queries
  • Configure instances in support of high-throughput applications
    Provide consistent response times to varying user numbers and query volumes
    • Design databases for high-throughput applications with focus on performance
  • Record performance baselines and monitor SQL Server instances against them
  • Troubleshot and fix performance problems
Who This Book Is For

High Performance SQL Server is aimed at SQL Server database administrators, developers, and data architects. The book is also of use to system administrators who are managing and are responsible for the physical servers on which SQL Server instances are run.

About the Author xv
About the Technical Reviewers xvii
Acknowledgments xix
Introduction xxi
Chapter 1 How SQL Server Works
1(20)
TDS/Network Protocols
1(2)
How Work Is Performed
3(1)
SQLOS
3(1)
Schedulers
3(2)
Workers
5(3)
Query Optimization
8(1)
Parsing and Binding
8(1)
Query Optimization
9(3)
Plan Caching
12(1)
Query Execution
13(1)
Operators
13(1)
Data Access Operators
14(1)
Aggregations
15(1)
Joins
15(1)
Parallelism
16(1)
Updates
16(1)
Memory Grants
17(1)
Locks and Latches
18(1)
Summary
19(2)
Chapter 2 Analyzing Wait Statistics
21(24)
Introduction
22(4)
Waits Information
26(1)
sys.dm_os_wait_stats
26(4)
sys.dm_exec_session_wait_stats
30(1)
Extended Events
30(2)
System_health Extended Event Session
32(2)
Example: Analyzing CXPACKET Waits
34(3)
Latches and Spinlocks
37(2)
Waits
39(1)
CX_PACKET
39(1)
PAGELATCH_ and PAGEIOI_ATCH_
39(1)
ASYNC_NETWORK_IO
39(1)
SOS_SCHEDULER_YIELD
39(1)
THREADPOOL
39(1)
PREEMPTIVE_*
40(1)
OLEDB
40(1)
KLCOMPLETION
40(1)
WRITELOG
40(1)
Timer Wait Types
40(2)
Blocking
42(1)
In-Memory OLTP
43(1)
Summary
43(2)
Chapter 3 The Query Store
45(26)
Why Is a Query Slow?
45(1)
Plan Changes
45(2)
How the Query Store Can Help
47(1)
Plan Regressions
47(1)
SQL Server Upgrades
47(1)
Application/Hardware Changes
47(1)
Identify Expensive Queries
47(1)
Identify Ad Hoc Workloads
48(1)
Architecture
48(2)
Enabling, Purging, and Disabling the Query Store
50(5)
Using the Query Store
55(4)
Performance Troubleshooting
59(2)
Incomplete Queries
61(3)
Force Failure
64(1)
Catalog Views
65(2)
Live Query Statistics
67(2)
Summary
69(2)
Chapter 4 SQL Server Configuration
71(14)
Statistics Update
71(2)
Standard Automatic Statistics Update
73(1)
Trace Flag 2371 and SQL Server 2016
73(1)
Tempdb Configuration
73(1)
Query Optimizer Hotfixes and Trace Flag 4199
74(1)
Max Degree of Parallelism
75(2)
Cost Threshold for Parallelism
77(1)
Instant File Initialization
77(1)
Cardinality Estimator
78(1)
Optimize for Ad Hoc Workloads
79(1)
SQL Server Editions
80(1)
Memory Configuration
80(1)
Lock Pages in Memory
81(1)
Backup Compression Default
82(1)
Query Governor Cost Limit
82(1)
Blocked Process Threshold
82(1)
Advanced Trace Flags
83(1)
Summary
84(1)
Chapter 5 Tempdb Troubleshooting and Configuration
85(16)
DML Contention
85(3)
Describing tempdb Latch Contention
88(1)
Fixing tempdb Latch Contention
89(1)
Using Multiple Data Files
89(1)
Trace Flags 1117 and 1118
89(1)
What Is New in SQL Server 2016
90(2)
Tempdb Events
92(5)
DDL Contention
97(1)
Tempdb Spill Warnings
97(1)
Sort Warning
97(1)
Hash Warning
98(1)
Exchange Warning
98(1)
Monitoring Disk Space
98(1)
Summary
99(2)
Chapter 6 SQL Server In-Memory Technologies
101(30)
In-Memory OLTP
102(1)
What Is New in SQL Server 2016
103(1)
Memory-Optimized Tables
103(3)
Indexes
106(2)
Natively Compiled Modules
108(2)
Changing Tables and Natively Compiled Modules
110(2)
Native Compilation
112(1)
Memory-Optimized Table Variables
113(1)
Current Limitations
114(1)
Columnstore Indexes
114(2)
Examples
116(5)
Operational Analytics
121(2)
Using Disk-Based Tables
123(3)
Using Memory-Optimized Tables
126(3)
Summary
129(2)
Chapter 7 Performance Troubleshooting
131(24)
Performance Counters
132(1)
Comparing Batches and Transactions
133(2)
Log Growths
135(2)
Data File(s) Size (KB)
137(1)
Page Reads/Sec
137(1)
Page Writes/Sec
137(1)
Page Life Expectancy
137(1)
Buffer Cache Hit Ratio
138(1)
Processor Time
138(1)
Processor Queue Length
139(1)
Latches
140(1)
Locks
140(1)
LogicalDisk and PhysicalDisk
140(1)
SQL Compilations/Sec and Re-compilations/Sec
140(1)
Memory Grants
141(1)
Processes Blocked
141(1)
Log Flush Counters
141(1)
Checkpoint Pages/Sec
141(1)
Memory Manager
142(1)
sys.dm_os_performance_counters
142(1)
Dynamic Management Views and Functions
143(1)
sys.dm_io_virtual_file_stats
143(2)
sys.dm_os_volume_stats
145(1)
sys.dm_db_index_usage_stats
145(1)
sys.dm_exec_query_stats
146(1)
sys.dm_db_index_physical_stats
146(2)
sys.dm_exec_query_optimizer_info
148(1)
sys.dm_os_sys_info
148(1)
sys.dm_os_windows_info
149(1)
SQL Trace/Extended Events
149(2)
SQL Server Data Collector
151(1)
What Is New in SQL Server 2016
152(1)
Operator Level Performance Statistics
152(1)
Trace Flags on Plans
153(1)
Summary
154(1)
Chapter 8 Indexing
155(26)
How SQL Server Uses Indexes
156(1)
Where to Use Indexes
157(2)
Index Usage Validation
159(1)
Index Maintenance
160(1)
Heaps
160(1)
Clustered Indexes
161(1)
Nonclustered Indexes
162(1)
Filtered Indexes
162(1)
Working with Indexes
163(8)
The Missing Indexes Feature
171(2)
The Database Engine Tuning Advisor
173(7)
Summary
180(1)
Chapter 9 SQL Server Storage
181(16)
Storage Types
182(1)
Flash-Based Storage
183(1)
Database Configuration
183(1)
Database Files
184(1)
Fragmentation
184(1)
VLFs
185(1)
Compression
185(1)
Metrics and Performance
186(1)
Resource Monitor
187(1)
Diskspd
188(2)
SQLIOSim
190(1)
DMVs/DMFs
191(1)
Volume Configuration
191(1)
RAID Levels
191(1)
RAID 0
192(1)
RAID 1
192(1)
RAID 5
193(1)
RAID 6
194(1)
RAID 10
194(1)
Query Processing
195(1)
Summary
196(1)
Index 197
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.
Biežāk uzdotie jautājumi par e-grāmatām Biežāk uzdotie jautājumi par e-grāmatām
Permanent link: https://www.kriso.lv/db/97814842227132e.html
Keywords: