vSro Paylaşım vSRO Toplam Mob Sayısına Göre Kaç GameServer Açılmalı?

USE [SRO_VT_SHARD]
GO

-- ===================================================================
-- AKTİF MOB SAYISINA GÖRE ÖNERİLEN GAMESERVER SAYISI HESAPLAMA
-- ===================================================================
SELECT 
    TotalMobCount AS [Toplam Aktif Canavar Sayisi],
    CASE
        WHEN TotalMobCount = 0 THEN 0
        WHEN TotalMobCount <= 40000 THEN 1
        WHEN TotalMobCount <= 80000 THEN 2
        WHEN TotalMobCount <= 120000 THEN 3
        WHEN TotalMobCount <= 160000 THEN 4
        WHEN TotalMobCount <= 200000 THEN 5
        ELSE CEILING(CAST(TotalMobCount AS FLOAT) / 40000.0)
    END AS [Açılması Gereken Minimum GameServer Sayisi],
    CAST(ROUND((TotalMobCount / 40000.0), 1) AS DECIMAL(4,1)) AS [Ortalama GS Yükü Katsayısı]
FROM (
    SELECT 
        ISNULL(SUM(N.dwMaxTotalCount), 0) AS TotalMobCount
    FROM dbo.Tab_RefNest N WITH (NOLOCK)
    INNER JOIN dbo.Tab_RefTactics T WITH (NOLOCK) ON N.dwTacticsID = T.dwTacticsID
    INNER JOIN dbo._RefObjCommon ROC WITH (NOLOCK) ON T.dwObjID = ROC.ID
    INNER JOIN dbo._RefRegion R WITH (NOLOCK) ON N.nRegionDBID = R.wRegionID
    WHERE ROC.Service = 1
      AND N.dwMaxTotalCount > 0
      AND ROC.Rarity IN (0, 6) -- Normal ve Şampiyon canavarlar
      AND ROC.CodeName128 LIKE 'MOB_%'
      AND ROC.CodeName128 NOT LIKE 'MOB_GOD_%' -- Event/God mobları hariç
      AND R.ContinentName NOT LIKE 'GOD_TOGUI'
) AS CoreData