{"id":10174,"date":"2025-12-02T20:54:08","date_gmt":"2025-12-02T17:54:08","guid":{"rendered":"https:\/\/fevren.com\/en\/?p=10174"},"modified":"2026-11-12T19:52:09","modified_gmt":"2026-11-12T16:52:09","slug":"mssql-veritabani-bakimi-ve-performans-iyilestirme-rehberi","status":"publish","type":"post","link":"https:\/\/fevren.com\/en\/mssql-veritabani-bakimi-ve-performans-iyilestirme-rehberi\/","title":{"rendered":"MSSQL Database Maintenance, Index Optimization &#038; Performance Guide"},"content":{"rendered":"\n<blockquote class=\"wp-block-quote\">\n<p class=\"wp-block-paragraph\"><strong>\u00d6nemli Not:<\/strong> Sunucu ar\u0131zalar\u0131na kar\u015f\u0131 yedekleri, as\u0131l sunucudan farkl\u0131 bir fiziksel s\u00fcr\u00fcc\u00fcye veya a\u011f konumuna <strong>almal\u0131s\u0131n\u0131z<\/strong>.<\/p>\n<\/blockquote>\n\n<h3 class=\"wp-block-heading\">Veritaban\u0131 B\u00fct\u00fcnl\u00fc\u011f\u00fc Kontrol\u00fc (DBCC CHECKDB)<\/h3>\n\n<p class=\"wp-block-paragraph\">Veritaban\u0131ndaki mant\u0131ksal ve fiziksel tutarl\u0131l\u0131\u011f\u0131 kontrol etmek i\u00e7in <code>DBCC CHECKDB<\/code> komutunu <strong>kullan\u0131n<\/strong>. <strong>B\u00f6ylece<\/strong>, veri bozulmalar\u0131n\u0131 erkenden tespit edebilirsiniz.<\/p>\n\n<p class=\"wp-block-paragraph\"><strong>Temel Kullan\u0131m:<\/strong><\/p>\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n<pre class=\"wp-block-code\"><code>DBCC CHECKDB (VeritabaniAdi);\nGO\n<\/code><\/pre>\n\n<p class=\"wp-block-paragraph\"><strong>E\u011fer<\/strong> hatalar tespit ederseniz <code>REPAIR_REBUILD<\/code> veya son \u00e7are olarak <code>REPAIR_ALLOW_DATA_LOSS<\/code> se\u00e7eneklerini <strong>kullanabilirsiniz<\/strong>. <strong>Ancak<\/strong>, onar\u0131m i\u015fleminden \u00f6nce mutlaka yedek <strong>al\u0131n<\/strong>.<\/p>\n\n<h3 class=\"wp-block-heading\">Dizin (Index) Bak\u0131m\u0131<\/h3>\n\n<p class=\"wp-block-paragraph\">Veri ekleme i\u015flemleri zamanla index par\u00e7alanmas\u0131na (fragmentation) neden olur. <strong>Dolay\u0131s\u0131yla<\/strong>, par\u00e7alanma oran\u0131na g\u00f6re \u015fu iki y\u00f6ntemi <strong>uygulay\u0131n<\/strong>:<\/p>\n\n<ol class=\"wp-block-list\" start=\"1\">\n<li><strong>Yeniden D\u00fczenleme (Reorganize):<\/strong> <strong>\u00d6rne\u011fin<\/strong>, d\u00fc\u015f\u00fck par\u00e7alanma (%5-%30 aras\u0131) varsa bunu se\u00e7in. Bu online bir i\u015flemdir.<\/li>\n \n<li><strong>Yeniden Olu\u015fturma (Rebuild):<\/strong> <strong>Oysa<\/strong> y\u00fcksek par\u00e7alanma (%30 \u00fczeri) varsa bu y\u00f6ntemi kullan\u0131n. \u0130ndeksi tamamen ba\u015ftan olu\u015fturur.<\/li>\n<\/ol>\n\n<p class=\"wp-block-paragraph\"><strong>T-SQL ile Index Rebuild \u00d6rne\u011fi:<\/strong><\/p>\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n<pre class=\"wp-block-code\"><code>ALTER INDEX DizinAdi ON TabloAdi REBUILD WITH (FILLFACTOR = 80, ONLINE = ON);\nGO\n<\/code><\/pre>\n\n<h3 class=\"wp-block-heading\">\u0130statistikleri G\u00fcncelleme<\/h3>\n\n<p class=\"wp-block-paragraph\">SQL Server Query Optimizer, sorgu planlar\u0131n\u0131 olu\u015fturmak i\u00e7in istatistikleri kullan\u0131r. <strong>Ne yaz\u0131k ki<\/strong> g\u00fcncel olmayan istatistikler performans kayb\u0131na yol a\u00e7ar. Sistem bunu genellikle otomatik yapar <strong>fakat<\/strong> b\u00fcy\u00fck veri y\u00fcklemelerinden sonra i\u015flemi manuel <strong>tetikleyebilirsiniz<\/strong>:<\/p>\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n<pre class=\"wp-block-code\"><code>EXEC sp_updatestats;\nGO\n<\/code><\/pre>\n\n<h2 class=\"wp-block-heading\">2. Bak\u0131m Planlar\u0131 ve Otomasyon<\/h2>\n\n<p class=\"wp-block-paragraph\">MSSQL, tekrarlayan g\u00f6revleri otomatikle\u015ftirmek i\u00e7in <strong>Maintenance Plans<\/strong> \u00f6zelli\u011fini sunar. <strong>Sonu\u00e7 olarak<\/strong>, SSMS \u00fczerinden \u015fu g\u00f6revleri zamanlayabilirsiniz:<\/p>\n\n<ul class=\"wp-block-list\">\n<li>Veritaban\u0131 Yedekleme<\/li>\n \n<li>B\u00fct\u00fcnl\u00fck Kontrol\u00fc<\/li>\n \n<li>Index Rebuild\/Reorganize<\/li>\n \n<li>Ge\u00e7mi\u015fi Temizleme (Cleanup History)<\/li>\n<\/ul>\n\n<p class=\"wp-block-paragraph\">Disk Alan\u0131 Y\u00f6netimi<\/p>\n\n<p class=\"wp-block-paragraph\">\u00d6ncelikle bilmemizde fayda olan, disk dolulu\u011fu sistemin durmas\u0131na neden olabilir. Bu y\u00fczden, sp_spaceused prosed\u00fcr\u00fc ile alan kullan\u0131m\u0131n\u0131 izleyin. Buna ek olarak, eski yedek dosyalar\u0131n\u0131 &#8220;Maintenance Cleanup Task&#8221; ile otomatik sildirin.<\/p>\n\n<h2 class=\"wp-block-heading\">3. MSSQL Performans \u0130yile\u015ftirme Y\u00f6ntemleri<\/h2>\n\n<p class=\"wp-block-paragraph\">Sistem kaynaklar\u0131n\u0131 verimli kullanmak i\u00e7in a\u015fa\u011f\u0131daki optimizasyon y\u00f6ntemlerini <strong>uygulay\u0131n<\/strong>.<\/p>\n\n<h3 class=\"wp-block-heading\">Dizin (Index) Optimizasyonu<\/h3>\n\n<p class=\"wp-block-paragraph\"><strong>\u015e\u00fcphesiz<\/strong>, do\u011fru dizinleme performans\u0131 en \u00e7ok art\u0131ran fakt\u00f6rd\u00fcr.<\/p>\n\n<ul class=\"wp-block-list\">\n<li><strong>Clustered Index:<\/strong> Verinin fiziksel s\u0131ralamas\u0131n\u0131 belirler.<\/li>\n \n<li><strong>Non-Clustered Index:<\/strong> Veriye i\u015faret eden ayr\u0131 yap\u0131lard\u0131r.<\/li>\n \n<li><strong>Kullan\u0131lmayan Indexler:<\/strong> <code>sys.dm_db_index_usage_stats<\/code> DMV&#8217;si ile tespit edip <strong>silin<\/strong>. <strong>\u00c7\u00fcnk\u00fc<\/strong> gereksiz indexler yazma performans\u0131n\u0131 d\u00fc\u015f\u00fcr\u00fcr.<\/li>\n<\/ul>\n\n<h3 class=\"wp-block-heading\">Sorgu Optimizasyonu \u0130pu\u00e7lar\u0131<\/h3>\n\n<p class=\"wp-block-paragraph\">K\u00f6t\u00fc yaz\u0131lm\u0131\u015f sorgular sistemi kilitler. <strong>\u0130\u015fte<\/strong> dikkat etmeniz gerekenler:<\/p>\n\n<ul class=\"wp-block-list\">\n<li><code>SELECT *<\/code> yerine <strong>yaln\u0131zca<\/strong> gerekli s\u00fctunlar\u0131 \u00e7ekin.<\/li>\n \n<li><code>WHERE<\/code> blo\u011fu ile veriyi kayna\u011f\u0131nda <strong>filtreleyin<\/strong>.<\/li>\n \n<li>B\u00fcy\u00fck tablolarda <code>EXISTS<\/code> operat\u00f6r\u00fcn\u00fc <code>COUNT(*)<\/code> yerine <strong>tercih edin<\/strong>.<\/li>\n \n<li><strong>Ayr\u0131ca<\/strong>, Execution Plan (Y\u00fcr\u00fctme Plan\u0131) analiz ederek darbo\u011fazlar\u0131 <strong>tespit edin<\/strong>.<\/li>\n<\/ul>\n\n<h3 class=\"wp-block-heading\">SQL Server Yap\u0131land\u0131rma Ayarlar\u0131<\/h3>\n\n<p class=\"wp-block-paragraph\">Donan\u0131m kaynaklar\u0131n\u0131 do\u011fru kullanmak i\u00e7in sunucu ayarlar\u0131 kritik \u00f6neme sahiptir:<\/p>\n\n<ol class=\"wp-block-list\" start=\"1\">\n<li><strong>Max Server Memory:<\/strong> \u0130\u015fletim sistemine RAM b\u0131rakacak \u015fekilde <strong>s\u0131n\u0131rland\u0131r\u0131n<\/strong>.<\/li>\n \n<li><strong>MAXDOP (Max Degree of Parallelism):<\/strong> <strong>Genellikle<\/strong> fiziksel \u00e7ekirdek say\u0131s\u0131n\u0131n yar\u0131s\u0131 veya daha az\u0131n\u0131 <strong>kullan\u0131n<\/strong>.<\/li>\n \n<li><strong>Tempdb Ayarlar\u0131:<\/strong> Tempdb dosyalar\u0131n\u0131 i\u015flemci \u00e7ekirdek say\u0131s\u0131na g\u00f6re <strong>\u00e7o\u011falt\u0131n<\/strong> ve h\u0131zl\u0131 (SSD) disklerde <strong>tutun<\/strong>.<\/li>\n<\/ol>\n\n<h2 class=\"wp-block-heading\">\u00d6zet Tablolar<\/h2>\n\n<h3 class=\"wp-block-heading\">Tablo 1: \u00d6nerilen Bak\u0131m S\u0131kl\u0131\u011f\u0131<\/h3>\n\n<figure class=\"wp-block-table\">\n<table class=\"has-fixed-layout\">\n<thead>\n<tr>\n<td><strong>G\u00f6rev Ad\u0131<\/strong><\/td>\n<td><strong>\u00d6nerilen S\u0131kl\u0131k<\/strong><\/td>\n<td><strong>Notlar<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Tam Yedekleme<\/strong><\/td>\n<td>Haftal\u0131k<\/td>\n<td>Yo\u011fun olmayan saatlerde <strong>yap\u0131n<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Fark Yedekleme<\/strong><\/td>\n<td>G\u00fcnl\u00fck<\/td>\n<td>Tam yedekten sonraki de\u011fi\u015fimleri <strong>al\u0131r<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Log Yedekleme<\/strong><\/td>\n<td>Saatlik<\/td>\n<td>Tam kurtarma modelinde <strong>kullan\u0131n<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td><strong>B\u00fct\u00fcnl\u00fck Kontrol\u00fc<\/strong><\/td>\n<td>Haftal\u0131k<\/td>\n<td>DBCC CHECKDB i\u015flemini <strong>\u00e7al\u0131\u015ft\u0131r\u0131n<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Index Rebuild<\/strong><\/td>\n<td>Ayl\u0131k<\/td>\n<td>Par\u00e7alanma y\u00fcksekse <strong>uygulay\u0131n<\/strong>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n\n<h3 class=\"wp-block-heading\">Tablo 2: Performans \u0130zleme Ara\u00e7lar\u0131<\/h3>\n\n<figure class=\"wp-block-table\">\n<table class=\"has-fixed-layout\">\n<thead>\n<tr>\n<td><strong>Ara\u00e7 Ad\u0131<\/strong><\/td>\n<td><strong>Kullan\u0131m Amac\u0131<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Activity Monitor<\/strong><\/td>\n<td>Anl\u0131k kilitlenmeler ve kaynak kullan\u0131m\u0131n\u0131 <strong>g\u00f6sterir<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Performance Monitor<\/strong><\/td>\n<td>CPU, RAM ve Disk I\/O saya\u00e7lar\u0131n\u0131 <strong>sunar<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Query Store<\/strong><\/td>\n<td>Sorgu performans ge\u00e7mi\u015fini <strong>analiz eder<\/strong>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n\n<h2 class=\"wp-block-heading\">Sonu\u00e7<\/h2>\n\n<p class=\"wp-block-paragraph\"><strong>\u00d6zetle<\/strong>, MSSQL veritabanlar\u0131n\u0131n performans\u0131; d\u00fczenli bak\u0131m ve do\u011fru donan\u0131m yap\u0131land\u0131rmas\u0131 ile sa\u011flan\u0131r. <strong>Son olarak<\/strong>, bu rehberdeki ad\u0131mlar\u0131 uygulayarak sisteminizin kararl\u0131 \u00e7al\u0131\u015fmas\u0131n\u0131 garanti alt\u0131na <strong>alabilirsiniz<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<!-- \/wp:post-content --><!-- wp:post-content --><!-- wp:heading {\"level\":1} -->\n<h1 class=\"wp-block-heading\"><strong>Giri\u015f<\/strong><\/h1>\n<!-- \/wp:heading --><!-- wp:paragraph -->\n<p>MSSQL veritabanlar\u0131n\u0131n s\u00fcreklili\u011fi, i\u015f operasyonlar\u0131n\u0131z\u0131n temelini olu\u015fturur. <strong>Bu nedenle<\/strong>, veritaban\u0131 bak\u0131m\u0131; veri kayb\u0131n\u0131 \u00f6nleme ve sistem kararl\u0131l\u0131\u011f\u0131n\u0131 sa\u011flama konusunda kritik bir rol oynar. <strong>Ayr\u0131ca<\/strong>, d\u00fczenli bak\u0131m yaparak donan\u0131m ar\u0131zalar\u0131 veya yaz\u0131l\u0131m hatalar\u0131 sonucu olu\u015fabilecek veri kay\u0131plar\u0131n\u0131n \u00f6n\u00fcne ge\u00e7ebilirsiniz.<\/p>\n<!-- \/wp:paragraph --><!-- wp:paragraph -->\n<p>Performans iyile\u015ftirmeleri ise kullan\u0131c\u0131 deneyimini do\u011frudan etkiler. <strong>\u00c7\u00fcnk\u00fc<\/strong> uygulamalar\u0131n h\u0131zl\u0131 yan\u0131t vermesi, verimlili\u011fi art\u0131r\u0131r. <strong>Bu rehberde<\/strong>; yedekleme, b\u00fct\u00fcnl\u00fck kontrolleri ve performans optimizasyonu konular\u0131n\u0131, siz IT profesyonelleri i\u00e7in detayland\u0131rd\u0131k.<\/p>\n<!-- \/wp:paragraph --><!-- wp:heading -->\n<h2 class=\"wp-block-heading\">1. MSSQL Veritaban\u0131 Bak\u0131m\u0131<\/h2>\n<!-- \/wp:heading --><!-- wp:paragraph -->\n<p>Veritaban\u0131 bak\u0131m\u0131, MSSQL ortam\u0131n\u0131n sa\u011fl\u0131kl\u0131 \u00e7al\u0131\u015fmas\u0131 i\u00e7in d\u00fczenli yapman\u0131z gereken g\u00f6revler b\u00fct\u00fcn\u00fcd\u00fcr. <strong>\u0130lk olarak<\/strong>, temel bak\u0131m ad\u0131mlar\u0131n\u0131 inceleyelim:<\/p>\n<!-- \/wp:paragraph --><!-- wp:heading {\"level\":3} -->\n<h3 class=\"wp-block-heading\">Veritaban\u0131 Yedekleme ve Geri Y\u00fckleme (Backup &amp; Restore)<\/h3>\n<!-- \/wp:heading --><!-- wp:paragraph -->\n<p>Veri kayb\u0131n\u0131 \u00f6nlemek istiyorsan\u0131z, en temel ad\u0131m yedeklemedir. <strong>\u00d6zellikle<\/strong> MSSQL size \u00fc\u00e7 ana yedekleme t\u00fcr\u00fc sunar:<\/p>\n<!-- \/wp:paragraph --><!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li><strong>Tam Yedekleme (Full Backup):<\/strong> Veritaban\u0131n\u0131n eksiksiz bir kopyas\u0131n\u0131 olu\u015fturur.<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li><strong>Fark Yedekleme (Differential Backup):<\/strong> <strong>Sadece<\/strong> son tam yedeklemeden sonraki de\u011fi\u015fiklikleri i\u00e7erir.<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li><strong>\u0130\u015flem G\u00fcnl\u00fc\u011f\u00fc Yede\u011fi (Transaction Log Backup):<\/strong> Veritaban\u0131n\u0131 belirli bir ana (point-in-time) d\u00f6nd\u00fcrmenizi sa\u011flar.<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list --><!-- wp:paragraph -->\n<p><strong>T-SQL ile Tam Yedekleme \u00d6rne\u011fi:<\/strong><\/p>\n<!-- \/wp:paragraph --><!-- wp:paragraph -->\n<p>BACKUP DATABASE VeritabaniAdi<br \/>TO DISK = &#8216;YedeklemeDosyasiYolu\\VeritabaniAdi.bak&#8217;<br \/>WITH FORMAT,<br \/>MEDIANAME = &#8216;VeritabaniYedekleri&#8217;,<br \/>NAME = &#8216;Tam Yedekleme&#8217;;<br \/>GO<\/p>\n<!-- \/wp:paragraph --><!-- wp:quote -->\n<blockquote class=\"wp-block-quote\"><!-- wp:paragraph -->\n<p><strong>\u00d6nemli Not:<\/strong> Sunucu ar\u0131zalar\u0131na kar\u015f\u0131 yedekleri, as\u0131l sunucudan farkl\u0131 bir fiziksel s\u00fcr\u00fcc\u00fcye veya a\u011f konumuna <strong>almal\u0131s\u0131n\u0131z<\/strong>.<\/p>\n<\/blockquote>\n<!-- wp:heading {\"level\":3} -->\n<h3 class=\"wp-block-heading\">Veritaban\u0131 B\u00fct\u00fcnl\u00fc\u011f\u00fc Kontrol\u00fc (DBCC CHECKDB)<\/h3>\n<!-- \/wp:heading --><!-- wp:paragraph -->\n<p>Veritaban\u0131ndaki mant\u0131ksal ve fiziksel tutarl\u0131l\u0131\u011f\u0131 kontrol etmek i\u00e7in <code>DBCC CHECKDB<\/code> komutunu <strong>kullan\u0131n<\/strong>. <strong>B\u00f6ylece<\/strong>, veri bozulmalar\u0131n\u0131 erkenden tespit edebilirsiniz.<\/p>\n<!-- \/wp:paragraph --><!-- wp:paragraph -->\n<p><strong>Temel Kullan\u0131m:<\/strong><\/p>\n<!-- \/wp:paragraph --><!-- wp:paragraph -->\n<p>SQL<\/p>\n<!-- \/wp:paragraph --><!-- wp:code -->\n<pre class=\"wp-block-code\"><code>DBCC CHECKDB (VeritabaniAdi);\nGO\n<\/code><\/pre>\n<!-- \/wp:code --><!-- wp:paragraph -->\n<p><strong>E\u011fer<\/strong> hatalar tespit ederseniz <code>REPAIR_REBUILD<\/code> veya son \u00e7are olarak <code>REPAIR_ALLOW_DATA_LOSS<\/code> se\u00e7eneklerini <strong>kullanabilirsiniz<\/strong>. <strong>Ancak<\/strong>, onar\u0131m i\u015fleminden \u00f6nce mutlaka yedek <strong>al\u0131n<\/strong>.<\/p>\n<!-- \/wp:paragraph --><!-- wp:heading {\"level\":3} -->\n<h3 class=\"wp-block-heading\">Dizin (Index) Bak\u0131m\u0131<\/h3>\n<!-- \/wp:heading --><!-- wp:paragraph -->\n<p>Veri ekleme i\u015flemleri zamanla index par\u00e7alanmas\u0131na (fragmentation) neden olur. <strong>Dolay\u0131s\u0131yla<\/strong>, par\u00e7alanma oran\u0131na g\u00f6re \u015fu iki y\u00f6ntemi <strong>uygulay\u0131n<\/strong>:<\/p>\n<!-- \/wp:paragraph --><!-- wp:list {\"ordered\":true,\"start\":1} -->\n<ol class=\"wp-block-list\" start=\"1\"><!-- wp:list-item -->\n<li><strong>Yeniden D\u00fczenleme (Reorganize):<\/strong> <strong>\u00d6rne\u011fin<\/strong>, d\u00fc\u015f\u00fck par\u00e7alanma (%5-%30 aras\u0131) varsa bunu se\u00e7in. Bu online bir i\u015flemdir.<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li><strong>Yeniden Olu\u015fturma (Rebuild):<\/strong> <strong>Oysa<\/strong> y\u00fcksek par\u00e7alanma (%30 \u00fczeri) varsa bu y\u00f6ntemi kullan\u0131n. \u0130ndeksi tamamen ba\u015ftan olu\u015fturur.<\/li>\n<!-- \/wp:list-item --><\/ol>\n<!-- \/wp:list --><!-- wp:paragraph -->\n<p><strong>T-SQL ile Index Rebuild \u00d6rne\u011fi:<\/strong><\/p>\n<!-- \/wp:paragraph --><!-- wp:paragraph -->\n<p>SQL<\/p>\n<!-- \/wp:paragraph --><!-- wp:code -->\n<pre class=\"wp-block-code\"><code>ALTER INDEX DizinAdi ON TabloAdi REBUILD WITH (FILLFACTOR = 80, ONLINE = ON);\nGO\n<\/code><\/pre>\n<!-- \/wp:code --><!-- wp:heading {\"level\":3} -->\n<h3 class=\"wp-block-heading\">\u0130statistikleri G\u00fcncelleme<\/h3>\n<!-- \/wp:heading --><!-- wp:paragraph -->\n<p>SQL Server Query Optimizer, sorgu planlar\u0131n\u0131 olu\u015fturmak i\u00e7in istatistikleri kullan\u0131r. <strong>Ne yaz\u0131k ki<\/strong> g\u00fcncel olmayan istatistikler performans kayb\u0131na yol a\u00e7ar. Sistem bunu genellikle otomatik yapar <strong>fakat<\/strong> b\u00fcy\u00fck veri y\u00fcklemelerinden sonra i\u015flemi manuel <strong>tetikleyebilirsiniz<\/strong>:<\/p>\n<!-- \/wp:paragraph --><!-- wp:paragraph -->\n<p>SQL<\/p>\n<!-- \/wp:paragraph --><!-- wp:code -->\n<pre class=\"wp-block-code\"><code>EXEC sp_updatestats;\nGO\n<\/code><\/pre>\n<!-- \/wp:code --><!-- wp:heading -->\n<h2 class=\"wp-block-heading\">2. Bak\u0131m Planlar\u0131 ve Otomasyon<\/h2>\n<!-- \/wp:heading --><!-- wp:paragraph -->\n<p>MSSQL, tekrarlayan g\u00f6revleri otomatikle\u015ftirmek i\u00e7in <strong>Maintenance Plans<\/strong> \u00f6zelli\u011fini sunar. <strong>Sonu\u00e7 olarak<\/strong>, SSMS \u00fczerinden \u015fu g\u00f6revleri zamanlayabilirsiniz:<\/p>\n<!-- \/wp:paragraph --><!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li>Veritaban\u0131 Yedekleme<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li>B\u00fct\u00fcnl\u00fck Kontrol\u00fc<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li>Index Rebuild\/Reorganize<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li>Ge\u00e7mi\u015fi Temizleme (Cleanup History)<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list --><!-- wp:paragraph -->\n<p>Disk Alan\u0131 Y\u00f6netimi<\/p>\n<!-- \/wp:paragraph --><!-- wp:paragraph -->\n<p>\u00d6ncelikle bilmemizde fayda olan, disk dolulu\u011fu sistemin durmas\u0131na neden olabilir. Bu y\u00fczden, sp_spaceused prosed\u00fcr\u00fc ile alan kullan\u0131m\u0131n\u0131 izleyin. Buna ek olarak, eski yedek dosyalar\u0131n\u0131 &#8220;Maintenance Cleanup Task&#8221; ile otomatik sildirin.<\/p>\n<!-- \/wp:paragraph --><!-- wp:heading -->\n<h2 class=\"wp-block-heading\">3. MSSQL Performans \u0130yile\u015ftirme Y\u00f6ntemleri<\/h2>\n<!-- \/wp:heading --><!-- wp:paragraph -->\n<p>Sistem kaynaklar\u0131n\u0131 verimli kullanmak i\u00e7in a\u015fa\u011f\u0131daki optimizasyon y\u00f6ntemlerini <strong>uygulay\u0131n<\/strong>.<\/p>\n<!-- \/wp:paragraph --><!-- wp:heading {\"level\":3} -->\n<h3 class=\"wp-block-heading\">Dizin (Index) Optimizasyonu<\/h3>\n<!-- \/wp:heading --><!-- wp:paragraph -->\n<p><strong>\u015e\u00fcphesiz<\/strong>, do\u011fru dizinleme performans\u0131 en \u00e7ok art\u0131ran fakt\u00f6rd\u00fcr.<\/p>\n<!-- \/wp:paragraph --><!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li><strong>Clustered Index:<\/strong> Verinin fiziksel s\u0131ralamas\u0131n\u0131 belirler.<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li><strong>Non-Clustered Index:<\/strong> Veriye i\u015faret eden ayr\u0131 yap\u0131lard\u0131r.<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li><strong>Kullan\u0131lmayan Indexler:<\/strong> <code>sys.dm_db_index_usage_stats<\/code> DMV&#8217;si ile tespit edip <strong>silin<\/strong>. <strong>\u00c7\u00fcnk\u00fc<\/strong> gereksiz indexler yazma performans\u0131n\u0131 d\u00fc\u015f\u00fcr\u00fcr.<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list --><!-- wp:heading {\"level\":3} -->\n<h3 class=\"wp-block-heading\">Sorgu Optimizasyonu \u0130pu\u00e7lar\u0131<\/h3>\n<!-- \/wp:heading --><!-- wp:paragraph -->\n<p>K\u00f6t\u00fc yaz\u0131lm\u0131\u015f sorgular sistemi kilitler. <strong>\u0130\u015fte<\/strong> dikkat etmeniz gerekenler:<\/p>\n<!-- \/wp:paragraph --><!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li><code>SELECT *<\/code> yerine <strong>yaln\u0131zca<\/strong> gerekli s\u00fctunlar\u0131 \u00e7ekin.<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li><code>WHERE<\/code> blo\u011fu ile veriyi kayna\u011f\u0131nda <strong>filtreleyin<\/strong>.<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li>B\u00fcy\u00fck tablolarda <code>EXISTS<\/code> operat\u00f6r\u00fcn\u00fc <code>COUNT(*)<\/code> yerine <strong>tercih edin<\/strong>.<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li><strong>Ayr\u0131ca<\/strong>, Execution Plan (Y\u00fcr\u00fctme Plan\u0131) analiz ederek darbo\u011fazlar\u0131 <strong>tespit edin<\/strong>.<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list --><!-- wp:heading {\"level\":3} -->\n<h3 class=\"wp-block-heading\">SQL Server Yap\u0131land\u0131rma Ayarlar\u0131<\/h3>\n<!-- \/wp:heading --><!-- wp:paragraph -->\n<p>Donan\u0131m kaynaklar\u0131n\u0131 do\u011fru kullanmak i\u00e7in sunucu ayarlar\u0131 kritik \u00f6neme sahiptir:<\/p>\n<!-- \/wp:paragraph --><!-- wp:list {\"ordered\":true,\"start\":1} -->\n<ol class=\"wp-block-list\" start=\"1\"><!-- wp:list-item -->\n<li><strong>Max Server Memory:<\/strong> \u0130\u015fletim sistemine RAM b\u0131rakacak \u015fekilde <strong>s\u0131n\u0131rland\u0131r\u0131n<\/strong>.<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li><strong>MAXDOP (Max Degree of Parallelism):<\/strong> <strong>Genellikle<\/strong> fiziksel \u00e7ekirdek say\u0131s\u0131n\u0131n yar\u0131s\u0131 veya daha az\u0131n\u0131 <strong>kullan\u0131n<\/strong>.<\/li>\n<!-- \/wp:list-item --> <!-- wp:list-item -->\n<li><strong>Tempdb Ayarlar\u0131:<\/strong> Tempdb dosyalar\u0131n\u0131 i\u015flemci \u00e7ekirdek say\u0131s\u0131na g\u00f6re <strong>\u00e7o\u011falt\u0131n<\/strong> ve h\u0131zl\u0131 (SSD) disklerde <strong>tutun<\/strong>.<\/li>\n<!-- \/wp:list-item --><\/ol>\n<!-- \/wp:list --><!-- wp:heading -->\n<h2 class=\"wp-block-heading\">\u00d6zet Tablolar<\/h2>\n<!-- \/wp:heading --><!-- wp:heading {\"level\":3} -->\n<h3 class=\"wp-block-heading\">Tablo 1: \u00d6nerilen Bak\u0131m S\u0131kl\u0131\u011f\u0131<\/h3>\n<!-- \/wp:heading --><!-- wp:table -->\n<figure class=\"wp-block-table\">\n<table class=\"has-fixed-layout\">\n<thead>\n<tr>\n<td><strong>G\u00f6rev Ad\u0131<\/strong><\/td>\n<td><strong>\u00d6nerilen S\u0131kl\u0131k<\/strong><\/td>\n<td><strong>Notlar<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Tam Yedekleme<\/strong><\/td>\n<td>Haftal\u0131k<\/td>\n<td>Yo\u011fun olmayan saatlerde <strong>yap\u0131n<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Fark Yedekleme<\/strong><\/td>\n<td>G\u00fcnl\u00fck<\/td>\n<td>Tam yedekten sonraki de\u011fi\u015fimleri <strong>al\u0131r<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Log Yedekleme<\/strong><\/td>\n<td>Saatlik<\/td>\n<td>Tam kurtarma modelinde <strong>kullan\u0131n<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td><strong>B\u00fct\u00fcnl\u00fck Kontrol\u00fc<\/strong><\/td>\n<td>Haftal\u0131k<\/td>\n<td>DBCC CHECKDB i\u015flemini <strong>\u00e7al\u0131\u015ft\u0131r\u0131n<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Index Rebuild<\/strong><\/td>\n<td>Ayl\u0131k<\/td>\n<td>Par\u00e7alanma y\u00fcksekse <strong>uygulay\u0131n<\/strong>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<!-- \/wp:table --><!-- wp:heading {\"level\":3} -->\n<h3 class=\"wp-block-heading\">Tablo 2: Performans \u0130zleme Ara\u00e7lar\u0131<\/h3>\n<!-- \/wp:heading --><!-- wp:table -->\n<figure class=\"wp-block-table\">\n<table class=\"has-fixed-layout\">\n<thead>\n<tr>\n<td><strong>Ara\u00e7 Ad\u0131<\/strong><\/td>\n<td><strong>Kullan\u0131m Amac\u0131<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Activity Monitor<\/strong><\/td>\n<td>Anl\u0131k kilitlenmeler ve kaynak kullan\u0131m\u0131n\u0131 <strong>g\u00f6sterir<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Performance Monitor<\/strong><\/td>\n<td>CPU, RAM ve Disk I\/O saya\u00e7lar\u0131n\u0131 <strong>sunar<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Query Store<\/strong><\/td>\n<td>Sorgu performans ge\u00e7mi\u015fini <strong>analiz eder<\/strong>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<!-- \/wp:table --><!-- wp:heading -->\n<h2 class=\"wp-block-heading\">Sonu\u00e7<\/h2>\n<!-- \/wp:heading --><!-- wp:paragraph -->\n<p><strong>\u00d6zetle<\/strong>, MSSQL veritabanlar\u0131n\u0131n performans\u0131; d\u00fczenli bak\u0131m ve do\u011fru donan\u0131m yap\u0131land\u0131rmas\u0131 ile sa\u011flan\u0131r. <strong>Son olarak<\/strong>, bu rehberdeki ad\u0131mlar\u0131 uygulayarak sisteminizin kararl\u0131 \u00e7al\u0131\u015fmas\u0131n\u0131 garanti alt\u0131na <strong>alabilirsiniz<\/strong>.<\/p>\n<!-- \/wp:paragraph --><!-- wp:paragraph \/-->\n\n<!-- wp:paragraph -->\n<p><\/p>\n<!-- \/wp:paragraph --><!-- \/wp:paragraph --><!-- \/wp:quote -->","protected":false},"excerpt":{"rendered":"<p>Giri\u015f MSSQL veritabanlar\u0131n\u0131n s\u00fcreklili\u011fi, i\u015f operasyonlar\u0131n\u0131z\u0131n temelini olu\u015fturur. Bu nedenle, veritaban\u0131 bak\u0131m\u0131; veri kayb\u0131n\u0131 \u00f6nleme ve sistem kararl\u0131l\u0131\u011f\u0131n\u0131 sa\u011flama konusunda kritik bir rol oynar. Ayr\u0131ca, d\u00fczenli bak\u0131m yaparak donan\u0131m ar\u0131zalar\u0131 veya yaz\u0131l\u0131m hatalar\u0131 sonucu olu\u015fabilecek veri kay\u0131plar\u0131n\u0131n \u00f6n\u00fcne ge\u00e7ebilirsiniz. Performans iyile\u015ftirmeleri ise kullan\u0131c\u0131 deneyimini do\u011frudan etkiler. \u00c7\u00fcnk\u00fc uygulamalar\u0131n h\u0131zl\u0131 yan\u0131t vermesi, verimlili\u011fi art\u0131r\u0131r. Bu rehberde; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":10175,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-10174","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-itbilgibankasi"],"_links":{"self":[{"href":"https:\/\/fevren.com\/en\/wp-json\/wp\/v2\/posts\/10174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fevren.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fevren.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fevren.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fevren.com\/en\/wp-json\/wp\/v2\/comments?post=10174"}],"version-history":[{"count":1,"href":"https:\/\/fevren.com\/en\/wp-json\/wp\/v2\/posts\/10174\/revisions"}],"predecessor-version":[{"id":10410,"href":"https:\/\/fevren.com\/en\/wp-json\/wp\/v2\/posts\/10174\/revisions\/10410"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fevren.com\/en\/wp-json\/wp\/v2\/media\/10175"}],"wp:attachment":[{"href":"https:\/\/fevren.com\/en\/wp-json\/wp\/v2\/media?parent=10174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fevren.com\/en\/wp-json\/wp\/v2\/categories?post=10174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fevren.com\/en\/wp-json\/wp\/v2\/tags?post=10174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}