Memory Darbo\u011faz\u0131<\/strong><\/p>\nSQL Server Instance s\u0131 kapal\u0131 durumda a\u00e7\u0131l\u0131rken set edilen Max ve Min memory parametresine g\u00f6re sunucudan memory alan\u0131 tahsis eder. Default olarak SQL Server Instance s\u0131n\u0131n kulland\u0131\u011f\u0131 bellek alan\u0131 paging yapmamak i\u00e7in s\u00fcrekli olarak b\u00fcy\u00fcr. Sunucuda yap\u0131lan bir i\u015flem i\u00e7in memory alan\u0131 kalmad\u0131\u011f\u0131 takdirde i\u015fletim sistemi SQL Server I uyar\u0131r ve SQL Server ald\u0131\u011f\u0131 fazla memory I release eder.<\/p>\n
Maximum ve minimum memory parametresini a\u015fa\u011f\u0131daki ekrandan ayarlayabiliriz.<\/p>\n
![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/1-3.png\")
<\/p>\n
SQL Server Instancelar\u0131n\u0131n ya\u015fad\u0131\u011f\u0131 darbo\u011fazlar\u0131n genel nedeni Memory nin yetersiz olmas\u0131d\u0131r. Memory yetersiz oldu\u011fu durumda Veritaban\u0131n\u0131n veriyi Fiziksel diskten okumas\u0131 durumuna hard page fault denir.<\/p>\n
<\/p>\n
Sistemdeki Memory Bottleneck olup olmad\u0131\u011f\u0131n\u0131 g\u00f6rmek i\u00e7in a\u015fa\u011f\u0131daki Performance Counter lar incelenmelidir.<\/p>\n
![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/2-2.png\")
<\/p>\n
<\/h2>\n
Memory: Pages\/sec<\/strong><\/p>\n\u2013Memory\u2019 de olmayan ve diskten okunmas\u0131 gereken memory page leri ile diske yaz\u0131lmas\u0131 gereken bellek sayfalar\u0131n\u0131n say\u0131s\u0131n\u0131 g\u00f6sterir.<\/p>\n
Bu de\u011fer Veritaban\u0131 normal \u00e7al\u0131\u015ft\u0131\u011f\u0131 s\u0131rada belirli bir m\u00fcddet takip edilip ortalama bir de\u011fer bulunmal\u0131d\u0131r. Sorun anlar\u0131nda s\u00fcrekli bu de\u011fer y\u00fcksek \u00e7\u0131k\u0131yorsa bu durumda sunucunun fiziksel belle\u011finin boyutunu art\u0131rmak faydal\u0131 olacakt\u0131r.<\/p>\n
![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/3-2.png\")
<\/p>\n
<\/p>\n
Memory: Committed Bytes<\/strong><\/p>\nInstances\u0131n RAM ve Diskte bulunan pagefile.sys alan\u0131ndan kulland\u0131\u011f\u0131 toplam bellek alan\u0131n\u0131 g\u00f6sterir. Instance sa verilen Memory miktar\u0131 yeterli ise bu counter\u00a0 toplam RAM boyutunu a\u015fmayacakt\u0131r. Sistem incelendi\u011finde belle\u011fin yetersiz oldu\u011fu belirlenirse diskteki pagefile.sys dosyas\u0131n\u0131n bulundu\u011fu alan\u0131 kullan\u0131lm\u0131\u015f demektir buda ilgili performance counter de\u011ferinin RAM de\u011ferini a\u015faca\u011f\u0131 anlam\u0131na gelir. B\u00f6yle bir senaryo ya\u015fand\u0131\u011f\u0131nda sunucuya RAM eklemek sistemi rahatlatabilir.<\/p>\n
![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/4-2.png\")
<\/p>\n
<\/p>\n
Memory: Available Bytes<\/strong><\/p>\n\u2013Instance s\u0131n kullanabilece\u011fi \u00a0toplam bellek miktar\u0131n\u0131 g\u00f6sterir. Bu de\u011fer genellikle d\u00fc\u015f\u00fck olarak g\u00f6z\u00fck\u00fcr. Bu counter\u0131n de\u011feri s\u00fcrekli olarak 4 MB\u2019 \u0131n alt\u0131nda ise \u00e7ok fazla sayfalama (paging) i\u015flemi meydana gelir.<\/p>\n
![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/6-2.png\")
<\/p>\n
<\/p>\n
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>\n
Oracle Exadata SQL Server Goldengate Weblogic EBS ve Linux konusunda a\u015fa\u011f\u0131daki konularda 7×24 Uzman Dan\u0131\u015fmanlara yada E\u011fitimlere mi\u00a0<\/span>\u0130htiyac\u0131n\u0131z var mehmet.deveci@gridgroup.com.tr adresine mail atarak Bizimle ileti\u015fime ge\u00e7ebilirsiniz.<\/span><\/p>\n– Oracle Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle Veritaban\u0131 Bak\u0131m ve Destek<\/span>
\n– Exadata Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Exadata Bak\u0131m ve Destek<\/span>
\n– SQL Server Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– SQL Server Veritaban\u0131 Bak\u0131m ve Destek<\/span>
\n– Goldengate Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Goldengate Bak\u0131m ve Destek<\/span>
\n– Linux Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Linux Bak\u0131m ve Destek<\/span>
\n– Oracle EBS Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle EBS Bak\u0131m ve Destek<\/span>
\n– Weblogic Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Weblogic Bak\u0131m ve Destek<\/span>
\n– Oracle Veritaban\u0131 E\u011fitimleri<\/span>
\n– Oracle VM Server Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle VM Server Bak\u0131m ve Destek<\/span>
\n– Oracle EPPM Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle EPPM Bak\u0131m ve Destek<\/span>
\n– Oracle Primavera Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle Primavera Bak\u0131m ve Destek<\/span>
\n– Oracle E\u011fitimleri<\/span>
\n– SQL Server E\u011fitimleri<\/span>
\n– Goldengate E\u011fitimleri<\/span>
\n– Exadata E\u011fitimleri<\/span>
\n– Linux E\u011fitimleri<\/span>
\n– Oracle EBS E\u011fitimleri<\/span>
\n– Oracle VM Server E\u011fitimleri<\/span>
\n– Weblogic E\u011fitimleri<\/span>
\n– Oracle EPPM E\u011fitimleri<\/span>
\n– Oracle Primavera E\u011fitimleri<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"Merhaba Arkada\u015flar, Bu yaz\u0131 dizimde sizlere SQL Server da Performance Troubleshooting kavram\u0131n\u0131 ve nas\u0131l yap\u0131ld\u0131\u011f\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-5124","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\/5124","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=5124"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5124\/revisions"}],"predecessor-version":[{"id":5791,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5124\/revisions\/5791"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=5124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=5124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=5124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/troubleshoot.png\")
<\/p>\n