{"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":"

Koh\u00eb m\u00eb par\u00eb, me disa habitje, m\u00ebsova se n\u00eb nj\u00eb nga departamentet e nj\u00eb kompanie t\u00eb madhe ku punoj, \u00ebsht\u00eb e ndaluar t\u00eb startosh SQL profiler<\/b> n\u00eb oraret e pun\u00ebs. <\/p>\n

\"A
\n<\/a><\/noindex>
\nNuk e di se si e menaxhojn\u00eb analiz\u00ebn e problemeve t\u00eb performanc\u00ebs, e cila ndodh pik\u00ebrisht n\u00eb oraret e pun\u00ebs. Sepse shikimet e performanc\u00ebs shpesh nuk ofrojn\u00eb nj\u00eb pasqyr\u00eb t\u00eb sakt\u00eb, ve\u00e7an\u00ebrisht n\u00ebse ngadal\u00ebsohet nj\u00eb\/ose dy procedura\/k\u00ebrkesa, pa ngarkuar ve\u00e7an\u00ebrisht vet\u00eb serverin. Nj\u00eb k\u00ebrkes\u00eb shum\u00eb e vog\u00ebl, q\u00eb ekzekutohet disa her\u00eb n\u00eb or\u00eb dhe punon p\u00ebr 10 sekonda n\u00eb vend t\u00eb nj\u00eb (por b\u00ebn shum\u00eb t\u00eb r\u00ebnd\u00ebsishme<\/i> klientin shum\u00eb nervoz<\/i>) p\u00ebr siguri nuk do t\u00eb kapet n\u00eb shikimet DMV. Nd\u00ebrsa nj\u00eb select me CROSS APPLY mbi tekstet e k\u00ebrkesave vet\u00eb ngarkon serverin mjaft.<\/p>\n

Megjithat\u00eb, m\u00eb intereson t\u00eb kuptoj nga vjen kjo frik\u00eb. N\u00eb disa kompani SQL profiler<\/b> \u2013 \u00ebsht\u00eb nj\u00eb mjet pune, n\u00eb disa e frik\u00ebsojn\u00eb si zjarri (p\u00ebr nj\u00eb koh\u00eb isha angazhuar n\u00eb konsulenc\u00eb dhe mund t\u00eb krahasoja). Jam pothuajse i sigurt se \u00e7\u00ebshtja ishte k\u00ebshtu:<\/p>\n

\"A
\nHouston, kemi probleme. Baza \u00ebsht\u00eb ngadal\u00ebsuar. Merre vesh<\/b><\/p>\n

\"A
\n
\n\"A
\nKa kaq shum\u00eb kutiz\u00eb... \u00c7far\u00eb kam nevoj\u00eb?<\/b><\/p>\n

\"A
\n\"A
\nMir\u00eb, do t\u00eb vendos t\u00eb gjitha kutin\u00eb dhe m\u00eb pas do t\u00eb vendos.<\/b><\/p>\n

\"A
\n
\n\u00c7far\u00eb mbetet n\u00eb mendjen e autoriteteve t\u00eb larta? Disa e kan\u00eb nisur SQL profiler<\/b> dhe gjith\u00e7ka \u00ebsht\u00eb bllokuar. Dhe pastaj e tregojn\u00eb k\u00ebt\u00eb nj\u00ebri-tjetrin gjat\u00eb nj\u00eb partie golfi.<\/p>\n

N\u00eb fakt, nj\u00eb pik\u00eb e ve\u00e7ant\u00eb i jep p\u00ebrpjekja p\u00ebr t\u00eb shkruar k\u00ebto \u2018shkruajm\u00eb t\u00eb gjitha<\/i>\u2019 trace nuk n\u00eb skedar, por n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave n\u00eb k\u00ebt\u00eb t\u00eb nj\u00ebjt\u00ebn serveri<\/a> \u2013 nj\u00eb her\u00eb kam qen\u00eb d\u00ebshmitar i nj\u00eb rasti t\u00eb till\u00eb.<\/p>\n

Si jan\u00eb pun\u00ebt tuaj? Ju lutem, merrni pjes\u00eb n\u00eb anketa<\/p>\n

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

A lejohet t\u00eb ekzekutohet SQL profiler n\u00eb PROD?<\/h2>\n