LEADER 05454nam 2200721Ia 450 001 9911099967503321 005 20251214175043.0 010 $a9786612136818 010 $a9781282136816 010 $a128213681X 010 $a9780470285022 010 $a0470285028 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(OCoLC)722444397 035 $a(OCoLC)ocn722444397 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 $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 08$a9780470176399 311 08$a0470176393 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$01992607 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9911099967503321 996 $aProfessional SQL server 2005$94770768 997 $aUNINA LEADER 01908nam 22004213 450 001 9911114240503321 005 20260603080322.0 010 $a9789819202027 035 $a(CKB)47642152200041 035 $a(MiAaPQ)EBC32775237 035 $a(Au-PeEL)EBL32775237 035 $a(OCoLC)1602321262 035 $a(EXLCZ)9947642152200041 100 $a20260603d2026 uy 0 101 0 $aeng 135 $aur||||||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aSoftware Engineering and Development $e7th International Conference, ICSED 2025, Bangkok, Thailand, October 29-31, 2025, Proceedings 205 $a1st ed. 210 1$aSingapore :$cSpringer,$d2026. 210 4$d©2026. 215 $a1 online resource (371 pages) 225 1 $aCommunications in Computer and Information Science Series ;$vv.2889 311 08$a9789819202010 327 $aCommunications in Computer and Information Science -- Software Engineering and Development -- Preface -- Organization -- Contents -- Software Design and Intelligent Program Development -- AI-Based Intelligent Information Systems and Human-Computer Interaction Design -- Language Modeling and Semantic Analysis -- Author Index. 330 $aThis volume CCIS 2889 constitutes the refereed proceedings of the 7th International Conference on Software Engineering and Development, ICSED 2025, held in Bangkok, Thailand, during October 29-31, 2025.The 17 full papers included in this proceedings were carefully reviewed and selected from 55 submissions. 410 0$aCommunications in Computer and Information Science Series 700 $aDohi$b Tadashi$01103518 701 $aDohi$01984013 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9911114240503321 996 $aSoftware Engineering and Development$94757303 997 $aUNINA