Does Everyone have that Lag Problem?

[Energetics]

Hello,

i just want to ask if anyone knows how to resolve the annoying server lag Problem.

We tryed everythin to fix it but nothin works...


Best Greetings,

Energetics

[cranK337]

Get a better internet connection, better root server and it won't lagg.

[Energetics]

Originally Posted by cranK337

Get a better internet connection, better root server and it won't lagg.

aha? so you want to say that i need a better root server for no lags?

So then tell me why it doesnt lag if ppls come in and run around and when 1 guy buys anythin or skills his skilltree the server starts lagg?

and btw. our server is not 1% overloaded so why should we get a better server when our server is strong enough?

[Pyrok]

The reason it lags when picking up drops, etc but not when running around is because it doesn't save every single movement to the db but it does save every item transaction or skill state. So perhaps your SQL server box isn't up to the task or is misconfigured...

[cranK337]

Originally Posted by Pyrok

The reason it lags when picking up drops, etc but not when running around is because it doesn't save every single movement to the db but it does save every item transaction or skill state. So perhaps your SQL server box isn't up to the task or is misconfigured...

...or this.

[harmbasi]

I am having the same issue. The internet shouldn't even be part of this problem for me at this point b/c I'm running a local server. I have a quad core processor @ 4.5Ghz and 12GB DDR3 ram. I'm a noob with MS SQL so have no idea how to optimize it. Was reading about indexes but can't figure that stuff out.

@Pyrok, if you have any suggestions for helping my server run faster please let me know. Thanks.

[Pyrok]

I'm not real familiar with SQL Server but on my machine the bottleneck is the file subsystem. The only SQL Server I ever had to deal with before this was a low-traffic dedicated server where data integrity and security were much more important than a game server (financial information). A real server would be running RAID (1 or 5 at a minimum) and using high performance server hard drives probably using a SAN box. I have the same lag everyone is talking about but I think it would be ok on a real server setup.

[harmbasi]

Ok, great. Thanks for the info bud. Trying to put everything on a OCZ Vertex 2 SSD tomorrow and see if it makes a improvement.

[wisp66]

look in to 3GB switch or allowing programs to access and allocate more memory if i use #learn_all_skill i lagg for a few secs thats about it.
other then that i honestly never had much of this problem.