Jump to content

Otterfate

Members
  • Posts

    2
  • Joined

  • Last visited

Everything posted by Otterfate

  1. There is a flow chart doing the rounds somewhere but the game uses a MS SQL server and a dbserver daemon/helper process that interfaces with various other processes - auth, account and the map servers which can spawn multiple instances. Short of significant rewrites I'm not sure much can be done past a certain point to manage performance other than split up the community into multiple discrete servers. Ah, there are a few things that can be tweaked at the server level to help with the load here and there! For example, by default, Microsoft SQL Server over-uses the server's CPU for trivial tasks, and some settings can be adjusted to move the CPU load from things that don't need it to processes that really do need it. Also, the databases by default grow out their data files in really tiny increments (1MB per growth), so if, say, 100MB of data hits the database, it has to do 100 grow operations, which are kinda slow. Messy! These are things that can have a pretty good impact without having to touch the code, and there's several other system-level things that can be fixed up in a similar vein. Figured I'd see if they needed some help getting these sorts of things in line, and my over-enthusiastic self saw a chance to do some techno-babbling!
  2. Is the database server backend still running on Microsoft SQL Server? If so, managing SQL Server databases has been my field of expertise for 7 years now, and I'd be delighted to help out with any performance tuning and server settings that could help with making resource usage more efficient!
×
×
  • Create New...