GaussDB T 生成WSR報告解讀

華為GaussDB T WSR（Workload Statistics Report）是GaussDB T自帶的系統工具，WSR通過對比兩次快照收集到的統計信息，來生成報表數據，用于分析指定時間段內數據庫的性能情況，用于分析系統性能問題，類比于Oracle的AWR報告。

WSR詳細介紹參考：

華為GaussDB T 負載分析報告WSR?https://www.modb.pro/db/7107

查看快照list：

SQL>?wsr?list Listing?the?lastest?Completed?Snapshots ????Snap?Id??????????Snap?Started??????DB_startup_time---------------??-------------------??------------------ ????????????322??2019-12-26?11:12:18??2019-12-25?11:12:17 ????????????321??2019-12-26?10:42:18??2019-12-25?11:12:17 ????????????320??2019-12-26?10:12:18??2019-12-25?11:12:17 ????????????319??2019-12-26?09:42:18??2019-12-25?11:12:17 ????????????318??2019-12-26?09:12:18??2019-12-25?11:12:17 ????????????317??2019-12-26?08:42:18??2019-12-25?11:12:17 ????????????316??2019-12-26?08:12:18??2019-12-25?11:12:17 ????????????315??2019-12-26?07:42:18??2019-12-25?11:12:17 ????????????314??2019-12-26?07:12:18??2019-12-25?11:12:17 ????????????313??2019-12-26?06:42:18??2019-12-25?11:12:17 ????????????312??2019-12-26?06:12:18??2019-12-25?11:12:17 ????????????311??2019-12-26?05:42:18??2019-12-25?11:12:17 ????????????310??2019-12-26?05:12:18??2019-12-25?11:12:17 ????????????309??2019-12-26?04:42:18??2019-12-25?11:12:17 ????????????308??2019-12-26?04:12:18??2019-12-25?11:12:17 ????????????307??2019-12-26?03:42:18??2019-12-25?11:12:17 ????????????306??2019-12-26?03:12:18??2019-12-25?11:12:17 ????????????305??2019-12-26?02:42:18??2019-12-25?11:12:17 ????????????304??2019-12-26?02:12:18??2019-12-25?11:12:17 ????????????303??2019-12-26?01:42:18??2019-12-25?11:12:17

手工創建快照：

SQL>?call?wsr$create_snapshot; PL/SQL?procedure?successfully?completed. SQL>? SQL>??wsr?list Listing?the?lastest?Completed?Snapshots ????Snap?Id??????????Snap?Started??????DB_startup_time---------------??-------------------??------------------ ????????????323??2019-12-26?11:34:56??2019-12-25?11:12:17 ????????????322??2019-12-26?11:12:18??2019-12-25?11:12:17 ????????????321??2019-12-26?10:42:18??2019-12-25?11:12:17 ????????????320??2019-12-26?10:12:18??2019-12-25?11:12:17 ????????????319??2019-12-26?09:42:18??2019-12-25?11:12:17 ????????????318??2019-12-26?09:12:18??2019-12-25?11:12:17 ????????????317??2019-12-26?08:42:18??2019-12-25?11:12:17 ????????????316??2019-12-26?08:12:18??2019-12-25?11:12:17 ????????????315??2019-12-26?07:42:18??2019-12-25?11:12:17 ????????????314??2019-12-26?07:12:18??2019-12-25?11:12:17 ????????????313??2019-12-26?06:42:18??2019-12-25?11:12:17 ????????????312??2019-12-26?06:12:18??2019-12-25?11:12:17 ????????????311??2019-12-26?05:42:18??2019-12-25?11:12:17 ????????????310??2019-12-26?05:12:18??2019-12-25?11:12:17 ????????????309??2019-12-26?04:42:18??2019-12-25?11:12:17 ????????????308??2019-12-26?04:12:18??2019-12-25?11:12:17 ????????????307??2019-12-26?03:42:18??2019-12-25?11:12:17 ????????????306??2019-12-26?03:12:18??2019-12-25?11:12:17 ????????????305??2019-12-26?02:42:18??2019-12-25?11:12:17 ????????????304??2019-12-26?02:12:18??2019-12-25?11:12:17

生成WSR報告：

SQL>?wsr?322?323 WSR?report?file?name?:?wsrrpt_322_323.html WSR?report?Generation?Success.

詳細操作參考：

《GaussDB T WSR簡介》?: https://www.modb.pro/db/13711

另外還有兩篇墨天輪文檔供參考：

《深入解讀GaussDB WSR性能分析報告》：https://www.modb.pro/doc/852

《GaussDB 100 WSR報告操作手冊》：https://www.modb.pro/doc/851

查看報告：

可以在墨天輪上查看報告示例：

《Gaussdb T WSR 報告示例》?: https://www.modb.pro/db/13710

報告基本上就是按照Oracle AWR的模子來做的，熟悉AWR報告的同學應該非常容易上手。主要分為以下幾個部分：

Database Information

Instance Information

Host Information

Snap Information

Database Load

Instance Efficiency

Top 10 Events by Total Wait Time

Host CPU

Host Memory

Instance Snap

Session Statistics

SQL Statistics

Complete List of SQL Text

Segment Statistics

Instance Parameters

GaussDB T 的dbtime為60.58，按照Oracle的計算方式來看，cpus為2，快照間隔為22分鐘，60/22≈3>2，說明目前的負載對當前硬件來說已經較高，需要降低負載或者升級硬件。

如下是gaussdb T的TOP 10等待事件：

轉自墨天輪

數據庫 GaussDB

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。