I am curious....

Danku

Danku

Dalayan Beginner
I know this is a volatile subject, but has anyone pinned down the specific reason the server has gotten so rough? Has it been the addition of the planes? Did it get moved to a new server without notification at some point?

I am just shocked at the steady way it has changed in the last few months. Would love some actual information about it.

And yes, I know this week they are upgrading the server CPU. But that is the same CPU which ran the game just fine a few months ago, isn't it?

Any info is appreciated, thanks.

PS- Keep posts civil, no "OMG I AM ANGRY" stuff. We are all frustrated, but that is no reason to be posting angry.
 
The way I see it, I don't mind a little downtime if it improves the quality of the server. Thank god they are replacing that celeron though, because celerons are quite possibly the worst processor ever made. I would rather run a 386 then a celeron.
 
This is a guess, based purely on my own opinion, but I'm getting ready to upgrade some servers at work because of it too...

SQL server = database

Various reasons - new content, additional players, and possibly some less than efficient coding (no accusations here) - server hammered more and more - can't keep up. We have basically outgrown the capacity of the the current server (and yes, celeron is not as good as pentium when it comes to performance imo).

Side note - I'm getting ready to upgrade the front end of an application - it's going to be using Ajax - anyone have any specs on how it interacts directly with a SQL back-end? I'm wondering if I should just go ahead and upgrade the box now. Thx info ^_^

P.S. Danku meant to say "I am bi-curious"
 
Increase in population and high-intensity players (raiders), as well as a much higher forum activity causing strain on the SQL server. We had a pretty low population right after 2.0 due to the amount of old raiders quitting, and we're back up to pre 2.0 numbers now.

Basically what you need to understand is that as long as the SQL server is not taxed out you won't notice anything, so if you have 200 players online and the sql server is running at 99%, you'll notice no diff from 50 players on and server running at 25%. It's only after the amount of queries reaches a certain critical mass that the lag hits - so the lag started when the population grew large and active enough to consistently hit that critical mass.

I did some more performance tweaks today that should help.
 
A side note to Minge...

I don't have any definite specs, but AJAX interacts fine with a SQL database - as long as you make sure that your connections, etc. are handled well. AJAX is really only making the same calls to the database but asynchronously instead of synchronously. If you are using standard (or older) AJAX then you need to be aware of the special handling (via javascript and callbacks, etc.). If you are using .NET 2.0 and the AJAXToolkit (Google "AJAX Toolkit") from Microsoft then you just implement the controls as if they were normal server controls - the scriptmananger handles the callbacks and everything (they did a really good job with it!). The controls now reside a bit deeper in containers so you might need to refer to the forums and stuff occassionally to get hints on how to "find" the control on the page - btw, FindControl doesn't always work correctly :)

PM me if you have any questions

Sst
 
Wiz said:
I did some more performance tweaks today that should help.
Click to expand...
As always, thanks Wiz!

If the forum activity is a significant part of the problem, would splitting the forum off to a separate server make much of a difference? And what (general ballpark) would that cost?
 
I mostly play dureing the wee hours of the morning, and i have noticed that about 0700 CST the server started rebooting zones. then i get DC'd and find that the server pop had grown almost 100 players since i logged on. im sure the load of players playing, questing, tradeskill leveling, banking, and the such has a huge impact on the servers ability to keep up to speed with the demand. also...i KNOW that the Celery has a smaller data gateway than the Pentium...thats a fact, hence why its much cheaper to purchase...once upgraded to Pentium it should run better, and as for splitting the forum and game servers apart, yes, it should decrease the stress on the game server, but then you have 2 servers to code, pay for, and troubleshoot when they go down...adds to the overall stress level of maintaining this great server. not saying the admins couldnt handle the stress, just...i wouldnt want to be in their shoes.

PS: Great job so far on the performance effort, and as a player, i truly enjoy the constant effort the admin staff have placed on this project!
 
Thanks for the info, I am sure alot of people got answers that they had wanted. =)

Go go server upgrade!
 
I hope everyone realizes Wiz pays for more than one server. SoD is not located on one box, the SQL is on it's own server. There's more than 1 server, The Login/Zoning server, they're on different ports, so I'm not sure. =P Then there's the World server, and finally the SQL server. I have no clue whether the Login/Zoning/World server(s) are located on one box.

I'm getting the impression that some people are thinking Wiz is dumb enough to actually host SoD on a single Celeron base server.
 
Kyeld said:
I hope everyone realizes Wiz pays for more than one server. SoD is not located on one box, the SQL is on it's own server. There are 3 servers, The Login/Zoning server, they're on different ports, so I'm not sure. =P Then there's the World server, and finally the SQL server. I have no clue whether the Login/Zoning/World server(s) are located on one box.

I'm getting the impression that some people are thinking Wiz is dumb enough to actually host SoD on a single Celeron base server.
Click to expand...

Not counting Dawntide there's 2 servers. Zone/World server and SQL server. SQL server shares the forums. Everything else runs on the Zone server iirc.
 
Sp, there will be double XP for a week? Sweet =) But if server problems is the reason, maybe it should be 2 weeks heh.
 
I can see why the xp bonus would be more than one week, depending on the bonus that is. Since the server seemed to be a little unstable for so long, an extended bonus time would be nice. I know I personally haven't played as much the last couple weeks because the lag was strong. Just a thought, any bonus is a welcome bonus, but an extended one is always better ;)
 
Danku said:
Sp, there will be double XP for a week? Sweet =) But if server problems is the reason, maybe it should be 2 weeks heh.
Click to expand...

LokiSif said:
I can see why the xp bonus would be more than one week, depending on the bonus that is. Since the server seemed to be a little unstable for so long, an extended bonus time would be nice. I know I personally haven't played as much the last couple weeks because the lag was strong. Just a thought, any bonus is a welcome bonus, but an extended one is always better ;)
Click to expand...

Let's not look the gift horse in the mouth...

1 week of double XP is sweet! :dance:

THANX WIZ!!
 
You must log in or register to reply here.
Back
Top Bottom