{"id":5132,"date":"2018-10-07T15:13:12","date_gmt":"2018-10-07T15:13:12","guid":{"rendered":"http:\/\/mehmetsalihdeveci.net\/?p=5132"},"modified":"2019-02-28T08:20:30","modified_gmt":"2019-02-28T08:20:30","slug":"sql-server-performance-troubleshooting-2","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-performance-troubleshooting-2\/","title":{"rendered":"SQL Server Performance Troubleshooting -2"},"content":{"rendered":"<p>Merhaba Arkada\u015flar,<\/p>\n<p>Bu yaz\u0131mda sizlere \u00f6nceki yaz\u0131mda ba\u015flad\u0131\u011f\u0131m SQL Server da Performance Troubleshooting kavram\u0131n\u0131 ve nas\u0131l yap\u0131ld\u0131\u011f\u0131n\u0131n devam\u0131n\u0131 anlat\u0131yor olaca\u011f\u0131m.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5133\" src=\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/5-2.png\" alt=\"\" width=\"614\" height=\"283\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/5-2.png 620w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/5-2-300x138.png 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<p><!--more--><\/p>\n\n<p>Bu konunun devam\u0131 olan di\u011fer yaz\u0131lar\u0131m\u0131n linkleri a\u015fa\u011f\u0131daki gibidir.<\/p>\n<p><a href=\"https:\/\/ittutorial.org\/2018\/10\/06\/sql-server-performance-troubleshooting-1\/\">https:\/\/ittutorial.org\/2018\/10\/06\/sql-server-performance-troubleshooting-1\/<\/a><\/p>\n<p><a href=\"https:\/\/ittutorial.org\/2018\/10\/07\/sql-server-performance-troubleshooting-2\/\">https:\/\/ittutorial.org\/2018\/10\/07\/sql-server-performance-troubleshooting-2\/<\/a><\/p>\n<p><a href=\"https:\/\/ittutorial.org\/2018\/10\/13\/sql-server-performance-troubleshooting-3\/\">https:\/\/ittutorial.org\/2018\/10\/13\/sql-server-performance-troubleshooting-3\/<\/a><\/p>\n<p><a href=\"https:\/\/ittutorial.org\/2018\/10\/14\/sql-server-performance-troubleshooting-4\/\">https:\/\/ittutorial.org\/2018\/10\/14\/sql-server-performance-troubleshooting-4\/<\/a><\/p>\n<p><a href=\"https:\/\/ittutorial.org\/2018\/10\/20\/sql-server-performance-troubleshooting-5\/\">https:\/\/ittutorial.org\/2018\/10\/20\/sql-server-performance-troubleshooting-5\/<\/a><\/p>\n<p><a href=\"https:\/\/ittutorial.org\/2018\/10\/21\/sql-server-performance-troubleshooting-6\/\">https:\/\/ittutorial.org\/2018\/10\/21\/sql-server-performance-troubleshooting-6\/<\/a><\/p>\n<p><a href=\"https:\/\/ittutorial.org\/2014\/03\/01\/sql-server-dmv-ve-dmf-kavramlari-ve-kullanimlari-1\/\">https:\/\/ittutorial.org\/2014\/03\/01\/sql-server-dmv-ve-dmf-kavramlari-ve-kullanimlari-1\/<\/a><\/p>\n<p><a href=\"https:\/\/ittutorial.org\/2014\/03\/03\/sql-server-dmv-ve-dmf-kavramlari-ve-kullanimlari-2\/\">https:\/\/ittutorial.org\/2014\/03\/03\/sql-server-dmv-ve-dmf-kavramlari-ve-kullanimlari-2\/<\/a><\/p>\n<p><a href=\"https:\/\/ittutorial.org\/2013\/03\/28\/sqldiag-araci-ile-veritabani-performans-verisi-toplama\/\">https:\/\/ittutorial.org\/2013\/03\/28\/sqldiag-araci-ile-veritabani-performans-verisi-toplama\/<\/a><\/p>\n<p><a href=\"https:\/\/ittutorial.org\/2013\/03\/29\/rml-utilities-tool-u-ile-veritabani-performansini-raporlama\/\">https:\/\/ittutorial.org\/2013\/03\/29\/rml-utilities-tool-u-ile-veritabani-performansini-raporlama\/<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Disk I\/O Darbo\u011faz\u0131<\/strong><\/p>\n<p>Diskte ya\u015fanmas\u0131 muhtemel Bottleneck i\u00e7in Perfmon arac\u0131nda Physical ve Logical Disk b\u00f6l\u00fcm\u00fcn\u00fcn\u00a0 alt\u0131nda gelen Performance Counter de\u011ferlerine bak\u0131lmal\u0131d\u0131r.<\/p>\n<ul>\n<li>Disk seconds\/read counter gibi bir counter \u0131n de\u011feri 15-20 ms den b\u00fcy\u00fck \u00e7\u0131kmas\u0131 genelde disk performans sorunu oldu\u011funa i\u015farettir.<\/li>\n<li>Average disk seconds\/write counter \u0131 i\u00e7in s\u00fcrekli olarak g\u00f6r\u00fclen y\u00fcksek de\u011ferler disklerde \u00a0performans sorunun oldu\u011funa i\u015farettir.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>\u2022% Disk Time<\/strong><\/p>\n<p>Disklerin read\/write yapma yo\u011funlu\u011funu g\u00f6sterir. Bu de\u011fer %80 lerde ise diskler yo\u011fun olarak kullan\u0131ld\u0131\u011f\u0131 anla\u015f\u0131l\u0131r. Bu de\u011ferin %50 ve alt\u0131nda olmas\u0131 Disk Bottleneck olmad\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5137\" src=\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/7-3.png\" alt=\"\" width=\"614\" height=\"389\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/7-3.png 1011w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/7-3-300x190.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/7-3-768x487.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<h2><\/h2>\n<p><strong>Avg. Disk Queue Length<\/strong><\/p>\n<p>Diske yap\u0131lan I\/O lar i\u00e7erisinden bekleme yapanlar\u0131 g\u00f6sterir. Bu de\u011ferin s\u00fcrekli olarak \u00e7ok \u00e7\u0131kmas\u0131 demek diskte s\u0131k\u0131\u015fma ya\u015fand\u0131\u011f\u0131 anlam\u0131na gelir.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5138\" src=\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/8-3.png\" alt=\"\" width=\"614\" height=\"469\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/8-3.png 789w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/8-3-300x229.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/8-3-768x587.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Avg. Disk Bytes\/Transfer<\/strong><\/p>\n<p>Diske yap\u0131lan okuma ve yazma s\u0131ras\u0131nda i\u015flem g\u00f6ren baytlar\u0131n ortalama miktar\u0131n\u0131 g\u00f6sterir. Bu de\u011ferin y\u00fcksek \u00e7\u0131kmas\u0131 diskin verimli \u00e7al\u0131\u015ft\u0131\u011f\u0131 anlam\u0131na gelir.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5139\" src=\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/9-3.png\" alt=\"\" width=\"614\" height=\"470\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/9-3.png 799w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/9-3-300x229.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/9-3-768x587.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>CPU Bottleneck<\/strong><\/p>\n<p>Sistemdeki yava\u015fl\u0131\u011f\u0131n CPU dan kaynaklan\u0131p kaynaklanmad\u0131\u011f\u0131n\u0131 g\u00f6rmek di\u011fer Bottleneck lere g\u00f6re daha kolayd\u0131r \u00e7\u00fcnk\u00fc genelde s\u0131k\u0131nt\u0131lar Memory ve Disk I\/O darbo\u011fazlar\u0131nda ya\u015fanmaktad\u0131r. Ancak bu 2 sinden emin olunduktan sonra hala daha s\u0131k\u0131nt\u0131 var ve CPU taraf\u0131na bak\u0131lmas\u0131 gerekiyorsa Sistem CPU suna hemen bak\u0131labilir. Sistem CPU su %80 lerde ise bir s\u0131k\u0131nt\u0131 oldu\u011fu anlam\u0131na gelir ancak %50 lerde ise sorunun CPU dan kaynaklanmad\u0131\u011f\u0131n\u0131 belirleyebiliriz.<\/p>\n<ul>\n<li>Processor: % Processor Time<\/li>\n<\/ul>\n<p>Sistem CPU sunun aktif \u00e7al\u0131\u015fma zaman\u0131n\u0131 g\u00f6sterir.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5140\" src=\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/10-1.png\" alt=\"\" width=\"614\" height=\"385\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/10-1.png 983w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/10-1-300x188.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/10-1-768x482.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<p>Server Queue Length (i\u015flemci kuyruk b\u00fcy\u00fckl\u00fc\u011f\u00fc) de\u011feri artmadan server istekleri kar\u015f\u0131layabiliyorsa, yapabildi\u011fi kadar h\u0131zl\u0131 bir \u015fekilde proseslere hizmet veriliyor demektir.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Processor: % Privileged Time<\/strong><\/p>\n<p>SQL Server \u0131n \u00fczerinde \u00e7al\u0131\u015ft\u0131\u011f\u0131 sunucu i\u00e7in ayr\u0131lan CPU zaman\u0131n\u0131 g\u00f6sterir.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5141\" src=\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/11-1.png\" alt=\"\" width=\"614\" height=\"462\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/11-1.png 791w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/11-1-300x226.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/11-1-768x578.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Processor: % User Time<\/strong><\/p>\n<p>CPU nun \u0130\u015fletim sisteminde \u00e7al\u0131\u015fan di\u011fer aktiviteler i\u00e7in harcan\u0131lan zaman\u0131n\u0131 g\u00f6sterir.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5142\" src=\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/12-1.png\" alt=\"\" width=\"614\" height=\"467\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/12-1.png 791w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/12-1-300x228.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/12-1-768x584.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>B\u00f6ylece bu yaz\u0131n\u0131n sonuna gelmi\u015f bulunmaktay\u0131m bir sonraki yaz\u0131da SQL Server Performance Troubleshooting e devam ediyor olaca\u011f\u0131m.<\/p>\n\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\">Oracle Exadata SQL Server Goldengate Weblogic EBS ve Linux konusunda a\u015fa\u011f\u0131daki konularda 7&#215;24 Uzman Dan\u0131\u015fmanlara yada E\u011fitimlere mi\u00a0<\/span><span style=\"color: #ff0000;\">\u0130htiyac\u0131n\u0131z var mehmet.deveci@gridgroup.com.tr adresine mail atarak Bizimle ileti\u015fime ge\u00e7ebilirsiniz.<\/span><\/p>\n<p><span style=\"color: #ff0000;\">&#8211; Oracle Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle Veritaban\u0131 Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Exadata Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Exadata Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; SQL Server Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; SQL Server Veritaban\u0131 Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Goldengate Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Goldengate Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Linux Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Linux Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle EBS Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle EBS Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Weblogic Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Weblogic Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle Veritaban\u0131 E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle VM Server Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle VM Server Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle EPPM Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle EPPM Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle Primavera Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle Primavera Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; SQL Server E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Goldengate E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Exadata E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Linux E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle EBS E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle VM Server E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Weblogic E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle EPPM E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle Primavera E\u011fitimleri<\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhaba Arkada\u015flar, Bu yaz\u0131mda sizlere \u00f6nceki yaz\u0131mda ba\u015flad\u0131\u011f\u0131m SQL Server da Performance Troubleshooting kavram\u0131n\u0131 ve nas\u0131l yap\u0131ld\u0131\u011f\u0131n\u0131n devam\u0131n\u0131 anlat\u0131yor olaca\u011f\u0131m.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19,23],"tags":[457,480,586,1028,1031,1120,1199,1266,1267,1623,1629,1644,1659,1661,1667,1859,1860,1861],"class_list":["post-5132","post","type-post","status-publish","format-standard","","category-sql-server","category-veritabani","tag-database-bakim-ve-destek","tag-dba-danismanlik","tag-exadata-egitim","tag-mehmet-deveci","tag-mehmet-salih-deveci","tag-oracle","tag-oracle-danismanlik","tag-oracle-egitim","tag-oracle-egitimi","tag-sql-server-bakim-destek","tag-sql-server-danismanlik","tag-sql-server-egitim","tag-sql-server-performance-troubleshooting","tag-sql-server-performans-tuning","tag-sql-server-sorun-cozme","tag-veritabani-bakim-ve-destek","tag-veritabani-danismanlik","tag-veritabani-egitim"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=5132"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5132\/revisions"}],"predecessor-version":[{"id":5790,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5132\/revisions\/5790"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=5132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=5132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=5132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}