{"id":2646,"date":"2013-04-27T11:24:09","date_gmt":"2013-04-27T11:24:09","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2646"},"modified":"2013-06-10T01:32:44","modified_gmt":"2013-06-10T01:32:44","slug":"xevent-%e5%9c%a8%e8%a1%a8%e6%95%b0%e6%8d%ae%e6%9b%b4%e6%96%b0%ef%bc%8c%e5%88%a0%e9%99%a4%e6%97%b6%e8%ae%b0%e5%bd%95","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2013\/04\/27\/xevent-%e5%9c%a8%e8%a1%a8%e6%95%b0%e6%8d%ae%e6%9b%b4%e6%96%b0%ef%bc%8c%e5%88%a0%e9%99%a4%e6%97%b6%e8%ae%b0%e5%bd%95\/","title":{"rendered":"XEVENT\u5165\u95e8"},"content":{"rendered":"<div>\n\tXEVENT:\u5728\u6307\u5b9a\u4e8b\u4ef6\u53d1\u751f\u65f6\u8bb0\u5f55\uff0c\u53ef\u5c06\u65e5\u5fd7\u653e\u5728\u5185\u5b58\u6216\u6587\u4ef6\u4e2d\uff0c\u6548\u7387\u6bd4sqlprofile\u9ad8\u3002<br \/>\n\t\u53c2\u8003\uff1a<br \/>\n\t<a href=\"http:\/\/www.extremeexperts.com\/sql\/SQL2008\/xEvents.aspx\">Introduction to Extended Events<\/a><br \/>\n\t<a href=\"http:\/\/blogs.msdn.com\/b\/sqlserverfaq\/archive\/2010\/09\/10\/troubleshooting-error-511-using-xevents.aspx\">Troubleshooting Error 511 using XEvents<\/a><\/p>\n<div>\n\t\t<a href=\"http:\/\/msdn.microsoft.com\/query\/dev10.query?appId=Dev10IDEF1&amp;l=ZH-CN&amp;k=k(CREATE_EVENT_SESSION_TSQL);k(SQL11.SWB.TSQLRESULTS.F1);k(SQL11.SWB.TSQLQUERY.F1);k(MISCELLANEOUSFILESPROJECT);k(DevLang-TSQL)&amp;rd=true\">msdn<\/a><\/div>\n<div>\n\t\t<a href=\"http:\/\/sqlblog.com\/blogs\/jonathan_kehayias\/archive\/2010\/12\/01\/a-xevent-a-day-31-days-of-extended-events.aspx\">An XEvent A Day<\/a><\/div>\n<p>\t<a href=\"http:\/\/blogs.msdn.com\/b\/sqlosteam\/archive\/2009\/06\/04\/using-xevent-in-sql-server.aspx\">\u76f8\u5173DMV1<\/a><br \/>\n\t<a href=\"http:\/\/sqlblog.com\/blogs\/jonathan_kehayias\/archive\/2010\/12\/01\/a-xevent-a-day-31-days-of-extended-events.aspx\">\u76f8\u5173DMV<\/a><a href=\"http:\/\/sqlblog.com\/blogs\/jonathan_kehayias\/archive\/2010\/12\/02\/an-xevent-a-day-2-31-querying-the-extended-events-metadata.aspx\">2<\/a><\/p>\n<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\n\u76f8\u5173DMV:\r\n\r\nEvents\r\n-- Event objects\r\nSELECT p.name AS package_name,\r\n       o.name AS event_name,\r\n       o.description\r\nFROM sys.dm_xe_packages AS p\r\nJOIN sys.dm_xe_objects AS o \r\n     ON p.guid = o.package_guid\r\nWHERE (p.capabilities IS NULL OR p.capabilities &amp; 1 = 0)\r\n  AND (o.capabilities IS NULL OR o.capabilities &amp; 1 = 0)\r\n  AND o.object_type = &#39;event&#39;\r\nActions\r\n\r\n-- Actions\r\nSELECT p.name AS package_name,\r\n       o.name AS action_name,\r\n       o.description\r\nFROM sys.dm_xe_packages AS p\r\nJOIN sys.dm_xe_objects AS o \r\n     ON p.guid = o.package_guid\r\nWHERE (p.capabilities IS NULL OR p.capabilities &amp; 1 = 0)\r\n  AND (o.capabilities IS NULL OR o.capabilities &amp; 1 = 0)\r\n  AND o.object_type = &#39;action&#39; \r\nTargets\r\n\r\n--Event\u83b7\u53d6\u7684\u6570\u636e\r\n\r\nselect * from sys.dm_xe_object_columns\r\nwhere object_name = 'lock_acquired' and column_type = 'data'\r\n\r\n\r\n-- Targets\r\nSELECT p.name AS package_name,\r\n       o.name AS target_name,\r\n       o.description\r\nFROM sys.dm_xe_packages AS p\r\nJOIN sys.dm_xe_objects AS o ON p.guid = o.package_guid\r\nWHERE (p.capabilities IS NULL OR p.capabilities &amp; 1 = 0)\r\n  AND (o.capabilities IS NULL OR o.capabilities &amp; 1 = 0)\r\n  AND o.object_type = &#39;target&#39;\r\n<\/pre>\n<\/div>\n<div>\n\t&nbsp;<\/div>\n","protected":false},"excerpt":{"rendered":"<p>XEVENT:\u5728\u6307\u5b9a\u4e8b\u4ef6\u53d1\u751f\u65f6\u8bb0\u5f55\uff0c\u53ef\u5c06\u65e5\u5fd7\u653e\u5728\u5185\u5b58\u6216\u6587\u4ef6\u4e2d\uff0c\u6548\u7387\u6bd4sqlprofile\u9ad8\u3002 \u53c2\u8003\uff1a Intr [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2646","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2646","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2646"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2646\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}