Cargando…

Professional SQL server 2005 performance tuning /

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Wort, Steven (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Wiley Pub., ©2008.
Colección:Wrox professional guides.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cam a2200000 a 4500
001 OR_ocn233000178
003 OCoLC
005 20231017213018.0
006 m o d
007 cr zn|||||||||
008 080507s2008 inua ob 001 0 eng d
040 |a CtWfDGI  |b eng  |e pn  |c COCUF  |d OCLCQ  |d E7B  |d OCLCQ  |d CNCGM  |d UMI  |d CSU  |d B24X7  |d OCLCQ  |d DEBSZ  |d OCLCO  |d OCLCQ  |d DKDLA  |d OCLCQ  |d NLE  |d YDXCP  |d OCLCF  |d OCLCQ  |d COO  |d OCLCQ  |d AZK  |d CNNOR  |d MOR  |d PIFAG  |d LIV  |d OCLCQ  |d OCLCO  |d U3W  |d BUF  |d BRL  |d STF  |d WRM  |d OCLCQ  |d CEF  |d NRAMU  |d INT  |d VT2  |d AU@  |d OCLCQ  |d OCLCO  |d WYU  |d OCLCQ  |d OCLCO  |d UAB  |d A6Q  |d HS0  |d ADU  |d UKCRE  |d VLY  |d OCLCO  |d OCLCQ  |d UKAHL 
015 |a GBA781525  |2 bnb 
016 7 |a 014057083  |2 Uk 
019 |a 647809816  |a 719420362  |a 722444397  |a 740993381  |a 859879158  |a 961550158  |a 962603915  |a 974445844  |a 974519956  |a 981556703  |a 981863735  |a 988453565  |a 992087726  |a 1005947161  |a 1017997837  |a 1037477345  |a 1037903938  |a 1038625234  |a 1043491530  |a 1045495434  |a 1053607044  |a 1055404742  |a 1064917610  |a 1081237827  |a 1083603763  |a 1096477203  |a 1103273528  |a 1112866407  |a 1119030592  |a 1129365868  |a 1135963200  |a 1152992673  |a 1153522299  |a 1162051368  |a 1192352060  |a 1228551108  |a 1274132704  |a 1274141795 
020 |a 0470176393  |q (paper/website) 
020 |a 9780470176399  |q (paper/website) 
020 |a 0470285028 
020 |a 9780470285022 
020 |a 9786612136818 
020 |a 6612136812 
020 |z 9780470176399  |q (paper/website) 
029 1 |a AU@  |b 000053250121 
029 1 |a DEBSZ  |b 368467503 
029 1 |a DEBSZ  |b 372816568 
029 1 |a NZ1  |b 14241783 
029 1 |a AU@  |b 000073100618 
035 |a (OCoLC)233000178  |z (OCoLC)647809816  |z (OCoLC)719420362  |z (OCoLC)722444397  |z (OCoLC)740993381  |z (OCoLC)859879158  |z (OCoLC)961550158  |z (OCoLC)962603915  |z (OCoLC)974445844  |z (OCoLC)974519956  |z (OCoLC)981556703  |z (OCoLC)981863735  |z (OCoLC)988453565  |z (OCoLC)992087726  |z (OCoLC)1005947161  |z (OCoLC)1017997837  |z (OCoLC)1037477345  |z (OCoLC)1037903938  |z (OCoLC)1038625234  |z (OCoLC)1043491530  |z (OCoLC)1045495434  |z (OCoLC)1053607044  |z (OCoLC)1055404742  |z (OCoLC)1064917610  |z (OCoLC)1081237827  |z (OCoLC)1083603763  |z (OCoLC)1096477203  |z (OCoLC)1103273528  |z (OCoLC)1112866407  |z (OCoLC)1119030592  |z (OCoLC)1129365868  |z (OCoLC)1135963200  |z (OCoLC)1152992673  |z (OCoLC)1153522299  |z (OCoLC)1162051368  |z (OCoLC)1192352060  |z (OCoLC)1228551108  |z (OCoLC)1274132704  |z (OCoLC)1274141795 
037 |a CL0500000090  |b Safari Books Online 
050 4 |a QA76.9.C55  |b P752 2008eb 
082 0 4 |a 005.75/85  |2 22 
049 |a UAMI 
245 0 0 |a Professional SQL server 2005 performance tuning /  |c Steven Wort [and others]. 
260 |a Indianapolis, Ind. :  |b Wiley Pub.,  |c ©2008. 
300 |a 1 online resource (xxiii, 551 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a data file 
490 1 |a Wrox professional guides 
504 |a Includes bibliographical references and index. 
505 0 |a Professional SQL Server® 2005 Performance Tuning; About the Authors; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Convention; Source Code; Errata; Part I: Finding Bottlenecks when Something's Wrong; Chapter 1: Performance Tuning; Art or Science?; The Science of Performance Tuning; Performance Tuning Applied; Summary; Chapter 2: Monitoring Server Resources with System Monitor; Why Might I Need System Monitor?; When Should I Use System Monitor?; Performance Monitor Overview 
505 8 |a Getting Started with System MonitorWhat's the Impact of Running System Monitor?; How Much Data Will System Monitor Generate?; Resource Utilization; Identifying Bottlenecks; Using System Monitor Proactively; Running System Monitor on 64-bit Systems; Combining System Monitor Logs and SQL Profiler Traces; Monitoring Remote Servers; Best Practices for System Monitor; My System Monitor Counters Are Missing-What Should I Do?; Built-in Log Management Tools; Analyzing Log Data; Summary; Chapter 3: Monitoring SQL Server Resources with System Monitor; The Beginning; Types of Performance Problems 
505 8 |a Types of BottlenecksMemory Bottlenecks; CPU Bottlenecks; Disk Bottlenecks; Monitoring Database Mirroring Performance; Monitoring Wait Statistics; Typical Performance Problems; Using SQL Server to Analyze Performance Logs; Combining Performance Monitor Logs and SQL Profiler Trace; Summary; Chapter 4: SQL Server Wait Types; SQL Server Waits; Architecture; Common or Noteworthy Resource Wait Types; How to Track Waits; Locking and Blocking; Summary; Chapter 5: Finding Problem Queries with SQL Profiler; Preparations for Setting Up a Trace; Capturing Blocking Events; Capturing Showplan XML Data 
505 8 |a Capturing Deadlock GraphsIdentifying Long-Running Queries Using SQL Profiler; Tracing Costly Queries by Using Profiler to Generate Server-Side Trace Code; Correlating a Profiler Trace with System Monitor Performance Counter Data; Summary; Part II: Removing Bottlenecks with Tuning; Chapter 6: Choosing and Configuring Hardware; Server Bottlenecks; Configuring the Server; Summary; Chapter 7: Tuning SQL Server Configuration; Considerations before Adjusting Server Level Settings; Inspecting Current SQL Server Settings; Important Server Settings: CPU, Memory, and I/O; Summary 
505 8 |a Chapter 8: Tuning the SchemaData Quality; Data Performance; Summary; Chapter 9: Tuning T-SQL; Opening Move: The Optimizer's Gameplan; Middle Game: Gathering the Facts; End Game: Performance Tuning T-SQL; Tuning T-SQL with a New Approach; Tuning the T-SQL Predicate; Tuning T-SQL to Use Indexes; Tuning T-SQL Common Patterns or Idioms; Tuning the T-SQL Statement with Hints; Tuning for Deadlocking and Blocking; Simulated Stress Testing for Query Plans; Summary; Part III: Preventative Measures and Baselining Performance with Tools 
546 |a English. 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
630 0 0 |a SQL server. 
630 0 7 |a SQL server.  |2 blmlsh 
630 0 7 |a SQL server.  |2 fast  |0 (OCoLC)fst01376937 
650 0 |a Client/server computing. 
650 6 |a Architecture client-serveur (Informatique) 
650 7 |a Client/server computing.  |2 fast  |0 (OCoLC)fst00864205 
700 1 |a Wort, Steven.  |4 aut 
776 0 8 |i Print version:  |t Professional SQL server 2005.  |d Indianapolis, IN : Wiley Pub., 2008  |w (DLC) 2007045707 
830 0 |a Wrox professional guides. 
856 4 0 |u https://learning.oreilly.com/library/view/~/9780470176399/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
936 |a BATCHLOAD 
938 |a Askews and Holts Library Services  |b ASKH  |n AH13344991 
938 |a Books 24x7  |b B247  |n bks00024432 
938 |a ebrary  |b EBRY  |n ebr10308162 
938 |a YBP Library Services  |b YANK  |n 3031812 
994 |a 92  |b IZTAP