48%
Microsoft SQL Server 2000 Optimization Guide

Microsoft SQL Server 2000 Optimization Guide

          
5
4
3
2
1

Available


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Quantity:
Add to Wishlist

About the Book

This book is designed to provide readers with knowledge and skills required to tune and optimize SQL server V7.0 for performance. It will assist the reader in understanding the processes and procedures that are used in tuning and optimization of databases running on SQL Server. It will describe the differences between SQLV7.0 and previous versions and how the improvements impact performance. It will instruct the reader on how to use the tools available with SQL Server V7.0 so that optimizing and maintaining a database structure becomes second nature. Further the book will explore the necessity to develop applications with performance in mind.

Table of Contents:
Foreword. Preface. I. OVERVIEW AND ARCHITECTURE. 1. Overview of SQL Server 2000. Enhancements to SQL Server 2000. Large Memory Support. Internet Support. SQL Server V7.X Enhancements. Performance Analysis Tools. Resource Consumers. Key Considerations for Tuning SQL Server. Why Are Tuning and Optimization Necessary? Summary. 2. The Storage Engine. Introduction to the Storage Engine. Storage Engine Features. Subsystem Overview. Implementation Considerations. Data Organization. Storage Layout. Database Files. System Databases. Creating, Altering and Dropping Databases. Filegroups. Maintaining Data and Log Files. Table Organization. Data Types. Indexes. Managing the Transaction Log. Database Locking Mechanisms. Memory Utilization. Processor Utilization. Summary. 3. Query Processor. Introduction to the Query Processor. Query Execution. Query Optimization. Types of Query Optimizers. Statistics and the Query Optimizer. Improvements to the SQL Server Query Processor. Internet Support. Partitioning Views-Federated SQL Server 2000 Servers. Efficiency of Data Transfer. Query Governor. Query Optimization Techniques. Join Techniques. Hints. Indexing Strategies. Parallel Execution of Queries. Stored Procedures. Multiphase. Automatic Parameters. Transitive Predicates. Star Queries. Optimization for Data Modifications. Tools for Working with Queries. Summary. II. PERFORMANCE CONSIDERATIONS. 4. Hardware Considerations. Introduction. General Hardware Bottleneck Considerations. Disk Configurations. RAID or Not to RAID. Understanding RAID Levels. Hardware RAID vs Software RAID. Disk and Controller Considerations. Understanding Disk I/O. Transfer Rates. Disk Transfer Rates. Calculating Throughput. Determine Capacity of Controllers. PCI Bus Bandwidth. Tape Devices. Summarizing Disk I/O Subsystem Requirements. Suggestions for Improving Disk I/O. The More Hardware the Better. Read-Ahead Manager. Separate Activities. Disk Considerations for SQL Server and Windows NT/2000. Memory Considerations. Processor Considerations. Network Considerations. Summary. 5. Implementing High Availability Solutions. Introduction to High Availability Solutions. Introduction to Clustering. Microsoft Cluster Server Implementation. Clustering Configurations. How Failover Works. SQL Server on Microsoft Cluster Server. Resource Issues Running SQL Server in a Cluster. Multiple Instances of SQL Server. Federated SQL Server 2000 Servers. Backup and Restore Capabilities. Log Shipping. Stand-By Server. SQL Server Replication. Summary. 6. Application Considerations. Application Design Considerations. Normalization. Introduction to Indexes. Index Components. Clustered Indexes. Tables without Clustered Indexes. Clustered Index Example. Nonclustered Indexes. Example of a Nonclustered Index when a Clustered Index Exists. Example of a Nonclustered Index when a Clustered Index Has Been Dropped. Indexing Options. Creating Indexes. Optimizing Index Creation. Composite Indexes. Covering Indexes. Indexing Views. Index Selection. Understanding Index Selectivity and Density. Indexing Factors Affecting Query Performance. Tools for Managing Indexes. DBCC for Managing Tables, Indexes and Statistics. Summary. III. DIAGNOSING AND RESOLVING PROBLEMS-TUNING AND OPTIMIZATION. 7. Performance Tuning with Windows NT/2000 Tools. Monitoring Objectives. Create a Baseline. Windows NT/2000 Performance Monitor. Introduction to Performance Monitor. Performance Monitor Options. Monitor Each Key Area. Understanding CPU Utilization. Understanding Disk Utilization. Understanding Page Faulting-The Memory Object. Windows NT/2000 Objects-Process. Windows NT/2000 Objects-Thread. Windows NT/2000 Objects-Network. SQL Server Objects. SQL Server Default Performance Monitor Workspace File. SQL Server Object-Access Methods. SQL Server Object-Backup Device. SQL Server Object-Buffer Manager. SQL Server Object-Cache Manager. SQL Server Object-Databases. SQL Server Object-General Statistics. SQL Server Object-Locks. SQL Server Object-Memory Manager. SQL Server Object-Replication Agents Object. SQL Server Object-Replication Distribution Object. SQL Server Object-Replication Logreader Object. SQL Server Object-Replication Merge Object. SQL Server Object-Replication Snapshot Object. SQL Server Object-Statistics. SQL Server Object-User Settable Objects. Monitoring Performance with the Windows NT/2000 Control Panel. Virtual Memory. Application Responsiveness. Services. Network Bindings. Task Manager. System Information / Windows NT Diagnostics. Summary. 8. Monitoring and Configuring SQL Server. Introduction. Enterprise Manager. sp_configure. Monitoring Activity. sp_monitor. Viewing and Modifying Database Options. Managing the Configuration of SQL Server. Monitoring User Activity. Monitoring and Managing the Integrity of the Database. Summary. 9. Automating SQL Server Tasks. Automating the Monitoring of SQL Server. Database Maintenance Plan. Jobs. Alerts. Creating Alerts. Summary. 10. SQL Server Profiler. Introduction to Server Profiler. Monitoring Events. Event Categories. Security Audit. Data Columns. Filters. General Trace Information. Sample Traces. Create a Trace Template. Create a Trace to Capture an SQL Server Workload. Reading the Trace File. Replay. Summary. 11. SQL Server Query Analyzer. Introduction to the Query Analyzer. Execute SQL Statements and Commands. Object Browser. Color Coded for Ease of Use. Viewing Statistics, CPU Times, and Execution Profile. Performing Index Analysis. Create a Trace File from Query Analyzer. Analyze Data from SQL Server Profiler. ShowPlan and Graphical ShowPlan. Execute a Query with Graphical ShowPlan. Understanding Graphical ShowPlan. Performance Considerations. Interpreting Node Information. Reading Red Flags. Creating Missing Statistics. Managing Statistics. Managing Indexes. Re-Execute Query. Verify Successful Tuning Analysis. Summary. 12. Index Tuning Wizard. Introduction to the Index Tuning Wizard. Using the Index Tuning Wizard. Select Tables to Tune. Index Tuning Recommendations. Analysis of Index Tuning Wizard Recommendations. Implementing Recommendations. Reviewing the Script File. Recommendations. Summary. APPENDIX A Resources. APPENDIX B Contents of the CD. I. SYSTEM REQUIREMENTS. II. GETTING STARTED-LAUNCHING THE CD. Windows Users. Macintosh Users. III. NAVIGATING THE MEDIA EDITION-General Guidelines. IV SUPPORT. INDEX.


Best Sellers


Product Details
  • ISBN-13: 9780130883582
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Prentice Hall
  • Height: 235 mm
  • No of Pages: 544
  • Spine Width: 31 mm
  • Width: 178 mm
  • ISBN-10: 0130883581
  • Publisher Date: 29 Nov 2000
  • Binding: Paperback
  • Language: English
  • Series Title: Prentice Hall Ptr Microsoft Technologies Series
  • Weight: 1030 gr


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Microsoft SQL Server 2000 Optimization Guide
Pearson Education (US) -
Microsoft SQL Server 2000 Optimization Guide
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Microsoft SQL Server 2000 Optimization Guide

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA