The Official Guide: Sybase ASE 12.5 Performance and Tuning (Paperback)

Jeffrey Garbus

  • 出版商: Jones and Bartlett
  • 出版日期: 2002-08-16
  • 定價: $2,800
  • 售價: 3.6$999
  • 語言: 英文
  • 頁數: 413
  • 裝訂: Paperback
  • ISBN: 1556229089
  • ISBN-13: 9781556229084
  • 立即出貨(限量) (庫存=1)

買這商品的人也買了...

商品描述

Description

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, and processing queries. Additionally, the authors discuss application design, deadlocks and locking schemes, performance metrics, and auditing features, along with providing tips for solving problems that can bog down a system.

This book is a must for those who are responsible for maximizing server performance.

The companion CD-ROM contains ASE 12.5 NT Developer’s Edition.
 



商品描述(中文翻譯)

描述

一旦您的資料庫系統運行起來,您需要確保它能夠順利運作。《Sybase ASE 12.5 Performance and Tuning》是專為希望最大化 Sybase 伺服器效能的資料庫管理員(DBA)而設計的指南。本書從系統基準測試和優化儲存程序,到索引和使用 sp_sysmon 監控系統,詳細解釋了如何調整伺服器以達到最佳效能。

主題包括定義效能、了解 I/O 系統、使用查詢優化器、管理記憶體和處理查詢。此外,作者還討論了應用程式設計、死結和鎖定方案、效能指標和審計功能,並提供解決可能拖慢系統的問題的技巧。

對於負責最大化伺服器效能的人來說,這本書是必讀的。

附帶的 CD-ROM 包含 ASE 12.5 NT Developer's Edition。