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  might help too. |
I have tried this code and this is what I use the most "total_worker_time"
FETCH API_CURSOR000000000001F644
What exactly does this mean?
and
So what is your suggestion about the GP_Update
