{"height":"190","author_url":"https://blog.hatena.ne.jp/koogucc11/","blog_title":"\u90fd\u5185\u3067\u50cd\u304fSE\u306e\u6280\u8853\u7684\u306a\u3072\u3068\u308a\u3054\u3068 / Technical soliloquy of System Engineer working in Tokyo","image_url":"http://cdn-ak.f.st-hatena.com/images/fotolife/k/koogucc11/20141026/20141026072115.png","provider_name":"Hatena Blog","url":"https://ryuchan.hatenablog.com/entry/2014/10/26/093454","author_name":"koogucc11","provider_url":"https://hatena.blog","categories":["SQL Server","Tuning"],"description":"\u4eca\u56de\u3084\u308b\u3053\u3068\u3092\u8aac\u660e\u3057\u3066\u307f\u308b sys.dm_exec_query_optimizer_info (Transact-SQL) \u3092\u4f7f\u7528\u3057\u3066\u6700\u9069\u5316\u60c5\u5831\u3092\u53d6\u5f97\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002 \u4f7f\u7528\u3059\u308b\u74b0\u5883\u3092\u8aac\u660e\u3057\u3066\u307f\u308b \u4e45\u3057\u3076\u308a\u306b Azure \u74b0\u5883\u3092\u4f7f\u3044\u307e\u3059\u3002SQL Server 2014 \u3067\u3059\u3002 \u65e9\u901f\u305f\u3081\u3057\u3066\u307f\u308b \u4e0b\u8a18\u306e\u30af\u30a8\u30ea\u3092 SQL Server Management Studio \u3067\u5b9f\u884c\u3057\u307e\u3059\u3002 select * from sys.dm_exec_query_optimizer_info \u500b\u5225\u306e\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8 (\u30af\u30a8\u30ea) \u306e\u6700\u9069\u5316\u3054\u3068\u306e\u5e73\u5747\u7d4c\u904e\u6642\u9593 (\u79d2\u5358\u4f4d)\u3084\u5185\u90e8\u30b3\u30b9\u30c8\u5358\u4f4d\u3067\u306e\u3001\u6700\u9069\u5316\u30d7\u30e9\u30f3\u306b\u5bfe\u3059\u308b\u63a8\u5b9a\u30b3\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fryuchan.hatenablog.com%2Fentry%2F2014%2F10%2F26%2F093454\" title=\"SQL Server \u306e\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306b\u3064\u3044\u3066\u307e\u3068\u3081\u3066\u307f\u308b - \u305d\u306e11 - ( dm_exec_query_optimizer_info \u3067\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306e\u52b9\u679c\u3092\u78ba\u8a8d\u3057\u3066\u307f\u308b ) - \u90fd\u5185\u3067\u50cd\u304fSE\u306e\u6280\u8853\u7684\u306a\u3072\u3068\u308a\u3054\u3068 / Technical soliloquy of System Engineer working in Tokyo\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2014-10-26 09:34:54","title":"SQL Server \u306e\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306b\u3064\u3044\u3066\u307e\u3068\u3081\u3066\u307f\u308b - \u305d\u306e11 - ( dm_exec_query_optimizer_info \u3067\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306e\u52b9\u679c\u3092\u78ba\u8a8d\u3057\u3066\u307f\u308b )","blog_url":"https://ryuchan.hatenablog.com/","type":"rich","width":"100%","version":"1.0"}