{"id":37535,"date":"2026-01-08T01:30:41","date_gmt":"2026-01-07T22:30:41","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/"},"modified":"2026-01-08T01:30:41","modified_gmt":"2026-01-07T22:30:41","slug":"mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/","title":{"rendered":"MSSQL&#8217;de Kaynak Havuzlar\u0131n\u0131 Olu\u015fturma ve Kontrol Etme: Resource Governor ile Performans Y\u00f6netimi"},"content":{"rendered":"<h2>MSSQL&#8217;de Kaynak Havuzlar\u0131n\u0131 Olu\u015fturma ve Kontrol Etme: Resource Governor ile Performans Y\u00f6netimi<\/h2>\n<p>Modern veritaban\u0131 sistemleri, farkl\u0131 \u00f6nceliklere ve kaynak ihtiya\u00e7lar\u0131na sahip \u00e7ok say\u0131da i\u015f y\u00fck\u00fcn\u00fc ayn\u0131 anda bar\u0131nd\u0131rmak zorundad\u0131r. OLTP (Online Transaction Processing) sistemleri d\u00fc\u015f\u00fck gecikme s\u00fcresi isterken, raporlama veya veri analizi (OLAP) i\u015f y\u00fckleri yo\u011fun CPU ve bellek t\u00fcketebilir. Bu farkl\u0131 i\u015f y\u00fcklerinin ayn\u0131 sunucuda bir arada \u00e7al\u0131\u015fmas\u0131, kaynak \u00e7eki\u015fmesine ve performans darbo\u011fazlar\u0131na yol a\u00e7abilir. SQL Server Resource Governor, bu t\u00fcr senaryolarda sunucu kaynaklar\u0131n\u0131n (CPU, bellek, I\/O) farkl\u0131 i\u015f y\u00fckleri aras\u0131nda adil ve kontroll\u00fc bir \u015fekilde da\u011f\u0131t\u0131lmas\u0131n\u0131 sa\u011flayan g\u00fc\u00e7l\u00fc bir \u00f6zelliktir. Bu makalede, Resource Governor&#8217;\u0131n ne oldu\u011funu, nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 ve SQL Server ortam\u0131n\u0131zda kaynak havuzlar\u0131n\u0131 nas\u0131l olu\u015fturup y\u00f6netece\u011finizi detayl\u0131 bir \u015fekilde inceleyece\u011fiz.<\/p>\n<h3>Resource Governor Nedir ve Neden \u00d6nemlidir?<\/h3>\n<p>SQL Server Resource Governor, SQL Server 2008 ile tan\u0131t\u0131lm\u0131\u015f ve sunucu kaynaklar\u0131n\u0131n (CPU, fiziksel G\/\u00c7 ve bellek) farkl\u0131 i\u015f y\u00fckleri aras\u0131nda y\u00f6netilmesini sa\u011flayan bir \u00f6zelliktir. Temel amac\u0131, \u00e7e\u015fitli uygulamalar\u0131n veya kullan\u0131c\u0131 gruplar\u0131n\u0131n sunucu \u00fczerindeki etkisini kontrol ederek, kritik i\u015f y\u00fcklerinin performans\u0131n\u0131 garanti alt\u0131na almak ve kaynaklar\u0131n k\u00f6t\u00fcye kullan\u0131lmas\u0131n\u0131 engellemektir. \u00d6zellikle \u00e7ok kirac\u0131l\u0131 (multi-tenant) ortamlar veya ayn\u0131 sunucuda farkl\u0131 \u00f6nceliklere sahip uygulamalar\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131 durumlar i\u00e7in hayati \u00f6neme sahiptir.<\/p>\n<h4>Temel Tan\u0131mlar ve Bile\u015fenler<\/h4>\n<ul>\n<li><strong>Kaynak Havuzlar\u0131 (Resource Pools):<\/strong> Sunucu kaynaklar\u0131n\u0131n (CPU, bellek, I\/O) mant\u0131ksal b\u00f6l\u00fcmleridir. Her havuz, belirli bir minimum ve maksimum kaynak y\u00fczdesi ile yap\u0131land\u0131r\u0131l\u0131r.<\/li>\n<li><strong>\u0130\u015f Y\u00fck\u00fc Gruplar\u0131 (Workload Groups):<\/strong> Benzer \u00f6zelliklere sahip oturumlar\u0131n veya isteklerin bir araya getirildi\u011fi mant\u0131ksal gruplard\u0131r. Her i\u015f y\u00fck\u00fc grubu, bir kaynak havuzuna atan\u0131r.<\/li>\n<li><strong>S\u0131n\u0131fland\u0131rma Fonksiyonu (Classifier Function):<\/strong> Gelen her yeni ba\u011flant\u0131y\u0131 veya iste\u011fi belirli bir i\u015f y\u00fck\u00fc grubuna y\u00f6nlendirmek i\u00e7in kullan\u0131lan bir kullan\u0131c\u0131 tan\u0131ml\u0131 fonksiyondur. Bu fonksiyon, kullan\u0131c\u0131 ad\u0131, uygulama ad\u0131, IP adresi gibi \u00e7e\u015fitli kriterlere g\u00f6re s\u0131n\u0131fland\u0131rma yapabilir.<\/li>\n<\/ul>\n<h4>Resource Governor&#8217;\u0131n Amac\u0131 ve Avantajlar\u0131<\/h4>\n<p>Resource Governor&#8217;\u0131n temel amac\u0131, SQL Server&#8217;\u0131n kaynaklar\u0131n\u0131 optimize ederek performans istikrar\u0131 sa\u011flamakt\u0131r. Sa\u011flad\u0131\u011f\u0131 avantajlar \u015funlard\u0131r:<\/p>\n<ul>\n<li><strong>Performans Garantisi:<\/strong> Kritik i\u015f y\u00fckleri i\u00e7in belirli bir minimum kaynak seviyesi garanti ederek performans dalgalanmalar\u0131n\u0131 \u00f6nler.<\/li>\n<li><strong>Kaynak Kontrol\u00fc:<\/strong> Kaynaklar\u0131 a\u015f\u0131r\u0131 t\u00fcketen sorgular\u0131n veya uygulamalar\u0131n di\u011fer i\u015f y\u00fcklerini olumsuz etkilemesini engeller.<\/li>\n<li><strong>\u00d6ng\u00f6r\u00fclebilirlik:<\/strong> Kaynak da\u011f\u0131t\u0131m\u0131n\u0131 \u00f6ng\u00f6r\u00fclebilir hale getirerek daha tutarl\u0131 bir performans deneyimi sunar.<\/li>\n<li><strong>\u0130zolasyon:<\/strong> Farkl\u0131 i\u015f y\u00fcklerini mant\u0131ksal olarak izole ederek, birinin di\u011ferini etkileme riskini azalt\u0131r.<\/li>\n<\/ul>\n<h3>Resource Governor Bile\u015fenleri: Havuzlar, Gruplar ve S\u0131n\u0131fland\u0131rma<\/h3>\n<p>Resource Governor&#8217;\u0131n etkin bir \u015fekilde \u00e7al\u0131\u015fmas\u0131 i\u00e7in \u00fc\u00e7 ana bile\u015fenin do\u011fru bir \u015fekilde anla\u015f\u0131lmas\u0131 ve yap\u0131land\u0131r\u0131lmas\u0131 gerekmektedir. Bu bile\u015fenler, sunucu kaynaklar\u0131n\u0131n nas\u0131l ayr\u0131laca\u011f\u0131n\u0131, i\u015f y\u00fcklerinin nas\u0131l grupland\u0131r\u0131laca\u011f\u0131n\u0131 ve hangi i\u015f y\u00fck\u00fcn\u00fcn hangi kaynak havuzunu kullanaca\u011f\u0131n\u0131 belirler.<\/p>\n<h4>Kaynak Havuzlar\u0131 (Resource Pools)<\/h4>\n<p>Kaynak havuzlar\u0131, SQL Server&#8217;\u0131n CPU, bellek ve G\/\u00c7 kaynaklar\u0131n\u0131n mant\u0131ksal b\u00f6l\u00fcmleridir. Her SQL Server \u00f6rne\u011fi i\u00e7in varsay\u0131lan olarak iki havuz bulunur:<\/p>\n<ul>\n<li><strong>Internal Pool:<\/strong> SQL Server&#8217;\u0131n kendi i\u00e7 sistem g\u00f6revleri i\u00e7in ayr\u0131lm\u0131\u015f havuzdur. Bu havuzun kaynak limitleri de\u011fi\u015ftirilemez.<\/li>\n<li><strong>Default Pool:<\/strong> Resource Governor yap\u0131land\u0131r\u0131lmad\u0131\u011f\u0131nda veya bir iste\u011fin belirli bir i\u015f y\u00fck\u00fc grubuna atanmad\u0131\u011f\u0131nda kullan\u0131lan havuzdur.<\/li>\n<\/ul>\n<p>Kullan\u0131c\u0131 tan\u0131ml\u0131 havuzlar olu\u015fturarak, belirli i\u015f y\u00fckleri i\u00e7in \u00f6zel kaynak limitleri belirleyebilirsiniz. \u00d6nemli parametreler:<\/p>\n<ul>\n<li><code>MIN_CPU_PERCENT<\/code>: Havuzun alaca\u011f\u0131 minimum CPU y\u00fczdesi.<\/li>\n<li><code>MAX_CPU_PERCENT<\/code>: Havuzun alabilece\u011fi maksimum CPU y\u00fczdesi.<\/li>\n<li><code>CAP_CPU_PERCENT<\/code>: Havuzun hi\u00e7bir zaman a\u015famayaca\u011f\u0131 mutlak CPU s\u0131n\u0131r\u0131 (SQL Server 2012+).<\/li>\n<li><code>MIN_MEMORY_PERCENT<\/code>: Havuzun alaca\u011f\u0131 minimum bellek y\u00fczdesi.<\/li>\n<li><code>MAX_MEMORY_PERCENT<\/code>: Havuzun alabilece\u011fi maksimum bellek y\u00fczdesi.<\/li>\n<li><code>MAX_IOPS_PER_VOLUME<\/code>: Havuzun her disk birimi ba\u015f\u0131na yapabilece\u011fi maksimum G\/\u00c7 i\u015flemi say\u0131s\u0131 (SQL Server 2014+).<\/li>\n<\/ul>\n<h4>\u0130\u015f Y\u00fck\u00fc Gruplar\u0131 (Workload Groups)<\/h4>\n<p>\u0130\u015f y\u00fck\u00fc gruplar\u0131, belirli \u00f6zelliklere sahip sorgular\u0131 veya oturumlar\u0131 bir araya getiren mant\u0131ksal gruplard\u0131r. Her i\u015f y\u00fck\u00fc grubu, bir kaynak havuzuna atan\u0131r. Bu sayede, o gruba ait t\u00fcm istekler, atand\u0131\u011f\u0131 havuzun kaynak limitleri dahilinde \u00e7al\u0131\u015f\u0131r. Varsay\u0131lan olarak iki grup bulunur:<\/p>\n<ul>\n<li><strong>Internal Group:<\/strong> Internal Pool&#8217;a atanm\u0131\u015ft\u0131r.<\/li>\n<li><strong>Default Group:<\/strong> Default Pool&#8217;a atanm\u0131\u015ft\u0131r.<\/li>\n<\/ul>\n<p>\u0130\u015f y\u00fck\u00fc gruplar\u0131 i\u00e7in yap\u0131land\u0131rabilece\u011finiz baz\u0131 \u00f6nemli parametreler:<\/p>\n<ul>\n<li><code>GROUP_MAX_REQUESTS<\/code>: Grupta ayn\u0131 anda \u00e7al\u0131\u015fabilecek maksimum istek say\u0131s\u0131.<\/li>\n<li><code>REQUEST_MAX_MEMORY_GRANT_PERCENT<\/code>: Bir iste\u011fin alabilece\u011fi maksimum bellek y\u00fczdesi.<\/li>\n<li><code>REQUEST_MAX_CPU_TIME<\/code>: Bir iste\u011fin \u00e7al\u0131\u015fabilece\u011fi maksimum CPU s\u00fcresi.<\/li>\n<li><code>MAX_DOP<\/code>: Bir iste\u011fin kullanabilece\u011fi maksimum paralellik derecesi (MAXDOP).<\/li>\n<\/ul>\n<h4>S\u0131n\u0131fland\u0131rma Fonksiyonu (Classifier Function)<\/h4>\n<p>S\u0131n\u0131fland\u0131rma fonksiyonu, Resource Governor&#8217;\u0131n &#8220;beyni&#8221; gibidir. Gelen her yeni ba\u011flant\u0131y\u0131 de\u011ferlendirir ve onu uygun i\u015f y\u00fck\u00fc grubuna y\u00f6nlendirir. Bu fonksiyon, <code>sys.fn_resourcegovernor_get_classification_info()<\/code> gibi yerle\u015fik fonksiyonlar\u0131 veya <code>APP_NAME()<\/code>, <code>SUSER_NAME()<\/code>, <code>HOST_NAME()<\/code>, <code>IS_MEMBER()<\/code> gibi sistem fonksiyonlar\u0131n\u0131 kullanarak dinamik kararlar verebilir. Fonksiyonun d\u00f6n\u00fc\u015f de\u011feri, bir i\u015f y\u00fck\u00fc grubunun ad\u0131d\u0131r. E\u011fer bir grup ad\u0131 d\u00f6nd\u00fcr\u00fclmezse veya ge\u00e7ersiz bir grup ad\u0131 d\u00f6nd\u00fcr\u00fcl\u00fcrse, istek Default Group&#8217;a atan\u0131r.<\/p>\n<h3>Kaynak Havuzlar\u0131 ve \u0130\u015f Y\u00fck\u00fc Gruplar\u0131 Olu\u015fturma<\/h3>\n<p>Resource Governor&#8217;\u0131 yap\u0131land\u0131rman\u0131n ilk ad\u0131m\u0131, kaynak havuzlar\u0131n\u0131 ve i\u015f y\u00fck\u00fc gruplar\u0131n\u0131 tan\u0131mlamakt\u0131r. Bu b\u00f6l\u00fcmde, \u00f6rnek senaryolar \u00fczerinden bu bile\u015fenlerin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 ve yap\u0131land\u0131r\u0131laca\u011f\u0131n\u0131 inceleyece\u011fiz.<\/p>\n<h4>Yeni Kaynak Havuzu Olu\u015fturma<\/h4>\n<p>Diyelim ki, sunucumuzda hem y\u00fcksek \u00f6ncelikli OLTP uygulamalar\u0131 hem de daha d\u00fc\u015f\u00fck \u00f6ncelikli raporlama ve analiz i\u015f y\u00fckleri \u00e7al\u0131\u015f\u0131yor. Bu iki i\u015f y\u00fck\u00fc i\u00e7in ayr\u0131 kaynak havuzlar\u0131 olu\u015ftural\u0131m:<\/p>\n<pre><code class=\"language-sql\">\n-- Resource Governor'\u0131 etkinle\u015ftirmeden \u00f6nce de\u011fi\u015fiklikleri yap\u0131n\n-- CREATE RESOURCE POOL [OLTP_Pool] WITH (\n--     MIN_CPU_PERCENT = 30,\n--     MAX_CPU_PERCENT = 70,\n--     CAP_CPU_PERCENT = 80, -- CPU kullan\u0131m\u0131n\u0131 %80 ile s\u0131n\u0131rla\n--     MIN_MEMORY_PERCENT = 30,\n--     MAX_MEMORY_PERCENT = 70,\n--     MAX_IOPS_PER_VOLUME = 1000 -- Her birim i\u00e7in 1000 IOPS ile s\u0131n\u0131rla\n-- );\n\n-- CREATE RESOURCE POOL [Reporting_Pool] WITH (\n--     MIN_CPU_PERCENT = 10,\n--     MAX_CPU_PERCENT = 40,\n--     CAP_CPU_PERCENT = 50, -- CPU kullan\u0131m\u0131n\u0131 %50 ile s\u0131n\u0131rla\n--     MIN_MEMORY_PERCENT = 10,\n--     MAX_MEMORY_PERCENT = 40,\n--     MAX_IOPS_PER_VOLUME = 500 -- Her birim i\u00e7in 500 IOPS ile s\u0131n\u0131rla\n-- );\n\n-- \u00d6rnek kodda Resource Governor'\u0131 devre d\u0131\u015f\u0131 b\u0131rak\u0131p sonra etkinle\u015ftirece\u011fiz.\n-- Bu y\u00fczden CREATE komutlar\u0131n\u0131 yorum sat\u0131r\u0131 yapt\u0131m.\n-- Ger\u00e7ek senaryoda bu komutlar\u0131 do\u011frudan \u00e7al\u0131\u015ft\u0131rabilirsiniz.\n<\/pre>\n<p><\/code><\/p>\n<p>Yukar\u0131daki \u00f6rnekte, <code>OLTP_Pool<\/code> daha fazla CPU, bellek ve I\/O kayna\u011f\u0131na eri\u015fim sa\u011flarken, <code>Reporting_Pool<\/code> daha k\u0131s\u0131tl\u0131 kaynaklarla \u00e7al\u0131\u015facakt\u0131r.<\/p>\n<h4>Yeni \u0130\u015f Y\u00fck\u00fc Grubu Olu\u015fturma ve Havuzla E\u015fle\u015ftirme<\/h4>\n<p>\u015eimdi bu havuzlarla ili\u015fkilendirece\u011fimiz i\u015f y\u00fck\u00fc gruplar\u0131n\u0131 olu\u015ftural\u0131m:<\/p>\n<pre><code class=\"language-sql\">\n-- CREATE WORKLOAD GROUP [OLTP_Group]\n-- WITH (\n--     GROUP_MAX_REQUESTS = 100, -- Ayn\u0131 anda maksimum 100 istek\n--     REQUEST_MAX_MEMORY_GRANT_PERCENT = 50, -- Bir iste\u011fin alabilece\u011fi max bellek\n--     MAX_DOP = 4 -- Maksimum paralellik derecesi\n-- )\n-- USING [OLTP_Pool];\n\n-- CREATE WORKLOAD GROUP [Reporting_Group]\n-- WITH (\n--     GROUP_MAX_REQUESTS = 20, -- Ayn\u0131 anda maksimum 20 istek\n--     REQUEST_MAX_MEMORY_GRANT_PERCENT = 20,\n--     MAX_DOP = 1 -- Paralel sorgulara izin verme\n-- )\n-- USING [Reporting_Pool];\n<\/pre>\n<p><\/code><\/p>\n<p>Bu gruplar, hangi uygulamalar\u0131n veya kullan\u0131c\u0131lar\u0131n hangi havuzu kullanaca\u011f\u0131n\u0131 belirleyecek. \u00d6rne\u011fin, <code>OLTP_Group<\/code> \u00fcyeleri <code>OLTP_Pool<\/code>'un kaynaklar\u0131n\u0131 kullan\u0131rken, <code>Reporting_Group<\/code> \u00fcyeleri <code>Reporting_Pool<\/code>'un kaynaklar\u0131n\u0131 kullanacakt\u0131r.<\/p>\n<h4>Kaynak Havuzlar\u0131n\u0131 ve \u0130\u015f Y\u00fck\u00fc Gruplar\u0131n\u0131 G\u00fcncelleme ve Silme<\/h4>\n<p>Mevcut havuz veya gruplar\u0131n parametrelerini de\u011fi\u015ftirmek i\u00e7in <code>ALTER<\/code> komutunu, silmek i\u00e7in ise <code>DROP<\/code> komutunu kullanabilirsiniz:<\/p>\n<pre><code class=\"language-sql\">\n-- Kaynak havuzunu g\u00fcncelleme\n-- ALTER RESOURCE POOL [Reporting_Pool] WITH (MAX_CPU_PERCENT = 60);\n\n-- \u0130\u015f y\u00fck\u00fc grubunu g\u00fcncelleme\n-- ALTER WORKLOAD GROUP [Reporting_Group] WITH (MAX_DOP = 2);\n\n-- \u0130\u015f y\u00fck\u00fc grubunu silme (\u00f6nce grubun bo\u015f oldu\u011fundan emin olun)\n-- DROP WORKLOAD GROUP [Reporting_Group];\n\n-- Kaynak havuzunu silme (\u00f6nce havuzun bo\u015f oldu\u011fundan emin olun)\n-- DROP RESOURCE POOL [Reporting_Pool];\n<\/pre>\n<p><\/code><\/p>\n<p>De\u011fi\u015fikliklerin uygulanmas\u0131 i\u00e7in her zaman <code>ALTER RESOURCE GOVERNOR RECONFIGURE<\/code> komutunu \u00e7al\u0131\u015ft\u0131rman\u0131z gerekti\u011fini unutmay\u0131n.<\/p>\n<h3>S\u0131n\u0131fland\u0131rma Fonksiyonu ile \u0130stekleri Y\u00f6nlendirme<\/h3>\n<p>Kaynak havuzlar\u0131 ve i\u015f y\u00fck\u00fc gruplar\u0131 olu\u015fturulduktan sonra, Resource Governor'\u0131n gelen ba\u011flant\u0131lar\u0131 do\u011fru gruplara atamas\u0131n\u0131 sa\u011flamak i\u00e7in bir s\u0131n\u0131fland\u0131rma fonksiyonu tan\u0131mlamam\u0131z gerekir.<\/p>\n<h4>S\u0131n\u0131fland\u0131rma Fonksiyonu Olu\u015fturma ve Atama<\/h4>\n<p>Bu fonksiyon, SQL Server'a ba\u011flanan her oturum i\u00e7in \u00e7al\u0131\u015f\u0131r ve oturumu belirli bir i\u015f y\u00fck\u00fc grubuna y\u00f6nlendirir. A\u015fa\u011f\u0131daki \u00f6rnek, uygulama ad\u0131na g\u00f6re s\u0131n\u0131fland\u0131rma yapar:<\/p>\n<pre><code class=\"language-sql\">\n-- Resource Governor'\u0131 devre d\u0131\u015f\u0131 b\u0131rak\u0131n\nALTER RESOURCE GOVERNOR DISABLE;\nGO\n\n-- Kaynak havuzlar\u0131n\u0131 olu\u015fturun\nCREATE RESOURCE POOL [OLTP_Pool] WITH (\n    MIN_CPU_PERCENT = 30,\n    MAX_CPU_PERCENT = 70,\n    CAP_CPU_PERCENT = 80,\n    MIN_MEMORY_PERCENT = 30,\n    MAX_MEMORY_PERCENT = 70\n);\nGO\n\nCREATE RESOURCE POOL [Reporting_Pool] WITH (\n    MIN_CPU_PERCENT = 10,\n    MAX_CPU_PERCENT = 40,\n    CAP_CPU_PERCENT = 50,\n    MIN_MEMORY_PERCENT = 10,\n    MAX_MEMORY_PERCENT = 40\n);\nGO\n\n-- \u0130\u015f y\u00fck\u00fc gruplar\u0131n\u0131 olu\u015fturun\nCREATE WORKLOAD GROUP [OLTP_Group]\nWITH (\n    GROUP_MAX_REQUESTS = 100,\n    REQUEST_MAX_MEMORY_GRANT_PERCENT = 50,\n    MAX_DOP = 4\n)\nUSING [OLTP_Pool];\nGO\n\nCREATE WORKLOAD GROUP [Reporting_Group]\nWITH (\n    GROUP_MAX_REQUESTS = 20,\n    REQUEST_MAX_MEMORY_GRANT_PERCENT = 20,\n    MAX_DOP = 1\n)\nUSING [Reporting_Pool];\nGO\n\n-- S\u0131n\u0131fland\u0131rma fonksiyonunu olu\u015fturun\nCREATE FUNCTION dbo.fn_ResourceGovernorClassifier()\nRETURNS SYSNAME\nWITH SCHEMABINDING\nAS\nBEGIN\n    DECLARE @WorkloadGroup SYSNAME;\n\n    IF APP_NAME() = 'MyOLTPApp'\n        SET @WorkloadGroup = 'OLTP_Group';\n    ELSE IF APP_NAME() LIKE '%Report%'\n        SET @WorkloadGroup = 'Reporting_Group';\n    ELSE\n        SET @WorkloadGroup = 'default'; -- Di\u011ferleri varsay\u0131lan gruba\n\n    RETURN @WorkloadGroup;\nEND;\nGO\n\n-- S\u0131n\u0131fland\u0131rma fonksiyonunu Resource Governor'a atay\u0131n\nALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION = 'dbo.fn_ResourceGovernorClassifier');\nGO\n\n-- Resource Governor'\u0131 etkinle\u015ftirin ve de\u011fi\u015fiklikleri uygulay\u0131n\nALTER RESOURCE GOVERNOR RECONFIGURE;\nGO\n<\/pre>\n<p><\/code><\/p>\n<p>Bu \u00f6rnekte, e\u011fer uygulama ad\u0131 'MyOLTPApp' ise, oturum <code>OLTP_Group<\/code>'a, e\u011fer uygulama ad\u0131 '%Report%' i\u00e7eriyorsa <code>Reporting_Group<\/code>'a atan\u0131r. Aksi takdirde, <code>default<\/code> grubuna y\u00f6nlendirilir. Uygulama ad\u0131n\u0131, ba\u011flant\u0131 dizenizde <code>Application Name=MyOLTPApp;<\/code> \u015feklinde belirtebilirsiniz.<\/p>\n<h4>Fonksiyonu Test Etme ve \u0130zleme<\/h4>\n<p>S\u0131n\u0131fland\u0131rma fonksiyonunun do\u011fru \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 ve isteklerin beklenen gruplara atand\u0131\u011f\u0131n\u0131 do\u011frulamak i\u00e7in a\u015fa\u011f\u0131daki DMV'leri kullanabilirsiniz:<\/p>\n<pre><code class=\"language-sql\">\n-- Hangi oturumun hangi gruba atand\u0131\u011f\u0131n\u0131 g\u00f6rmek i\u00e7in\nSELECT\n    s.session_id,\n    s.login_name,\n    s.host_name,\n    s.program_name,\n    g.name AS workload_group_name,\n    p.name AS resource_pool_name\nFROM sys.dm_exec_sessions AS s\nINNER JOIN sys.dm_resource_governor_workload_groups AS g\n    ON s.group_id = g.group_id\nINNER JOIN sys.dm_resource_governor_resource_pools AS p\n    ON g.pool_id = p.pool_id\nWHERE s.is_user_process = 1;\n\n-- Kaynak havuzlar\u0131n\u0131n anl\u0131k durumunu g\u00f6rmek i\u00e7in\nSELECT * FROM sys.dm_resource_governor_resource_pools;\n\n-- \u0130\u015f y\u00fck\u00fc gruplar\u0131n\u0131n anl\u0131k durumunu g\u00f6rmek i\u00e7in\nSELECT * FROM sys.dm_resource_governor_workload_groups;\n<\/pre>\n<p><\/code><\/p>\n<h3>Resource Governor'\u0131 Y\u00f6netme, \u0130zleme ve En \u0130yi Uygulamalar<\/h3>\n<p>Resource Governor'\u0131 kurmak sadece ba\u015flang\u0131\u00e7t\u0131r; etkili bir \u015fekilde y\u00f6netmek ve performans\u0131n\u0131 izlemek s\u00fcrekli bir s\u00fcre\u00e7tir. Bu b\u00f6l\u00fcm, Resource Governor'\u0131 etkinle\u015ftirme, izleme ve en iyi uygulamalar\u0131 ele alacakt\u0131r.<\/p>\n<h4>Resource Governor'\u0131 Etkinle\u015ftirme ve Devre D\u0131\u015f\u0131 B\u0131rakma<\/h4>\n<p>T\u00fcm yap\u0131land\u0131rma de\u011fi\u015fiklikleri yap\u0131ld\u0131ktan sonra, Resource Governor'\u0131 etkinle\u015ftirmeniz gerekir. Bu, <code>ALTER RESOURCE GOVERNOR RECONFIGURE<\/code> komutu ile yap\u0131l\u0131r. Bu komut, Resource Governor'\u0131n yeni yap\u0131land\u0131rmay\u0131 y\u00fcklemesini ve uygulamaya ba\u015flamas\u0131n\u0131 sa\u011flar. Resource Governor'\u0131 tamamen durdurmak i\u00e7in ise <code>ALTER RESOURCE GOVERNOR DISABLE<\/code> komutunu kullanabilirsiniz.<\/p>\n<pre><code class=\"language-sql\">\n-- Resource Governor'\u0131 etkinle\u015ftirme\nALTER RESOURCE GOVERNOR RECONFIGURE;\n\n-- Resource Governor'\u0131 devre d\u0131\u015f\u0131 b\u0131rakma\n-- ALTER RESOURCE GOVERNOR DISABLE;\n<\/pre>\n<p><\/code><\/p>\n<h4>Performans\u0131 \u0130zleme<\/h4>\n<p>Resource Governor'\u0131n etkinli\u011fini de\u011ferlendirmek i\u00e7in d\u00fczenli izleme \u015fartt\u0131r. Kullanabilece\u011finiz ara\u00e7lar ve DMV'ler \u015funlard\u0131r:<\/p>\n<ul>\n<li><strong>DMV'ler:<\/strong>\n<ul>\n<li><code>sys.dm_resource_governor_resource_pools<\/code>: Kaynak havuzlar\u0131n\u0131n anl\u0131k CPU, bellek ve I\/O istatistiklerini g\u00f6sterir.<\/li>\n<li><code>sys.dm_resource_governor_workload_groups<\/code>: \u0130\u015f y\u00fck\u00fc gruplar\u0131n\u0131n anl\u0131k istatistiklerini, ka\u00e7 iste\u011fin kuyrukta bekledi\u011fini, ka\u00e7\u0131n\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/li>\n<li><code>sys.dm_exec_requests<\/code>: \u00c7al\u0131\u015fan isteklerin hangi gruba ait oldu\u011funu g\u00f6rmek i\u00e7in <code>group_id<\/code> s\u00fctununu kullan\u0131n.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Performans Saya\u00e7lar\u0131 (Performance Monitor):<\/strong> SQL Server Resource Governor nesnesi alt\u0131nda CPU, bellek ve I\/O ile ilgili detayl\u0131 saya\u00e7lar bulunur.<\/li>\n<li><strong>Extended Events:<\/strong> Resource Governor ile ilgili olaylar\u0131 (\u00f6rne\u011fin, bir iste\u011fin bir gruba atanmas\u0131, kaynak k\u0131s\u0131tlamalar\u0131) izlemek i\u00e7in Extended Events oturumlar\u0131 olu\u015fturabilirsiniz.<\/li>\n<\/ul>\n<h4>En \u0130yi Uygulamalar<\/h4>\n<p>Resource Governor'\u0131 uygularken dikkate alman\u0131z gereken baz\u0131 en iyi uygulamalar:<\/p>\n<ul>\n<li><strong>K\u00fc\u00e7\u00fck Ad\u0131mlarla Ba\u015flay\u0131n:<\/strong> T\u00fcm i\u015f y\u00fcklerini ayn\u0131 anda y\u00f6netmeye \u00e7al\u0131\u015fmak yerine, en kritik veya en sorunlu i\u015f y\u00fcklerinden ba\u015flay\u0131n.<\/li>\n<li><strong>Test Ortam\u0131nda Deneyin:<\/strong> Canl\u0131 bir \u00fcretim ortam\u0131nda Resource Governor'\u0131 do\u011frudan uygulamadan \u00f6nce, bir test ortam\u0131nda kapsaml\u0131 bir \u015fekilde test edin.<\/li>\n<li><strong>\u0130zleme ve Ayarlama:<\/strong> Kurulumdan sonra s\u00fcrekli izleme yap\u0131n ve performans verilerine g\u00f6re havuz ve grup ayarlar\u0131n\u0131 gerekti\u011finde ayarlay\u0131n.<\/li>\n<li><strong>CAP_CPU_PERCENT Kullan\u0131m\u0131:<\/strong> Bir havuzun CPU kullan\u0131m\u0131n\u0131 mutlak bir \u00fcst s\u0131n\u0131rla k\u0131s\u0131tlamak i\u00e7in <code>CAP_CPU_PERCENT<\/code> kullan\u0131n. Bu, di\u011fer havuzlar bo\u015fta olsa bile o havuzun belirlenen s\u0131n\u0131r\u0131 a\u015fmamas\u0131n\u0131 sa\u011flar.<\/li>\n<li><strong>S\u0131n\u0131fland\u0131rma Fonksiyonunu Basit Tutun:<\/strong> S\u0131n\u0131fland\u0131rma fonksiyonu her ba\u011flant\u0131 i\u00e7in \u00e7al\u0131\u015ft\u0131\u011f\u0131ndan, m\u00fcmk\u00fcn oldu\u011funca basit ve h\u0131zl\u0131 olmal\u0131d\u0131r. Karma\u015f\u0131k mant\u0131klar performans d\u00fc\u015f\u00fc\u015f\u00fcne neden olabilir.<\/li>\n<li><strong>IOPS Limitlemesi:<\/strong> \u00d6zellikle payla\u015f\u0131ml\u0131 depolama ortamlar\u0131nda G\/\u00c7 \u00e7eki\u015fmesini \u00f6nlemek i\u00e7in <code>MAX_IOPS_PER_VOLUME<\/code> parametresini kullan\u0131n.<\/li>\n<\/ul>\n<h3>Sonu\u00e7<\/h3>\n<p>SQL Server Resource Governor, karma\u015f\u0131k ve dinamik veritaban\u0131 ortamlar\u0131nda kaynak y\u00f6netimini optimize etmek i\u00e7in vazge\u00e7ilmez bir ara\u00e7t\u0131r. Kaynak havuzlar\u0131, i\u015f y\u00fck\u00fc gruplar\u0131 ve s\u0131n\u0131fland\u0131rma fonksiyonu gibi bile\u015fenleri do\u011fru bir \u015fekilde yap\u0131land\u0131rarak, farkl\u0131 i\u015f y\u00fcklerinin performans\u0131n\u0131 garanti alt\u0131na alabilir, kaynak \u00e7eki\u015fmesini azaltabilir ve sunucu istikrar\u0131n\u0131 art\u0131rabilirsiniz. Ba\u015flang\u0131\u00e7ta biraz \u00f6\u011frenme e\u011frisi olsa da, Resource Governor'\u0131n sundu\u011fu kontrol ve \u00f6ng\u00f6r\u00fclebilirlik, \u00f6zellikle y\u00fcksek performans gerektiren ve \u00e7e\u015fitli i\u015f y\u00fcklerini bar\u0131nd\u0131ran sistemler i\u00e7in uzun vadede b\u00fcy\u00fck faydalar sa\u011flayacakt\u0131r. Unutmay\u0131n, etkili bir Resource Governor uygulamas\u0131, s\u00fcrekli izleme, test etme ve ayarlama gerektirir.<\/p>\n<h3>SSS (S\u0131k Sorulan Sorular)<\/h3>\n<h4>Resource Governor hangi SQL Server s\u00fcr\u00fcmlerinde kullan\u0131labilir?<\/h4>\n<p>Resource Governor, SQL Server 2008 ve sonraki t\u00fcm s\u00fcr\u00fcmlerinde mevcuttur. Ancak, baz\u0131 \u00f6zellikler (\u00f6rne\u011fin, <code>CAP_CPU_PERCENT<\/code>, <code>MAX_IOPS_PER_VOLUME<\/code>) belirli s\u00fcr\u00fcmlerde eklenmi\u015ftir.<\/p>\n<h4>Resource Governor CPU ve belle\u011fi nas\u0131l y\u00f6netir?<\/h4>\n<p>Resource Governor, CPU i\u00e7in zamanlay\u0131c\u0131lar\u0131, bellek i\u00e7in ise bellek ay\u0131r\u0131c\u0131lar\u0131n\u0131 (memory clerks) kullanarak kaynaklar\u0131 y\u00f6netir. Belirlenen y\u00fczdelere g\u00f6re, bir havuzun alabilece\u011fi minimum ve maksimum CPU\/bellek miktar\u0131n\u0131 belirler. <code>MIN_CPU_PERCENT<\/code> ve <code>MIN_MEMORY_PERCENT<\/code> garanti edilen kaynaklar\u0131 sa\u011flarken, <code>MAX_CPU_PERCENT<\/code> ve <code>MAX_MEMORY_PERCENT<\/code> o havuzun kullanabilece\u011fi \u00fcst s\u0131n\u0131r\u0131 belirler.<\/p>\n<h4>IOPS y\u00f6netimi nas\u0131l yap\u0131l\u0131r?<\/h4>\n<p>SQL Server 2014 ve sonraki s\u00fcr\u00fcmlerde, <code>MAX_IOPS_PER_VOLUME<\/code> parametresi ile her bir kaynak havuzu i\u00e7in disk G\/\u00c7 i\u015flemlerine (IOPS) bir \u00fcst s\u0131n\u0131r getirebilirsiniz. Bu, \u00f6zellikle ayn\u0131 depolama birimini kullanan farkl\u0131 i\u015f y\u00fcklerinin birbirini olumsuz etkilemesini \u00f6nlemek i\u00e7in kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n<h4>Resource Governor'\u0131 devre d\u0131\u015f\u0131 b\u0131rakmak m\u00fcmk\u00fcn m\u00fcd\u00fcr?<\/h4>\n<p>Evet, <code>ALTER RESOURCE GOVERNOR DISABLE;<\/code> komutu ile Resource Governor'\u0131 ge\u00e7ici olarak devre d\u0131\u015f\u0131 b\u0131rakabilirsiniz. Bu durumda, t\u00fcm istekler <code>default<\/code> grubuna atan\u0131r ve <code>default<\/code> havuzunun kaynaklar\u0131n\u0131 kullan\u0131r.<\/p>\n<h4>Bir istek hangi i\u015f y\u00fck\u00fc grubuna d\u00fc\u015fece\u011fini nas\u0131l belirler?<\/h4>\n<p>Bir istek sunucuya ula\u015ft\u0131\u011f\u0131nda, e\u011fer bir s\u0131n\u0131fland\u0131rma fonksiyonu tan\u0131mlanm\u0131\u015fsa, bu fonksiyon \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r. Fonksiyonun d\u00f6nd\u00fcrd\u00fc\u011f\u00fc i\u015f y\u00fck\u00fc grubu ad\u0131na g\u00f6re istek o gruba atan\u0131r. E\u011fer bir s\u0131n\u0131fland\u0131rma fonksiyonu yoksa veya fonksiyon bir grup ad\u0131 d\u00f6nd\u00fcrmezse, istek otomatik olarak <code>default<\/code> i\u015f y\u00fck\u00fc grubuna atan\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"Modern veritaban\u0131 sistemleri, farkl\u0131 \u00f6nceliklere ve kaynak ihtiya\u00e7lar\u0131na sahip \u00e7ok say\u0131da i\u015f y\u00fck\u00fcn\u00fc ayn\u0131 anda bar\u0131nd\u0131rmak zorundad\u0131r. OLTP (On&#8230;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1505],"tags":[],"class_list":{"0":"post-37535","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-sql-2","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MSSQL&#039;de Kaynak Havuzlar\u0131n\u0131 Olu\u015fturma ve Kontrol Etme: Resource Governor ile Performans Y\u00f6netimi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MSSQL&#039;de Kaynak Havuzlar\u0131n\u0131 Olu\u015fturma ve Kontrol Etme: Resource Governor ile Performans Y\u00f6netimi\" \/>\n<meta property=\"og:description\" content=\"Modern veritaban\u0131 sistemleri, farkl\u0131 \u00f6nceliklere ve kaynak ihtiya\u00e7lar\u0131na sahip \u00e7ok say\u0131da i\u015f y\u00fck\u00fcn\u00fc ayn\u0131 anda bar\u0131nd\u0131rmak zorundad\u0131r. OLTP (On...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-07T22:30:41+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"MSSQL&#8217;de Kaynak Havuzlar\u0131n\u0131 Olu\u015fturma ve Kontrol Etme: Resource Governor ile Performans Y\u00f6netimi\",\"datePublished\":\"2026-01-07T22:30:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/\"},\"wordCount\":2127,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"SQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/#respond\"]}],\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/\",\"name\":\"MSSQL'de Kaynak Havuzlar\u0131n\u0131 Olu\u015fturma ve Kontrol Etme: Resource Governor ile Performans Y\u00f6netimi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2026-01-07T22:30:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MSSQL&#8217;de Kaynak Havuzlar\u0131n\u0131 Olu\u015fturma ve Kontrol Etme: Resource Governor ile Performans Y\u00f6netimi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MSSQL'de Kaynak Havuzlar\u0131n\u0131 Olu\u015fturma ve Kontrol Etme: Resource Governor ile Performans Y\u00f6netimi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/","og_locale":"tr_TR","og_type":"article","og_title":"MSSQL'de Kaynak Havuzlar\u0131n\u0131 Olu\u015fturma ve Kontrol Etme: Resource Governor ile Performans Y\u00f6netimi","og_description":"Modern veritaban\u0131 sistemleri, farkl\u0131 \u00f6nceliklere ve kaynak ihtiya\u00e7lar\u0131na sahip \u00e7ok say\u0131da i\u015f y\u00fck\u00fcn\u00fc ayn\u0131 anda bar\u0131nd\u0131rmak zorundad\u0131r. OLTP (On...","og_url":"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2026-01-07T22:30:41+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"14 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"MSSQL&#8217;de Kaynak Havuzlar\u0131n\u0131 Olu\u015fturma ve Kontrol Etme: Resource Governor ile Performans Y\u00f6netimi","datePublished":"2026-01-07T22:30:41+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/"},"wordCount":2127,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["SQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/#respond"]}],"copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/","url":"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/","name":"MSSQL'de Kaynak Havuzlar\u0131n\u0131 Olu\u015fturma ve Kontrol Etme: Resource Governor ile Performans Y\u00f6netimi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2026-01-07T22:30:41+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/mssqlde-kaynak-havuzlarini-olusturma-ve-kontrol-etme-resource-governor-ile-performans-yonetimi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MSSQL&#8217;de Kaynak Havuzlar\u0131n\u0131 Olu\u015fturma ve Kontrol Etme: Resource Governor ile Performans Y\u00f6netimi"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/37535","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=37535"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/37535\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=37535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=37535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=37535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}