概述....................................................................................................................................................................................4
簡介:復雜、關鍵的系統需要高級性能管理.......................................................................................................................5
當今的數據庫系統:復雜性和關鍵性..............................................................................................................................5
高級性能管理..................................................................................................................................................................5
什么是高級性能管理?...............................................................................................................................................6
高級性能管理的優點...................................................................................................................................................7
了解影響數據庫性能的因素................................................................................................................................................8
了解數據庫管理模式...........................................................................................................................................................9
改進響應管理....................................................................................................................................................................10
智能警報.......................................................................................................................................................................10
以問題為中心的工作流.................................................................................................................................................10
常見問題識別................................................................................................................................................................10
自動改善和優化............................................................................................................................................................10
啟用問題預防....................................................................................................................................................................11
降級工作負載分析.........................................................................................................................................................11
SQL 代碼性能審核........................................................................................................................................................11
碎片評估和報告............................................................................................................................................................11
配置驗證.......................................................................................................................................................................12
漏洞評估.......................................................................................................................................................................12
啟用性能保護....................................................................................................................................................................13
防止應用程序更改.........................................................................................................................................................14
防止平臺更改................................................................................................................................................................14
消除部署風險............................................................................................................................................................14
防止用戶工作負載變化.................................................................................................................................................15
了解工作負載................................................................................................................................................................15
將只讀事務分擔到 ODS................................................................................................................................................16
Quest 工具........................................................................................................................................................................17
結論..................................................................................................................................................................................18
關于作者...........................................................................................................................................................................19
關于 Quest Software, Inc..................................................................................................................................................20 |
|