Once your database system is up and running, you need to keep it functioning smoothly. Designed for the DBA working to maximize the performance of a Sybase server, Sybase ASE 12.5 Performance and Tuning provides a guide to this important process. From benchmarking your system and optimizing stored procedures to indexing and using sp_sysmon to monitor your system, the authors thoroughly explain how to tune your server for maximum performance. Topics include defining performance, understanding the I/O system, using the query optimizer, managing memory, processing queries, application design, deadlocks and locking schemes, performance metrics, auditing features, tips for solving problems that can bog down a system.
Systems administrators often have two basic questions: "What do I need to do to keep the system running smoothly?" "What do I do if something goes wrong?" "Learn SQL Server 7.0 Administration" answers the first question in detail, with the expectation that this will prevent the second question from being asked. To achieve this goal, SQL Server consultant Jeffrey Garbus provides detailed information about designing and implementing a preventive maintenance regimen in order to ensure ongoing reliability, performance, and preparedness for disaster recovery. The book opens by introducing basic concepts, then quickly progresses to such advanced topics as configuring SQL Server for optimum performance, monitoring activity on the server, using the Database Consistency Checker, and backing up and restoring the database. Updating index statistics, using wizards to automate tasks, and replicating data are also covered. Garbus' book is for anyone who must learn to maintain a SQL Server. Jeffrey Garbus is an experienced SQL Server 7.0 consultant. He has spoken at user conferences, written many magazine articles, and has several SQL and database books to his credit. He is the CEO of Soaring Eagle Consulting, Ltd., based in Florida. Contributing authors: Alvin Chang is a consultant for Soaring Eagle Consulting, and Penny Garbus is president of Soaring Eagle Consulting.
This book takes the reader through job responsibilities and planning to implementation and performance monitoring. Checklists are included to guide the reader through various tasks. The authors provide a hands-on guide to setting up and administrating a network as well as a reference guide that administrators can refer to for troubleshooting tips and techniques.
Learn how to implement, administer, and troubleshoot information systems that incorporate Microsoft SQL Server 7.0. The book includes sections on proven test-taking strategies, warning on trick questions, and time-saving study tips and shortcuts.
Thank you for visiting our website. Would you like to provide feedback on how we could improve your experience?
This site does not use any third party cookies with one exception — it uses cookies from Google to deliver its services and to analyze traffic.Learn More.