{"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\/bs\/blog\/opasen-li-sql-profiler","title":{"rendered":"Da li je SQL profiler opasan?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Nedavno sam s pomalo iznena\u0111enja saznao da je u jednom od odjela ogromne firme u kojoj radim zabranjeno pokretanje <b>SQL profiler<\/b> u radnom vremenu. <\/p>\n<p><img decoding=\"async\" alt=\"Da li je SQL profiler opasan?\" 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 \/>\nNe znam kako se snalaze za analizu problema sa performansama koji se doga\u0111aju upravo tokom radnog vremena. Naime, performance views \u010desto ne daju ta\u010dnu sliku, posebno ako usporava jedna ili dvije procedure upita, ne optere\u0107uju\u0107i posebno sam server. Sitni upit koji se izvr\u0161ava nekoliko puta na sat i traje 10 sekundi umjesto jedne (ali radi <i>vrlo va\u017ene<\/i> klijenta <i>veoma nervozne<\/i>) sigurno ne\u0107e biti u DMV views. A select s CROSS APPLY na tekstovima upita sam zna\u010dajno optere\u0107uje server.<\/p>\n<p>Me\u0111utim, zanimljivo mi je razumjeti odakle dolazi ova bojazan. U nekim firmama <b>SQL profiler<\/b> to je radni alat, a u nekima su se bojali kao vatre (neko vrijeme sam se bavio konsultacijama i mogao sam da uporedim). Gotovo sam siguran da je stvar bila ovakva:<\/p>\n<p><img decoding=\"async\" alt=\"Da li je SQL profiler opasan?\" src=\"\/wp-content\/uploads\/2019\/03\/936a4e41d921c2ea233846ef13b6ccb0.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<b>Hjustone, imamo problema. Baza usporava. Rije\u0161i to.<\/b><\/p>\n<p><img decoding=\"async\" alt=\"Da li je SQL profiler opasan?\" src=\"\/wp-content\/uploads\/2019\/03\/1b22ab07fb2ac865780a9c428106b229.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"Da li je SQL profiler opasan?\" src=\"\/wp-content\/uploads\/2019\/03\/7a55fba9306a68d3c4d1c0e73ef787af.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<b>Ovde ima toliko kva\u010dica... \u0160ta mi je potrebno?<\/b><\/p>\n<p><img decoding=\"async\" alt=\"Da li je SQL profiler opasan?\" src=\"\/wp-content\/uploads\/2019\/03\/dfba6e304f71c5e590c4f08924ab3525.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<img decoding=\"async\" alt=\"Da li je SQL profiler opasan?\" src=\"\/wp-content\/uploads\/2019\/03\/35fb73e84c688833dfb95b435266a4e3.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<b>U redu, stavi\u0107u sve kva\u010dice i onda \u0107u odlu\u010diti.<\/b><\/p>\n<p><img decoding=\"async\" alt=\"Da li je SQL profiler opasan?\" src=\"\/wp-content\/uploads\/2019\/03\/59202ccc117546886f2a1c116586a526.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n\u0160ta ostaje u mislima visokog menad\u017ementa? Neko je to pokrenuo <b>SQL profiler<\/b> i sve se zaustavilo. I onda se to prepri\u010dava jedni drugima za vrijeme partije golfa.<\/p>\n<p>Usput, posebnu pikantnost dodaje poku\u0161aj snimanja takvih \u2018<i>snimamo sve<\/i>\u2019 tragova ne u datoteku, nego u bazu na ovom istoj <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/bs\/server\/dts-dronten\/\"   title=\"serveru\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2456\">serveru<\/a> \u2013 jednom sam svjedo\u010dio takvom slu\u010daju.<\/p>\n<p>Kako je kod vas? Molimo vas da u\u010destvujete u anketi.<\/p>\n<p class=\"for_users_only_msg\">Samo registrovani korisnici mogu u\u010destvovati u anketi. <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/auth\/login\/\">Prijavite se<\/a><\/noindex>, molim vas.<\/p>\n<h2 class=\"default-block__polling-title\">Mo\u017ee li se kod vas pokretati SQL profiler na PROD-u?<\/h2>\n<ul class=\"content-list content-list_polling\">\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Mi smo mala kompanija, ovde je sve jednostavno.<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Prodak\u0161n administratori naravno mogu<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Prodak\u0161n administratori mogu nakon odobrenja i udaranja u \u010delo.<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Svet, svet, svet.<\/p>\n<\/li>\n<\/ul>\n<p>    Glasali su 4 korisnika. Uzdr\u017eali su se 3 korisnika.<br \/>\n<br \/>Izvor: <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.5.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\/bs\/blog\/opasen-li-sql-profiler\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"bs_BA\" \/>\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\/bs\/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\udd47Da li je SQL profiler opasan? | ProHoster","description":"Nedavno sam s pomalo iznena\u0111enja saznao da je u jednom od odjela ogromne firme u kojoj radim zabranjeno pokretanje SQL profiler-a u radnom vremenu.","canonical_url":"https:\/\/prohoster.info\/bs\/blog\/opasen-li-sql-profiler","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"bs_BA","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\/bs\/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\/bs\/wp-json\/wp\/v2\/posts\/30174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/comments?post=30174"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts\/30174\/revisions"}],"predecessor-version":[{"id":159738,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts\/30174\/revisions\/159738"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/media?parent=30174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/categories?post=30174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/tags?post=30174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}