{"id":832,"date":"2009-03-18T14:36:29","date_gmt":"2009-03-18T13:36:29","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=832"},"modified":"2009-03-18T14:36:29","modified_gmt":"2009-03-18T13:36:29","slug":"supporting-sql-server-2008-the-system_health-session","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2009\/03\/18\/supporting-sql-server-2008-the-system_health-session\/","title":{"rendered":"Supporting SQL Server 2008: The system_health session"},"content":{"rendered":"<p>Az extended event-\u00f6kre \u00e9p\u00fcl\u0151 dolog, ez, amelyet probl\u00e9m\u00e1k eset\u00e9n \u00e9rdemes <a href=\"http:\/\/blogs.msdn.com\/psssql\/archive\/2008\/07\/15\/supporting-sql-server-2008-the-system-health-session.aspx\">megn\u00e9zni<\/a> a szok\u00e1sos logok mellett:<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSELECT CAST (xest.target_data AS XML)\r\nFROM sys.dm_xe_session_targets xest \r\nJOIN sys.dm_xe_sessions xes ON\r\nxes.address = xest.event_session_address \r\nWHERE xes.name = &#039;system_health&#039;;\r\n<\/pre>\n<p>A h\u00e1tt\u00e9rben fut egy extended event session, ami a g\u00e1zosabb helyzetekben logol. Igaz, csak korl\u00e1tozott m\u00e9retekben \u00e9s mem\u00f3ri\u00e1ban, de lehet benne hasznos inf\u00f3.<br \/>\nEzekr\u0151l van benne inf\u00f3:<br \/>\n    *  The sql_text and session_id for any sessions that encounter an error with severity >=20<br \/>\n    * the sql_text and session_id for any sessions that encounter a &#8220;memory&#8221; type of error such as 17803, 701, etc (we added this because not all memory errors are severity >=20)<br \/>\n    * A record of any &#8220;non-yielding&#8221; problems (you have sometimes seen these in the ERRORLOG as Msg 17883)<br \/>\n    * Any deadlocks that are detected<br \/>\n    * The callstack, sql_text, and session_id for any sessions who have waited on latches (or other interesting resources) for > 15 seconds<br \/>\n    * The callstack, sql_text, and session_id for any sessions who have waited on locks for > 30 seconds<br \/>\n    * The callstack, sql_text, and session_id for any session that have waited for an extended period of time for &#8220;external&#8221; waits or &#8220;pre-emptive waits&#8221;.<\/p>\n<p>J\u00f3 tudni m\u00e9g, hogy az sql log k\u00f6nyvt\u00e1r\u00e1ban vannak trc f\u00e1jlok is, amelyek meg a m\u00e1r 2005 \u00f3ta l\u00e9tez\u0151, h\u00e1tt\u00e9rben fut\u00f3 default trace nyomait r\u00f6gz\u00edti. Ebben is lehetnek \u00e9rt\u00e9kes morzs\u00e1k hibakeres\u00e9shez.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Az extended event-\u00f6kre \u00e9p\u00fcl\u0151 dolog, ez, amelyet probl\u00e9m\u00e1k eset\u00e9n \u00e9rdemes megn\u00e9zni a szok\u00e1sos logok mellett: SELECT CAST (xest.target_data AS XML) FROM sys.dm_xe_session_targets&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,4,21,58],"tags":[],"class_list":["post-832","post","type-post","status-publish","format-standard","hentry","category-adatbazisok","category-szakmai-elet","category-sql-server-2005","category-sql-server-2008"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/832","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=832"}],"version-history":[{"count":1,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/832\/revisions"}],"predecessor-version":[{"id":833,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/832\/revisions\/833"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}