{"id":30174,"date":"2019-10-31T21:33:59","date_gmt":"2019-10-31T18:33:59","guid":{"rendered":"https:\/\/prohoster.info\/blog\/opasen-li-sql-profiler\/"},"modified":"2019-10-31T21:33:59","modified_gmt":"2019-10-31T18:33:59","slug":"opasen-li-sql-profiler","status":"publish","type":"post","link":"https:\/\/prohoster.info\/de\/blog\/opasen-li-sql-profiler","title":{"rendered":"Ist SQL Profiler gef\u00e4hrlich?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Vor kurzem erfuhr ich mit etwas \u00dcberraschung, dass in einer der Abteilungen einer gro\u00dfen Firma, in der ich arbeite, die Ausf\u00fchrung von <b>SQL Profiler<\/b> w\u00e4hrend der Arbeitszeiten verboten ist. <\/p>\n<p><img decoding=\"async\" alt=\"Ist SQL Profiler gef\u00e4hrlich?\" src=\"\/wp-content\/uploads\/2019\/03\/4bec0ebe75cf08699d5abf99beccb9aa.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nIch wei\u00df nicht, wie sie es schaffen, Leistungsprobleme zu analysieren, die genau w\u00e4hrend der Arbeitszeiten auftreten. Schlie\u00dflich geben die Performance-Views oft kein genaues Bild, besonders wenn eine oder zwei Prozeduren\/Abfragen laufen, ohne den Server \u00fcberm\u00e4\u00dfig zu belasten. Eine winzige Abfrage, die mehrmals pro Stunde ausgef\u00fchrt wird und 10 Sekunden anstelle einer ben\u00f6tigt (aber etwas <i>sehr Wichtiges<\/i> f\u00fcr den Kunden <i>sehr nervig<\/i>) wird sicher nicht in den DMV-Views erfasst. Und ein Select mit CROSS APPLY \u00fcber die Textabfragen belastet den Server erheblich.<\/p>\n<p>Ich finde es jedoch interessant zu verstehen, woher diese Angst kommt. In einigen Firmen <b>SQL Profiler<\/b> ist es ein Arbeitswerkzeug, in anderen wird es wie Feuer gef\u00fcrchtet (eine Zeit lang habe ich im Consulting gearbeitet und konnte vergleichen). Ich bin mir fast sicher, dass es so war:<\/p>\n<p><img decoding=\"async\" alt=\"Ist SQL Profiler gef\u00e4hrlich?\" src=\"\/wp-content\/uploads\/2019\/03\/936a4e41d921c2ea233846ef13b6ccb0.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<b>Houston, wir haben ein Problem. Die Datenbank reagiert langsam. K\u00fcmmere dich darum.<\/b><\/p>\n<p><img decoding=\"async\" alt=\"Ist SQL Profiler gef\u00e4hrlich?\" src=\"\/wp-content\/uploads\/2019\/03\/1b22ab07fb2ac865780a9c428106b229.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"Ist SQL Profiler gef\u00e4hrlich?\" src=\"\/wp-content\/uploads\/2019\/03\/7a55fba9306a68d3c4d1c0e73ef787af.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<b>Hier sind so viele H\u00e4kchen... Was brauche ich?<\/b><\/p>\n<p><img decoding=\"async\" alt=\"Ist SQL Profiler gef\u00e4hrlich?\" src=\"\/wp-content\/uploads\/2019\/03\/dfba6e304f71c5e590c4f08924ab3525.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<img decoding=\"async\" alt=\"Ist SQL Profiler gef\u00e4hrlich?\" src=\"\/wp-content\/uploads\/2019\/03\/35fb73e84c688833dfb95b435266a4e3.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<b>Na gut, ich setze alle H\u00e4kchen und entscheide dann.<\/b><\/p>\n<p><img decoding=\"async\" alt=\"Ist SQL Profiler gef\u00e4hrlich?\" src=\"\/wp-content\/uploads\/2019\/03\/59202ccc117546886f2a1c116586a526.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nWas bleibt im Kopf der oberen Leitung? Jemand hat es gestartet <b>SQL Profiler<\/b> und alles ist zum Stillstand gekommen. Und dann erz\u00e4hlen sie sich das beim Golfspiel.<\/p>\n<p>\u00dcbrigens verleiht der Versuch, solche \u2018<i>wir schreiben alles<\/i>\u2019 Traces nicht in eine Datei, sondern in eine Datenbank auf demselben <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/de\/server\/dts-dronten\/\"   title=\"Server\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2456\">Server<\/a> \u2013 einmal war ich Zeuge eines solchen Falls.<\/p>\n<p>Wie laufen die Dinge bei Ihnen? Bitte beteiligen Sie sich an der Umfrage.<\/p>\n<p class=\"for_users_only_msg\">Nur registrierte Benutzer k\u00f6nnen an der Umfrage teilnehmen. <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/auth\/login\/\">Bitte einloggen<\/a><\/noindex>.<\/p>\n<h2 class=\"default-block__polling-title\">Darf man bei Ihnen SQL Profiler in PROD ausf\u00fchren?<\/h2>\n<ul class=\"content-list content-list_polling\">\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Wir sind ein kleines Unternehmen, bei uns ist alles einfach.<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Die Produktionsadmins d\u00fcrfen es nat\u00fcrlich.<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Die Produktionsadmins d\u00fcrfen es nach Genehmigungen und heftigem Kopfnicken.<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Heilig, heilig, heilig.<\/p>\n<\/li>\n<\/ul>\n<p>    4 Nutzer haben abgestimmt. 3 Nutzer haben sich enthalten.<br \/>\n<br \/>Quelle: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/445004\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041d\u0435\u0434\u0430\u0432\u043d\u043e \u0441 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u043c \u0443\u0434\u0438\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0443\u0437\u043d\u0430\u043b, \u0447\u0442\u043e \u0432 \u043e\u0434\u043d\u043e\u043c \u0438\u0437 \u0434\u0435\u043f\u0430\u0440\u0442\u043c\u0435\u043d\u0442\u043e\u0432 \u043e\u0433\u0440\u043e\u043c\u043d\u043e\u0439 \u0444\u0438\u0440\u043c\u044b, \u0433\u0434\u0435 \u044f \u0440\u0430\u0431\u043e\u0442\u0430\u044e, \u0437\u0430\u043f\u0440\u0435\u0449\u0435\u043d \u0437\u0430\u043f\u0443\u0441\u043a SQL profiler \u0432 business hours. \u041d\u0435 \u0437\u043d\u0430\u044e, \u043a\u0430\u043a \u043e\u043d\u0438 \u0432\u044b\u043a\u0440\u0443\u0447\u0438\u0432\u0430\u044e\u0442\u0441\u044f \u0434\u043b\u044f \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u043f\u0440\u043e\u0431\u043b\u0435\u043c \u0441 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e, \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u044f\u0449\u0435\u0439 \u043a\u0430\u043a \u0440\u0430\u0437 \u0432 \u0431\u0438\u0437\u043d\u0435\u0441 \u0447\u0430\u0441\u044b. \u0412\u0435\u0434\u044c performance views \u0447\u0430\u0441\u0442\u043e \u043d\u0435 \u0434\u0430\u044e\u0442 \u0442\u043e\u0447\u043d\u043e\u0439 \u043a\u0430\u0440\u0442\u0438\u043d\u044b, \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e \u0435\u0441\u043b\u0438 \u0442\u043e\u0440\u043c\u043e\u0437\u0438\u0442 \u043e\u0434\u043d\u0430\/\u0434\u0432\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b\/\u043a\u0432\u0435\u0440\u0438, \u043d\u0435 \u043d\u0430\u0433\u0440\u0443\u0436\u0430\u044f \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e \u0441\u0430\u043c [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-30174","post","type-post","status-publish","format-standard","hentry","category-blog"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041d\u0435\u0434\u0430\u0432\u043d\u043e \u0441 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u043c \u0443\u0434\u0438\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0443\u0437\u043d\u0430\u043b, \u0447\u0442\u043e \u0432 \u043e\u0434\u043d\u043e\u043c \u0438\u0437 \u0434\u0435\u043f\u0430\u0440\u0442\u043c\u0435\u043d\u0442\u043e\u0432 \u043e\u0433\u0440\u043e\u043c\u043d\u043e\u0439 \u0444\u0438\u0440\u043c\u044b, \u0433\u0434\u0435 \u044f \u0440\u0430\u0431\u043e\u0442\u0430\u044e, \u0437\u0430\u043f\u0440\u0435\u0449\u0435\u043d \u0437\u0430\u043f\u0443\u0441\u043a SQL profiler \u0432 business hours.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/de\/blog\/opasen-li-sql-profiler\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"de_DE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u041e\u043f\u0430\u0441\u0435\u043d \u043b\u0438 SQL profiler? | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041d\u0435\u0434\u0430\u0432\u043d\u043e \u0441 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u043c \u0443\u0434\u0438\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0443\u0437\u043d\u0430\u043b, \u0447\u0442\u043e \u0432 \u043e\u0434\u043d\u043e\u043c \u0438\u0437 \u0434\u0435\u043f\u0430\u0440\u0442\u043c\u0435\u043d\u0442\u043e\u0432 \u043e\u0433\u0440\u043e\u043c\u043d\u043e\u0439 \u0444\u0438\u0440\u043c\u044b, \u0433\u0434\u0435 \u044f \u0440\u0430\u0431\u043e\u0442\u0430\u044e, \u0437\u0430\u043f\u0440\u0435\u0449\u0435\u043d \u0437\u0430\u043f\u0443\u0441\u043a SQL profiler \u0432 business hours.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/de\/blog\/opasen-li-sql-profiler\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-10-31T18:33:59+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T18:33:59+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Ist SQL Profiler gef\u00e4hrlich? | ProHoster","description":"Vor kurzem erfuhr ich mit etwas \u00dcberraschung, dass in einer der Abteilungen einer gro\u00dfen Firma, in der ich arbeite, die Ausf\u00fchrung von SQL Profiler w\u00e4hrend der Arbeitszeiten verboten ist.","canonical_url":"https:\/\/prohoster.info\/de\/blog\/opasen-li-sql-profiler","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"de_DE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041e\u043f\u0430\u0441\u0435\u043d \u043b\u0438 SQL profiler? | ProHoster","og:description":"\u041d\u0435\u0434\u0430\u0432\u043d\u043e \u0441 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u043c \u0443\u0434\u0438\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0443\u0437\u043d\u0430\u043b, \u0447\u0442\u043e \u0432 \u043e\u0434\u043d\u043e\u043c \u0438\u0437 \u0434\u0435\u043f\u0430\u0440\u0442\u043c\u0435\u043d\u0442\u043e\u0432 \u043e\u0433\u0440\u043e\u043c\u043d\u043e\u0439 \u0444\u0438\u0440\u043c\u044b, \u0433\u0434\u0435 \u044f \u0440\u0430\u0431\u043e\u0442\u0430\u044e, \u0437\u0430\u043f\u0440\u0435\u0449\u0435\u043d \u0437\u0430\u043f\u0443\u0441\u043a SQL profiler \u0432 business hours.","og:url":"https:\/\/prohoster.info\/de\/blog\/opasen-li-sql-profiler","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T18:33:59+00:00","article:modified_time":"2019-10-31T18:33:59+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"30174","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-02-09 21:37:27","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 03:39:24","updated":"2026-02-09 21:37:27","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts\/30174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/comments?post=30174"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts\/30174\/revisions"}],"predecessor-version":[{"id":159738,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts\/30174\/revisions\/159738"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/media?parent=30174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/categories?post=30174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/tags?post=30174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}