Admin911: SQL Server 2000 - Softcover

Brian Knight

 
9780072130973: Admin911: SQL Server 2000
Softcover
ISBN 10: 0072130970 ISBN 13: 9780072130973
Publisher: McGraw-Hill Companies, 2001

Synopsis

This guide should allow DBAs to manage and troubleshoot SQL Server 2000. It contains a troubleshooting chart for ease of use when finding solutions to problems.

"synopsis" may belong to another edition of this title.

From the Back Cover

Survival Guide for System Administrators

Configure, manage, and optimize SQL Server 2000 for peak performance with help from this unique resource. Inside, you'll find immediate solutions to problems involving database and server settings, multiple instances, startup parameters, service packs, stored procedures, and much more. The book also covers the many administrative features built in to SQL Server 2000, including SQL Server Agent, Enterprise Manager, Multi Server Administration, and System Monitor. Get this book and save yourself hundreds of hours of troubleshooting time.

  • Manage SQL Server, including memory and security
  • Optimize and automate administration using SQL Server Agent and other tools
  • Debug jobs
  • Monitor and tune SQL Server using the system monitor and alerts
  • Optimize T-SQL and stored procedures
  • Scale SQL Server using linked servers and Distributed Partitioned Views (DPVs)
  • Troubleshoot database performance
  • Implement disaster recovery procedures

TAKE COMMAND--Specific command-line utilities relating to the topic at hand

CODE BLUE--Things to do when your system is in trouble

BUG ALERT--Common and little-known problems and pitfalls

"About this title" may belong to another edition of this title.

Publisher
McGraw-Hill Companies
Publication date
2001
Language
English
ISBN 10 
0072130970
ISBN 13 
9780072130973
Binding
Paperback
Number of pages
369