2009-03-29, 06:41 PM
Combattente Wrote:Heh, with 8m+ characters and 10m++ accounts registered you'd think they'd already hit the 2gb limit, so yeah, they're undoubtedly using the pro version.
Are you sure they're even using Microsoft SQL? :f6:
EDIT: Also, just wanted to point this out: if you didn't notice already, since some months, every Sunday something like this is happening. Server crashes, lag spikes, and website crashes (well, this is the first time the website & MTS are involved, I think) are happening every pineappleing Sunday. It's undoubtedly something to report to NEXON with a ticket or on their forums. This will be another question I'll be asking to NxProse when he'll open his Q&A thread again.
autogrowth is an MSSQL concept. Oracle and MySQL use different concepts. Sybase and Teradta don't have a similar one, and the flatfile RDBMS versions don't either. The "File groups" is a MSSQL concept too (see reference to PRIMARY). Being able to identify an RDBMS based on it's error message is a prerequisite for the data analysis I do, since you have to "talk" to each flavor of server in a slightly different "dialect" as it were of SQL and I interface with 23 or so on any given day. Error messages indicate its either MSSQL 2000 or 2005, not clear which, but 2005 has a better relationship with SOAP and .NET so would be the more likely.
Anyhow, just because the website is using MSSQL doesn't mean the game itself is, or that they're sharing database instances, so the number of players isn't indicative of anything.
It's highly possible that they have backups scheduled to run over the weekend and those backups are causing this by overflowing the limited space in tempdb for a rollback faster than it can autogrow to compensate, then without autoshrink on no new requests succeed because the whole thing is stuck.
It's not having what you want - It's wanting what you've got.

