Region distribution on 2 GameServer

[Vaasneht]

Hi, does anyone know how to distribute the regions when running 2 GameServer? To make the mob count equally distributed, so you don't end up with 34K mob count on one GameServer and 10K on the second one.

Thank in advance for any respond.

[OKeks]

I found below query in another forum:

/*
 * Count total monster spawn categorized by level
 * Witchy Moo, 20150622
 */
 use sro_vt_shard
SELECT d.CodeName128 AS 'Monster Code', e.Lvl AS 'Level', SUM(a.dwMaxTotalCount) AS 'Max Spawn'
FROM Tab_RefNest a 
INNER JOIN Tab_RefTactics b ON a.dwTacticsID = b.dwTacticsID
JOIN Tab_RefHive c ON a.dwHiveID = c.dwHiveID
JOIN _RefObjCommon d ON b.dwObjID = d.ID
JOIN _RefObjChar e ON d.Link = e.ID
JOIN _RefRegion f ON a.nRegionDBID = f.wRegionID
WHERE d.Rarity IN (0,6)    -- Only select Regular and Elite, add 3,8 for uniques
AND f.ContinentName NOT LIKE 'GOD_TOGUI'    -- Not including FGW monsters
AND (d.[Service] = 1 AND d.Codename128 LIKE 'MOB_%' AND d.Codename128 NOT LIKE 'MOB_GOD_%')   -- Not including FGW monsters
GROUP BY d.CodeName128, e.Lvl, d.Rarity ORDER BY e.Lvl ASC

You can copy the result into excel and calculate mobs as you need. With my test database I got:

3506	4003	4436	524	3768	5851	1967	1171	1575	3722	5225	2319	6248	2303	46618
AM	CA	CH	DH	EU	JU	KK	KT	OA	RM	SD	TK	TQ	WC