Welcome to the material supporting page for this session. The materials on this page have been selected as the best matches to the content covered in the live event session.
Session Outline
In this session, we will take an in-depth look at how SQL Server optimizes and processes queries. We will look at Index Tuning and how properly configured indexes can decrease the amount of time SQL Server takes in retrieving information. We will explore the features and functions of the SQL Profiler, and how it can be used to troubleshoot performance issues. Finally, we will learn how to monitor the performance of both SQL Server and the system running it by utilizing the System Monitor and the objects and counters provided by SQL Server.
Use the following resources to learn more about topics covered in this briefing.
Microsoft Press Books
Microsoft SQL Server 2000 Performance Tuning Technical Reference
Summary: This guide gives you the practical information you need to configure and tune a Microsoft SQL Server 2000 database for better, faster, more scalable solutions. The authors start with the basics and build upon them to teach the mechanics of performance tuning and how they affect the whole system. This book also shows how to optimize for the underlying operating system and hardware. It's the only book of its kind coauthored by engineers who have worked in the SQL Server performance group. Microsoft SQL Server 2000 Resource Kit
Summary: Create, maintain, and optimize powerful database applications for SQL Server 2000, a key Microsoft .NET Enterprise Server, with expertise from those who know the technology best the SQL Server 2000 product team and Microsoft Consulting Services. This essential kit is packed full of technical details, tools, and utilities to help you maximize the productivity of your enterprise systems, create efficient database applications, and tune the performance of your servers and databases. Microsoft SQL Server 2000 Administrator's Pocket Consultant
Summary: This is a concise reference you'll want with you at all times as you deal with the details of Microsoft SQL Server 2000 database administration. Whether you handle administration for 50 users or 5000, this hands-on, fast-answers guide focuses on what you need to do to get the job done quickly. With extensive easy-to-read tables, lists, and step-by-step instructions, it's the portable, readable guide that will consistently save you time and minimize system downtime by giving you the right information right now. Inside Microsoft SQL Server 2000
Summary: The definitive guide to the architecture and internals of the premier enterprise-class RDBMS. Master the inner workings of today's premier relational database management system with this official guide to the SQL Server 2000 engine. Written by a renowned columnist in partnership with the product development team, this is the must-read book for anyone who needs to understand how SQL Server internal structures affect application development and functionality. Its extensive details about the latest product enhancements, updated installation and administration, and its development advice can help you create high-performance data-warehousing, transaction-processing, and decision-support applications that will scale up for any challenge
Third-Party Books
Essential SQL Server 2000: An Administration Handbook
Summary: Filled with real-world examples, this handbook is a succinct survival guide for both experienced professionals as well as those less familiar with the environment. The book begins with a review of database basics, then progresses to everyday topics including installation, tools, data access, import/export, commands, automation, maintenance, and tuning. The final chapters cover the more advanced features of SQL Server and provide a sample server sizing exercise and helpful hardware discussion. Microsoft SQL Server 2000 Unleashed, 2nd Edition
Summary: Microsoft SQL Server 2000 Unleashed, 2E offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This new edition of Microsoft SQL Server 2000 Unleashed covers the latest updates and service packs to SQL Server 2000, including full support for XML, notification services, and SQL Server CE. The Guru's Guide to SQL Server Architecture and Internals
Summary: The latest book from the highly regarded and best-selling author Ken Henderson, The Guru's Guide to SQL Server Architecture and Internals is the consummate reference to Microsoft SQL Server. Picking up where documentation and white papers leave off, this book takes an all-inclusive approach to provide the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning. Blending in-depth discussion with practical application, the guide begins with several chapters on the fundamental Windows technologies behind SQL Server, including processes and threads, memory management, Windows I/O, and networking. The focus then moves on to the architectural details of SQL Server and how to practically apply them.
Training and Certification
Course 2072: Administering a Microsoft SQL Server 2000 Database
Summary: This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000. Course 2072 is a revision of Course 832, System Administration for Microsoft SQL Server 7.0. The course content is being revised to reflect changes in the product. Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL
Summary: The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000. Course 2723: Microsoft SQL Server 2000 for Experienced Database Professionals Three days Instructor-led.
Summary: This three-day course will teach database professionals who are already proficient in the implementation and maintenance of enterprise databases about the core architecture of Microsoft SQL Server 2000 and how it works. The primary focus of this course is to give experienced database professionals a jump-start to better understanding SQL Server 2000. This is not an advanced course or a how-to course.
|
|