{"id":5852,"date":"2022-03-10T21:25:54","date_gmt":"2022-03-10T12:25:54","guid":{"rendered":"https:\/\/www.climb.co.jp\/blog_dbmoto\/?p=5852"},"modified":"2026-02-10T17:41:46","modified_gmt":"2026-02-10T08:41:46","slug":"database-performance-analyzer%e3%81%ab%e3%82%88%e3%82%8b%e5%be%85%e3%81%a1%e6%99%82%e9%96%93%e7%95%b0%e5%b8%b8%e3%81%ae%e8%aa%bf%e6%9f%bb%e3%81%ae%e5%85%b7%e4%bd%93%e4%be%8b","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/5852","title":{"rendered":"Database Performance Analyzer\u306b\u3088\u308b\u5f85\u3061\u6642\u9593\u7570\u5e38\u306e\u8abf\u67fb\u306e\u5177\u4f53\u4f8b  [DPA]"},"content":{"rendered":"\n<p><a href=\"https:\/\/www.climb.co.jp\/soft\/dbpanalyzer\/\" target=\"_blank\" rel=\"noopener\">Database Performance Analyzer(DPA)<\/a>\u306f\u3001\u7570\u5e38\u691c\u51fa\u30a2\u30eb\u30b4\u30ea\u30ba\u30e0\u3092\u4f7f\u7528\u3057\u3066\u3001\u4e88\u671f\u305b\u306c\u5f85\u3061\u6642\u9593\u306e\u5897\u52a0\u3092\u7279\u5b9a\u3057\u307e\u3059\u3002\u3053\u306e\u4f8b\u3067\u306f\u3001DPA \u3092\u4f7f\u7528\u3057\u3066\u3001\u4e88\u671f\u3057\u306a\u3044\u5f85\u3061\u6642\u9593\u306e\u5897\u52a0\u306e\u6839\u672c\u539f\u56e0\u3092\u898b\u3064\u3051\u308b\u65b9\u6cd5\u3092\u4f8b\u3068\u3057\u3066\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<h2><strong>\u554f\u984c\u70b9<\/strong><\/h2>\n<p>DPA\u306e\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u304b\u3089\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001DPA\u306fTop SQL Statements\u30c1\u30e3\u30fc\u30c8\u306e\u4e0b\u306bAnomaly Detection\uff08\u7570\u5e38\u691c\u77e5\uff09\u30c1\u30e3\u30fc\u30c8\u3092\u8868\u793a\u3057\u307e\u3059\u3002\u3053\u306e\u4f8b\u3067\u306f\u30011\u670824\u65e5\u306bDPA\u304c\u91cd\u5927\u306a\u7570\u5e38\u3092\u691c\u51fa\u3057\u305f\u3053\u3068\u304c\u30c1\u30e3\u30fc\u30c8\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/1gs-anomaly-detected.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5854\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/1gs-anomaly-detected.png\" alt=\"\" width=\"605\" height=\"590\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/1gs-anomaly-detected.png 605w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/1gs-anomaly-detected-300x293.png 300w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/a><\/p>\n<h2><br \/><strong>\u8abf\u67fb<\/strong><\/h2>\n<p>1.\u7570\u5e38\u691c\u51fa\u30c1\u30e3\u30fc\u30c8\u3067\u30011\u670824\u65e5\u3092\u8868\u3059\u30d0\u30fc\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p>1\u65e5\u9593\u306e\u7570\u5e38\u691c\u51fa\u30c1\u30e3\u30fc\u30c8\u3067\u306f\u3001\u7570\u5e38\u306f\u5348\u524d2\u6642\u306e\u6642\u9593\u5e2f\u306b\u767a\u751f\u3057\u305f\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/2gs-anomaly-one-hour.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5855\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/2gs-anomaly-one-hour.png\" alt=\"\" width=\"582\" height=\"470\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/2gs-anomaly-one-hour.png 582w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/2gs-anomaly-one-hour-300x242.png 300w\" sizes=\"auto, (max-width: 582px) 100vw, 582px\" \/><\/a><\/p>\n<p>2\uff0e\u5348\u524d2\u6642\u306e\u6642\u9593\u5e2f\u3092\u8868\u3059\u30d0\u30fc\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p>\u305d\u306e\u6642\u9593\u5e2f\u306b\u5b9f\u884c\u3055\u308c\u305fSQL\u6587\u306e\u4e0a\u4f4d\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u3053\u306e\u4f8b\u3067\u306f\u3001COMMIT TRAN SQL\u6587\u306e\u5f85\u3061\u6642\u9593\u304c\u3001\u4ed6\u306e\u3069\u306e\u6587\u3088\u308a\u3082\u5927\u5e45\u306b\u9577\u304f\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u7570\u5e38\u306e\u539f\u56e0\u3067\u3042\u308b\u53ef\u80fd\u6027\u304c\u9ad8\u3044\u3068\u3044\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/3gs-anomaly-drill-in.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5856\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/3gs-anomaly-drill-in.png\" alt=\"\" width=\"627\" height=\"300\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/3gs-anomaly-drill-in.png 627w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/3gs-anomaly-drill-in-300x144.png 300w\" sizes=\"auto, (max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>\uff13\uff0eCOMMIT TRAN SQL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u540d\u524d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001Query Details\u30da\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u3001\u9078\u629e\u3057\u305f\u6642\u9593\u5e2f\uff08\u3053\u306e\u4f8b\u3067\u306f\u5348\u524d2\u6642\u304b\u3089\u5348\u524d3\u6642\uff09\u306b\u304a\u3051\u308b\u305d\u306eSQL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u95a2\u3059\u308b\u8a73\u7d30\u60c5\u5831\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u6642\u9593\u5e2f\u306e\u4e3b\u306a\u5f85\u3061\u306e\u7a2e\u985e\u306f\u3001HADR_SYNC_COMMIT\u3067\u3042\u308b\u3053\u3068\u306b\u6ce8\u76ee\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u306e\u5f85\u6a5f\u306f\u3001\u30d7\u30e9\u30a4\u30de\u30eaAG\u30ec\u30d7\u30ea\u30ab\u304c\u30bb\u30ab\u30f3\u30c0\u30ea\u30ec\u30d7\u30ea\u30ab\u306e\u30c7\u30fc\u30bf\u3092\u30b3\u30df\u30c3\u30c8\u3059\u308b\u306e\u3092\u5f85\u3063\u3066\u3044\u308b\u3053\u3068\u3092\u793a\u3057\u307e\u3059\u3002\u6700\u3082\u53ef\u80fd\u6027\u306e\u9ad8\u3044\u554f\u984c\u306f\u3001AG\u74b0\u5883\u5185\u3067\u901f\u5ea6\u4f4e\u4e0b\u304c\u767a\u751f\u3057\u3066\u3044\u308b\u3053\u3068\u3067\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/4gs-anomaly-query-details.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5857\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/4gs-anomaly-query-details.png\" alt=\"\" width=\"620\" height=\"226\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/4gs-anomaly-query-details.png 620w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/4gs-anomaly-query-details-300x109.png 300w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/a><\/p>\n<p>4. COMMIT TRAN\u306e\u6b63\u5e38\u306a\u72b6\u614b\u3092\u77e5\u308b\u305f\u3081\u306b\u3001\u753b\u9762\u4e0a\u90e8\u4e2d\u592e\u306e\u65e5\u4ed8\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u300c\u904e\u53bb90\u65e5\u9593\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u30b0\u30e9\u30d5\u306f\u3001\u904e\u53bb90\u65e5\u9593\u306eCOMMIT TRAN SQL\u6587\u306e\u5f85\u3061\u6642\u9593\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/5gs-anomaly-qpa-90-days.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5858\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/5gs-anomaly-qpa-90-days.png\" alt=\"\" width=\"622\" height=\"229\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/5gs-anomaly-qpa-90-days.png 622w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/5gs-anomaly-qpa-90-days-300x110.png 300w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><\/a><\/p>\n<p>\u3053\u3053\u3067\u4e0b\u8a18\u306e\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/p>\n<p>\u25cf\u3053\u306eSQL\u6587\u306f\u300111\u670815\u65e5\u304b\u308912\u670810\u65e5\u307e\u3067\u9577\u3044HADR_SYNC_COMMIT\u306e\u5f85\u3061\u6642\u9593\u304c\u3042\u308a\u307e\u3057\u305f\u304c\u30011\u670824\u65e5\u307b\u3069\u5f85\u3061\u6642\u9593\u306f\u6df1\u523b\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<br \/>\u25cf12\u670810\u65e5\u304b\u30891\u670824\u65e5\u307e\u3067\u306f\u3001\u307b\u3068\u3093\u3069\u554f\u984c\u304c\u3042\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002<br \/>\u25cf1\u670824\u65e5\u306b\u7570\u5e38\u306b\u9577\u3044\u5f85\u3061\u6642\u9593\u304c\u767a\u751f\u3057\u3001DPA\u304b\u3089\u7570\u5e38\u304c\u5831\u544a\u3055\u308c\u307e\u3057\u305f\u3002<br \/>\u25cf1\u670824\u65e5\u307b\u3069\u306e\u5f85\u3061\u6642\u9593\u306f\u306a\u3044\u3082\u306e\u306e\u3001\u554f\u984c\u306f\u7d99\u7d9a\u3057\u3066\u767a\u751f\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>5. [AG\u30b9\u30c6\u30fc\u30bf\u30b9] \u30bf\u30d6\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u53ef\u7528\u6027\u30b0\u30eb\u30fc\u30d7\u540d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001AG\u30b9\u30c6\u30fc\u30bf\u30b9\u306b\u95a2\u3059\u308b\u60c5\u5831\u3092\u8868\u793a\u3057\u307e\u3059\u3002\u3053\u306e\u5834\u5408\u3001\u9855\u8457\u306a\u9045\u5ef6\u304c\u767a\u751f\u3057\u3066\u3044\u308b\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/6gs-anomaly-ag.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5859\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/6gs-anomaly-ag.png\" alt=\"\" width=\"574\" height=\"288\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/6gs-anomaly-ag.png 574w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2022\/03\/6gs-anomaly-ag-300x151.png 300w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/a><\/p>\n<p>\u3053\u306e\u30c7\u30fc\u30bf\u306b\u57fa\u3065\u304d\u3001\u8abf\u67fb\u30c1\u30fc\u30e0\u306fSolarWinds SAM\u3092\u4f7f\u7528\u3057\u3066\u3055\u3089\u306b\u8abf\u67fb\u3092\u9032\u3081\u3001\u30d7\u30e9\u30a4\u30de\u30ea\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30ec\u30d7\u30ea\u30ab\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u9593\u306e\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u306e\u554f\u984c\u304c\u7570\u5e38\u306e\u6839\u672c\u539f\u56e0\u3067\u3042\u308b\u3053\u3068\u3082\u7a81\u304d\u6b62\u3081\u307e\u3057\u305f\u3002<\/p>\n<p>\u7570\u5e38\u304c\u691c\u51fa\u3055\u308c\u305f\u3068\u304d\u306b\u901a\u77e5\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u5f85\u6a5f\u6642\u9593\u7570\u5e38\u30a2\u30e9\u30fc\u30c8\u3092\u69cb\u6210\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Performance Analyzer(DPA)\u306f\u3001\u7570\u5e38\u691c\u51fa\u30a2\u30eb\u30b4\u30ea\u30ba\u30e0\u3092\u4f7f\u7528\u3057\u3066\u3001\u4e88\u671f\u305b\u306c\u5f85\u3061\u6642\u9593\u306e\u5897\u52a0\u3092\u7279\u5b9a\u3057\u307e\u3059\u3002\u3053\u306e\u4f8b\u3067\u306f\u3001DPA \u3092\u4f7f\u7528\u3057\u3066\u3001\u4e88\u671f\u3057\u306a\u3044\u5f85\u3061\u6642\u9593\u306e\u5897\u52a0\u306e\u6839\u672c\u539f\u56e0\u3092\u898b\u3064\u3051\u308b\u65b9\u6cd5 &hellip; <a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/5852\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[304],"tags":[372,546,547],"class_list":["post-5852","post","type-post","status-publish","format-standard","hentry","category-dpa","tag-372","tag-546","tag-anomaly-detection"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/5852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=5852"}],"version-history":[{"count":4,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/5852\/revisions"}],"predecessor-version":[{"id":6038,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/5852\/revisions\/6038"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=5852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=5852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=5852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}