05329nam 2200661Ia 450 991082243050332120200520144314.01-282-13681-X97866121368180-470-28502-8(CKB)1000000000747592(EBL)433723(OCoLC)609835570(SSID)ssj0000364793(PQKBManifestationID)11263046(PQKBTitleCode)TC0000364793(PQKBWorkID)10398144(PQKB)11326963(Au-PeEL)EBL433723(CaPaEBR)ebr10308162(CaONFJC)MIL213681(CaSebORM)9780470176399(MiAaPQ)EBC433723(EXLCZ)99100000000074759220071102d2008 uy 0engur|n|---|||||txtccrProfessional SQL server 2005[electronic resource] performance tuning /Steven Wort ... [et al.]1st editionIndianapolis, IN Wiley Pub.20081 online resource (580 p.)Wrox professional guides Professional SQL Server 2005 performance tuning Description based upon print version of record.0-470-17639-3 Includes bibliographical references and index.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 OverviewGetting 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 ProblemsTypes 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 DataCapturing 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; SummaryChapter 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 ToolsChapter 10: Capturing, Measuring, and Replaying a Workload Using SQL ProfilerWritten 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.Client/server computingClient/server computing.005.75005.75/85005.7585Wort Steven1595141MiAaPQMiAaPQMiAaPQBOOK9910822430503321Professional SQL server 20053915944UNINA