LEADER 05329nam 2200661Ia 450 001 9910782802603321 005 20200520144314.0 010 $a1-282-13681-X 010 $a9786612136818 010 $a0-470-28502-8 035 $a(CKB)1000000000747592 035 $a(EBL)433723 035 $a(OCoLC)609835570 035 $a(SSID)ssj0000364793 035 $a(PQKBManifestationID)11263046 035 $a(PQKBTitleCode)TC0000364793 035 $a(PQKBWorkID)10398144 035 $a(PQKB)11326963 035 $a(Au-PeEL)EBL433723 035 $a(CaPaEBR)ebr10308162 035 $a(CaONFJC)MIL213681 035 $a(CaSebORM)9780470176399 035 $a(MiAaPQ)EBC433723 035 $a(EXLCZ)991000000000747592 100 $a20071102d2008 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 00$aProfessional SQL server 2005$b[electronic resource] $eperformance tuning /$fSteven Wort ... [et al.] 205 $a1st edition 210 $aIndianapolis, IN $cWiley Pub.$d2008 215 $a1 online resource (580 p.) 225 0 $aWrox professional guides Professional SQL Server 2005 performance tuning 300 $aDescription based upon print version of record. 311 $a0-470-17639-3 320 $aIncludes bibliographical references and index. 327 $aProfessional 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 327 $aGetting 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 327 $aTypes 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 327 $aCapturing 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 327 $aChapter 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 327 $aChapter 10: Capturing, Measuring, and Replaying a Workload Using SQL Profiler 330 $aWritten by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. The book first walks you through how to discover bottlenecks when something is wrong and you'll then learn how to identify and remove the problems that are causing poor performance. You'll discover preventive measures you can take to try to avoid a performance problem entirely and you'll learn how to achieve better performance. 606 $aClient/server computing 615 0$aClient/server computing. 676 $a005.75 676 $a005.75/85 676 $a005.7585 701 $aWort$b Steven$01520033 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910782802603321 996 $aProfessional SQL server 2005$93758476 997 $aUNINA