Otterfate
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Store
Articles
Patch Notes
Posts posted by Otterfate
-
-
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!
Lag, Disconnects, and Stability
in Announcements
Posted
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!