ShardManger

Quote:

Originally Posted by sarkoplata Filter? Really? Monitor your SQL, check your CPU/Disk usage, optimize your AddLogItem/AddLogChar procedures, if not using it already, use a SSD/nvme disk. Don't use SQL Express. If anything queues up on SQL and can't get processed fast enough, it'll build up a delay on ShardManager. For example, if quite some amount of characters are grinding, every few SP earned, GameServer will tell Shard to update the _Guild and _GuildMember tables with the earned GP Amount. If shard can't process those enough it will increase the latency. Use your sql profiler and [Only registered and activated users can see links. Click Here To Register...] might help too.