{"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\/sq\/blog\/opasen-li-sql-profiler","title":{"rendered":"A \u00ebsht\u00eb i rreziksh\u00ebm SQL profiler?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

S\u00eb fundmi m'u be intriguese t\u00eb m\u00ebsoja se n\u00eb nj\u00eb nga departamentet e nj\u00eb kompanie t\u00eb madhe, ku punoj, \u00ebsht\u00eb e ndaluar t\u00eb ekzekutohet SQL profiler<\/b> n\u00eb or\u00ebt e pun\u00ebs. <\/p>\n

\"A
\n<\/a><\/noindex>
\nNuk e di se si arrijn\u00eb t\u00eb analizojn\u00eb problemet me performanc\u00ebn q\u00eb ndodhin pik\u00ebrisht gjat\u00eb or\u00ebve t\u00eb pun\u00ebs. Sepse shikimet e performanc\u00ebs shpesh nuk japin nj\u00eb pamje t\u00eb sakt\u00eb, ve\u00e7an\u00ebrisht n\u00ebse ngadal\u00ebsohet nj\u00eb\/a dy procedura\/k\u00ebrkesa, pa ngarkuar ve\u00e7an\u00ebrisht serverin. Nj\u00eb k\u00ebrkes\u00eb e vog\u00ebl, e cila ekzekutohet disa her\u00eb n\u00eb or\u00eb dhe punon 10 sekonda n\u00eb vend t\u00eb nj\u00eb (por b\u00ebn di\u00e7ka shum\u00eb t\u00eb r\u00ebnd\u00ebsishme<\/i> p\u00ebr klientin shum\u00eb nervoz<\/i>) nuk do t\u00eb kapet n\u00eb shikimet DMV. Dhe nj\u00eb select me CROSS APPLY p\u00ebr tekstet e k\u00ebrkesave e ngarkon serverin m\u00eb s\u00eb miri.<\/p>\n

Megjithat\u00eb, m\u00eb intereson t\u00eb kuptoj se nga buron kjo frik\u00eb. N\u00eb disa kompani SQL profiler<\/b> \u00ebsht\u00eb nj\u00eb instrument pune, n\u00eb disa e p\u00ebshtjellin sikur \u00ebsht\u00eb nj\u00eb zjarr (p\u00ebr nj\u00eb koh\u00eb t\u00eb caktuar kam ndihmuar n\u00eb konsultimit dhe mund t\u00eb krahasoja). Jam pothuajse i sigurt se k\u00ebshtu ka qen\u00eb:<\/p>\n

\"A
\nHjuston, kemi probleme. Baza po ngadal\u00ebsohet. Ndihmo.<\/b><\/p>\n

\"A
\n
\n\"A
\nK\u00ebtu jan\u00eb kaq shum\u00eb kutia\u2026 \u00c7far\u00eb do t\u00eb m'i nevojitet?<\/b><\/p>\n

\"A
\n\"A
\nShtypa t\u00eb gjitha kutit\u00eb dhe pastaj do t\u00eb vendos.<\/b><\/p>\n

\"A
\n
\n\u00c7far\u00eb mbetet n\u00eb mendjen e drejtuesve t\u00eb lart\u00eb? Disa e lan\u00eb SQL profiler<\/b> dhe gjith\u00e7ka ndaloi. Dhe pastaj e tregojn\u00eb nj\u00ebri-tjetrit gjat\u00eb nj\u00eb partie golfi.<\/p>\n

P\u00ebr m\u00eb tep\u00ebr, nj\u00eb pik\u00eb e ve\u00e7ant\u00eb i jep p\u00ebrpjekja p\u00ebr t\u00eb regjistruar k\u00ebta \u2018regjistrojm\u00eb gjith\u00e7ka<\/i>\u2019 traces jo n\u00eb skedar, por n\u00eb baz\u00ebn e t\u00eb nj\u00ebjt\u00ebs serverin<\/a> - nj\u00eb her\u00eb isha d\u00ebshmitar i nj\u00eb rasti t\u00eb till\u00eb.<\/p>\n

Si jan\u00eb pun\u00ebt p\u00ebr ju? Ju lutem, merrni pjes\u00eb n\u00eb anket\u00eb<\/p>\n

Vet\u00ebm p\u00ebrdoruesit e regjistruar mund t\u00eb marrin pjes\u00eb n\u00eb anket\u00eb. Hyni<\/a><\/noindex>, ju lutem.<\/p>\n

A mund t\u00eb ekzekutoni SQL profiler n\u00eb PROD?<\/h2>\n