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