Cover Image

SQL server query performance tuning /

Saved in:
Bibliographic Details
Main Author: Fritchey, Grant
Format: Book
Language: English
Spanish
Published: New York : Apress, c2014.
Edition: 4a edición
Subjects:
Informática
SQL (Lenguaje de programación de computadores)
Notas Contenido:
  • SQL query performance tuning
  • Memory performance analysis
  • Disk performance analysis
  • CPU performance analysis
  • Creating a baseline
  • Query performance metrics
  • Analyzing query performance
  • Index architecture and behavior
  • Index analysis
  • Database engine tuning advisor
  • Key lookups and solutions
  • Statistics, data distribution, and cardinality
  • Index fragmentation
  • Execution plan generation
  • Execution plan cache behavior
  • Parameter sniffing
  • Query recompilation - Query design analysis
  • Reduce query resource use
  • Blocking and blocked processes
  • Causes and solutions for deadlocks
  • Row-by-row processing
  • Memory-optimized OLTP tables and procedures
  • Database performance testing
  • Database workload optimization
  • SQL serve optimization checklist.

MARC

LEADER 00000nam a2200000 a 4500
001 000071493
003 CO-BoSNA
005 20260107163446.0
008 150407t2014^^^^xxua^^^fr^^^^^001^0^eng^d
020 |a 9781430267423 
040 |a CO-BoSNA  |b spa 
041 0 |a spa 
082 0 4 |a 005.74068  |b F919s  |2 22 
100 1 |a Fritchey, Grant 
245 1 0 |a SQL server query performance tuning /  |c Grant Fritchey. 
250 |a 4a edición 
260 |a New York :  |b Apress,  |c c2014. 
300 |a xxxii, 575 páginas :  |b ilustraciones ;  |c 23 cm. 
500 |a Incluye índice alfabético 
505 0 |a SQL query performance tuning -- Memory performance analysis -- Disk performance analysis -- CPU performance analysis -- Creating a baseline -- Query performance metrics -- Analyzing query performance -- Index architecture and behavior -- Index analysis -- Database engine tuning advisor -- Key lookups and solutions -- Statistics, data distribution, and cardinality -- Index fragmentation -- Execution plan generation -- Execution plan cache behavior -- Parameter sniffing -- Query recompilation - Query design analysis -- Reduce query resource use -- Blocking and blocked processes -- Causes and solutions for deadlocks -- Row-by-row processing -- Memory-optimized OLTP tables and procedures -- Database performance testing -- Database workload optimization -- SQL serve optimization checklist. 
650 1 7 |a Informática  |2 Armarc 
653 1 0 |a SQL (Lenguaje de programación de computadores) 
952 |0 0  |1 0  |4 4  |6 005_740680000000000_F919S  |7 0  |8 GENER  |9 330962  |a 45271  |b 45271  |d 2015-04-07  |i 39165  |l 0  |o 005.74068 F919s  |p 419527000349  |r 2026-01-07 16:34:46  |t Ej. 1  |w 2026-01-07  |y BOOK  |z Cra. 9 No. 68-50, Neiva 
952 |0 0  |1 0  |4 4  |6 005_740680000000000_F919S  |7 0  |8 GENER  |9 330963  |a 45271  |b 45271  |d 2015-04-07  |i 39165  |l 0  |o 005.74068 F919s  |p 419527000350  |r 2026-01-07 16:34:46  |t Ej. 2  |w 2026-01-07  |y BOOK  |z Cra. 9 No. 68-50, Neiva 
999 |c 67485  |d 67485 
942 |6 005_740680000000000__F919S 

Similar Items