{"id":11074,"date":"2023-04-12T13:36:00","date_gmt":"2023-04-12T10:36:00","guid":{"rendered":"http:\/\/www.kuspha.com\/blog\/?p=11074"},"modified":"2023-07-19T16:20:26","modified_gmt":"2023-07-19T13:20:26","slug":"teknolojide-gelismeler-yavuz-acikel-lst-yazilim-proje-yoneticisi","status":"publish","type":"post","link":"http:\/\/www.kuspha.com\/blog\/teknolojide-gelismeler-yavuz-acikel-lst-yazilim-proje-yoneticisi\/","title":{"rendered":"Teknolojide Geli\u015fmeler-Yavuz A\u00e7\u0131kel LST Yaz\u0131l\u0131m Proje Y\u00f6neticisi"},"content":{"rendered":"
\n
\"\"<\/figure><\/div>\n\n\n
\n
\n

Yavuz A\u00e7\u0131kel ve Proje s\u00fcre\u00e7leri?<\/strong>
Merhaba sevgili okurlar. Yaz\u0131mda sizlere LST Yaz\u0131l\u0131m\u2019da proje y\u00f6neticisi olarak yapt\u0131\u011f\u0131m i\u015flerden ve SQL Server\u2019da execution plan kavram\u0131ndan bahsedece\u011fim. Umar\u0131m faydal\u0131 bir payla\u015f\u0131m olur. Yaz\u0131l\u0131m geli\u015ftiricisi olarak 2006 y\u0131l\u0131nda Meteksan Sistemde ba\u015flad\u0131\u011f\u0131m kariyerime, Kale Yaz\u0131l\u0131m ve \u0130nnova\u2019 da uzman yaz\u0131l\u0131m geli\u015ftiricisi olarak \u00e7al\u0131\u015ft\u0131ktan sonra May\u0131s 2014\u2019te tak\u0131m liderli\u011fi pozisyonunda b\u00fcnyesinde
kat\u0131ld\u0131\u011f\u0131m LST Yaz\u0131l\u0131m\u2019da, son 3 y\u0131ld\u0131r proje y\u00f6neticisi olarak; proje ekipleriyle birlikte, teknik mimari yap\u0131s\u0131n\u0131,
kod geli\u015ftirmelerini, ama\u00e7lar\u0131n\u0131, kapsam\u0131n\u0131, b\u00fct\u00e7esini ve zaman \u00e7izelgelerini belirlemede aktif rol almaktay\u0131m. Projelerin ilerlemesini takip ederken, riskleri y\u00f6netip, proje sahipleriyle d\u00fczenli olarak raporlar payla\u015farak ileti\u015fimi koordine etmekteyim. \u00d6zetle projelerin hem
idari hem de teknik taraf\u0131nda bulunmaktay\u0131m.<\/p>\n<\/div>\n\n\n\n

\n

Execution plan nedir ve neden \u00f6nemlidir?<\/strong>
Bir sorgunun nas\u0131l \u00e7al\u0131\u015faca\u011f\u0131n\u0131 ve sorgudaki her b\u00f6l\u00fcm\u00fcn sorguya maliyet oran\u0131n\u0131 belirleyen yol haritas\u0131d\u0131r. SQL Server\u2019a g\u00f6nderdi\u011finiz bir TSQL sorgusu yava\u015f \u00e7al\u0131\u015ft\u0131\u011f\u0131nda ilk bak\u0131lacak yer sorgunun execution plan\u2019\u0131d\u0131r. Execution plan, sorgunun nas\u0131l optimize edilebilece\u011fini g\u00f6steren bir ara\u00e7t\u0131r.
Execution plan iki \u00e7e\u015fittir: Estimated execution plan ve actual execution plan. Estimated execution plan sorguyu \u00e7al\u0131\u015ft\u0131rmadan, \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131 takdirde kullanaca\u011f\u0131 execution plan\u2019\u0131 tahmin eder. Actual execution plan ise sorgu \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131ktan sonra ger\u00e7ekten kulland\u0131\u011f\u0131 execution plan\u2019\u0131 ifade eder.
Lst yaz\u0131l\u0131mda bildi\u011finiz \u00fczere \u00e7ok geni\u015f kapsaml\u0131 E-Devlet projelerini y\u00fcr\u00fctmekteyiz. Bu projelerimiz b\u00fcy\u00fck veri i\u00e7erdi\u011finden dolay\u0131 projelerimizde kullan\u0131lan sorgular\u0131n performans\u0131 \u00e7ok \u00f6nemlidir. Sorgu performans\u0131n\u0131z\u0131 g\u00f6zlemlemek ve art\u0131rmak i\u00e7in execution plan analizinden faydalanmam\u0131z gerekmektedir. Execution plan analizi ile sorgunun hangi indexleri kulland\u0131\u011f\u0131n\u0131, hangi join t\u00fcrlerini se\u00e7ti\u011fini, hangi b\u00f6l\u00fcmlerin en \u00e7ok maliyet getirdi\u011fini ve nas\u0131l iyile\u015ftirilebilece\u011fini g\u00f6rebiliriz.
Siz de bu bilgileri kullanarak projelerinizdeki sorgular\u0131n
performans\u0131n\u0131 art\u0131rabilirsiniz.<\/p>\n<\/div>\n\n\n\n

\n

Burada bulundu\u011fum s\u00fcre i\u00e7erisinde bir\u00e7ok ba\u015far\u0131l\u0131 projede yer ald\u0131m ve almaktay\u0131m. Ba\u015far\u0131l\u0131 i\u015fler
yapabilmemizin en \u00f6nemli kriterleri kesinlikle birbirine inanan, g\u00fcvenen ve kenetlenen bir ekip olabilmektir.
Ba\u015far\u0131l\u0131 i\u015fler yapabilmeyi harika bir mekanizmaya benzetirsek ve bu mekanizman\u0131n i\u00e7inde de \u00e7arklar\u0131n
oldu\u011funu d\u00fc\u015f\u00fcn\u00fcrsek e\u011fer, bu mekanizman\u0131n sorunsuz ve m\u00fckemmel \u00e7al\u0131\u015fabilmesi i\u00e7in i\u00e7inde bulunan her bir
\u00e7ark\u0131n \u00e7ok kritik \u00f6neme sahip oldu\u011funa inan\u0131yorum. Ben bu \u00e7arklar\u0131 alan\u0131nda uzman ekiplerimizdeki bireylere
benzetiyorum. Bu harika mekanizmay\u0131 \u00e7al\u0131\u015ft\u0131ran \u00e7arklar\u0131n kurulmas\u0131nda ve ba\u015far\u0131n\u0131n zeminini haz\u0131rlayan say\u0131n y\u00f6neticilerimize ve ekip arkada\u015flar\u0131ma te\u015fekk\u00fcr\u00fc bir bor\u00e7 bilirim. \u00c7ok b\u00fcy\u00fck projelerde ba\u015far\u0131yla ilerliyoruz ve olu\u015fturdu\u011fumuz tecr\u00fcbeler ile eminim ki daha nice \u00f6nemli projelere hep birlikte imzalar ataca\u011f\u0131z.<\/p>\n\n\n\n

Yavuz A\u00e7\u0131kel
Yaz\u0131l\u0131m Proje Y\u00f6neticisi<\/strong><\/p>\n<\/div>\n<\/div>\n\n\n\n

\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n

Project Management Plan E\u011fitimi D\u00fczenlendi<\/strong><\/p>\n\n\n\n

\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Yavuz A\u00e7\u0131kel ve Proje s\u00fcre\u00e7leri?Merhaba sevgili okurlar. Yaz\u0131mda sizlere LST Yaz\u0131l\u0131m\u2019da proje y\u00f6neticisi olarak yapt\u0131\u011f\u0131m i\u015flerden ve SQL Server\u2019da execution plan kavram\u0131ndan bahsedece\u011fim. Umar\u0131m faydal\u0131 bir payla\u015f\u0131m olur. Yaz\u0131l\u0131m geli\u015ftiricisi olarak 2006 y\u0131l\u0131nda Meteksan Sistemde ba\u015flad\u0131\u011f\u0131m kariyerime, Kale Yaz\u0131l\u0131m ve \u0130nnova\u2019 da uzman yaz\u0131l\u0131m geli\u015ftiricisi olarak \u00e7al\u0131\u015ft\u0131ktan sonra May\u0131s 2014\u2019te tak\u0131m liderli\u011fi pozisyonunda b\u00fcnyesindekat\u0131ld\u0131\u011f\u0131m LST…<\/p>\n","protected":false},"author":1,"featured_media":11075,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[163],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.kuspha.com\/blog\/wp-json\/wp\/v2\/posts\/11074"}],"collection":[{"href":"http:\/\/www.kuspha.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.kuspha.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.kuspha.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.kuspha.com\/blog\/wp-json\/wp\/v2\/comments?post=11074"}],"version-history":[{"count":7,"href":"http:\/\/www.kuspha.com\/blog\/wp-json\/wp\/v2\/posts\/11074\/revisions"}],"predecessor-version":[{"id":11107,"href":"http:\/\/www.kuspha.com\/blog\/wp-json\/wp\/v2\/posts\/11074\/revisions\/11107"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.kuspha.com\/blog\/wp-json\/wp\/v2\/media\/11075"}],"wp:attachment":[{"href":"http:\/\/www.kuspha.com\/blog\/wp-json\/wp\/v2\/media?parent=11074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.kuspha.com\/blog\/wp-json\/wp\/v2\/categories?post=11074"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.kuspha.com\/blog\/wp-json\/wp\/v2\/tags?post=11074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}