{"id":604,"date":"2008-09-29T21:56:16","date_gmt":"2008-09-29T20:56:16","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=604"},"modified":"2008-09-29T21:59:20","modified_gmt":"2008-09-29T20:59:20","slug":"adalek-az-elozo-screencasthoz","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2008\/09\/29\/adalek-az-elozo-screencasthoz\/","title":{"rendered":"Adal\u00e9k az el\u0151z\u0151 screencasthoz"},"content":{"rendered":"<p>F\u00e9l nap alatt k\u00f6zel 400-an megn\u00e9zt\u00e9k vagy belen\u00e9ztek a <a href=\"http:\/\/soci.hu\/blog\/index.php\/2008\/09\/29\/gyakorlati-sql-server-optimalizalas-screencast-tapasztalatok-a-valo-eletbol\/\">screencastba<\/a>, ennek igaz\u00e1n \u00f6r\u00fcl\u00f6k, nem gondoltam, hogy ennyi embert \u00e9rdekel a t\u00e9ma.<br \/>\nK\u00f6zben visszajeleztek bar\u00e1taim, hogy a probl\u00e9ma  -\u00fagy n\u00e9z ki- megold\u00f3dott, az a lek\u00e9rdez\u00e9s fullasztotta le a szervert, amit a vide\u00f3ban optimaliz\u00e1ltunk. :)<br \/>\n<a href=\"https:\/\/www.netacademia.net\/ActiveTrainers.aspx?Trainer=13\">Hangy\u00e1l Zoli<\/a> a NetAcademia SQL szak\u00e9rt\u0151je jelezte, hogy a performance counterek \u00e9s a profiler eredm\u00e9nyeinek egyeztet\u00e9s\u00e9t \u00fcgyesebben is meg lehet oldani mint ahogy a screencastban tettem. \u00c9n ugye k\u00e9zzel raktam \u00f6ssze a k\u00e9t adathalmazt.<br \/>\nAz SQL Server 2005 profilere k\u00e9pes az sql trace mell\u00e9 bet\u00f6lteni az adott id\u0151szak peformance logj\u00e1t is, File\/Import Performance Data. Ez igen finom dolog, a k\u00e9t adatforr\u00e1st szinkronban tartva lehet mozogni az id\u0151ben.<br \/>\nAz al\u00e1bbi k\u00e9pen az l\u00e1that\u00f3, amikor a b\u0171n\u00f6s lek\u00e9rdez\u00e9s \u00e9ppen lefutott. Ott leesik j\u00f3 p\u00e1r perf sz\u00e1ml\u00e1l\u00f3, \u00e9s ha a piros f\u00fcgg\u0151leges vonallal arra a k\u00f6rny\u00e9kre navig\u00e1lok fel\u00fcl m\u00e1ris bej\u00f6n a beteg lek\u00e9rdez\u00e9s a profilerbe. Nagyon durva, nem? K\u00f6sz\u00f6net Zolinak a tipp\u00e9rt.<\/p>\n<p><a href=\"http:\/\/soci.hu\/blog\/wp-content\/uploads\/2008\/09\/perfmoncountersinprofiler.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/soci.hu\/blog\/wp-content\/uploads\/2008\/09\/perfmoncountersinprofiler-300x186.jpg\" alt=\"\" title=\"Performance Counterek a Profilerben\" width=\"300\" height=\"186\" class=\"aligncenter size-medium wp-image-605\" srcset=\"https:\/\/soci.hu\/blog\/wp-content\/uploads\/2008\/09\/perfmoncountersinprofiler-300x186.jpg 300w, https:\/\/soci.hu\/blog\/wp-content\/uploads\/2008\/09\/perfmoncountersinprofiler-600x373.jpg 600w, https:\/\/soci.hu\/blog\/wp-content\/uploads\/2008\/09\/perfmoncountersinprofiler.jpg 1858w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>F\u00e9l nap alatt k\u00f6zel 400-an megn\u00e9zt\u00e9k vagy belen\u00e9ztek a screencastba, ennek igaz\u00e1n \u00f6r\u00fcl\u00f6k, nem gondoltam, hogy ennyi embert \u00e9rdekel a t\u00e9ma. K\u00f6zben&#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,30,21,58],"tags":[],"class_list":["post-604","post","type-post","status-publish","format-standard","hentry","category-adatbazisok","category-szakmai-elet","category-sql-server","category-sql-server-2005","category-sql-server-2008"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/604","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=604"}],"version-history":[{"count":6,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/604\/revisions"}],"predecessor-version":[{"id":611,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/604\/revisions\/611"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}