[Weird problem] SR_GameServer

[FL0wshY]

Hello,

There is a annoying error has been shown in sr_gameserver
After few days of figuring it out i seen that it is x32 and when it reach the limit which is 4gb its closes[crash] auto
Asked mykha and told me to change your sql server to a better version [gonna try this later]
But, what i wanted to do? 2 gameservers but, ye hyperfilter wanted $200 more for other ip to make 2 gameservers and actually it is too much for second month new root,hyperfilter etc also new web design and coder money is there any solution for this? better than paying more $200 for hyperfilter to make a second gameserver
The error: [SR_GameServer] OnExit() Called and [SR_ShardManager] OnExit() Called happens every time the sr_gameserver reaches 4gb of rams about shardmanager ones happend once and was before ctf starts

~ What i have done? Fixed transport pet bug, decreased the mobs from 46k to 36k still the same crash after 12 hours, none fixed it.

I hope someone may know a fix for this problem,

~ It may be wrong section but, my thread was in ask the experts for over 12 hours and no one replied.

Thanks,
Regards

[鳳凰城]

Well, Even with that extra IP, The service of 2x gameservers won't be like normal with hyperfilter.
About that 4GB ****, You should try the paid sql version. Because it sometimes ***** the exe load from database to server files to clients. Complicated situation ...
By the way, How dafuq is the gameserver's ram usage reaches 4GB .. It's maximum on a good root with 16GB of ram about 1.5GB ram usage. Weird but, Gonna discover it.. Can you upload your GS dumps?

[Mykha*]

my gs stops at 3.7 gb then swaps all the memory load to the sql server so do exactly as i said and you will have it solved.

[PortalDark]

The ask the expert section is more oriented for little questions and doubts
but this can be posted ere as well, aside that being 12h and no answer a good reason

[Schickl]

ofc the gameserver will crash if it reaches 4GB(no more memory)
that's why 32-Bit often isn't enough for newer programs
I tried to run the server files on my PC once just for fun and the GS went up to 2GB(eu and china enabled)
since 36k mobs aren't much I doubt that this is the problem

It probably is a bug.
Does it happen under load or even when there are no users on?


also:
"swaps all the memory load to the sql server"
Now that is something I really don't believe
The GS might start executing all pending queries and free the memory allocated by them, because it's running out of memory, but I don't know how it should "swap the memory load"

[FL0wshY]

Originally Posted by Schickl

ofc the gameserver will crash if it reaches 4GB(no more memory)
that's why 32-Bit often isn't enough for newer programs
I tried to run the server files on my PC once just for fun and the GS went up to 2GB(eu and china enabled)
since 36k mobs aren't much I doubt that this is the problem

It probably is a bug.
Does it happen under load or even when there are no users on?


also:
"swaps all the memory load to the sql server"
Now that is something I really don't believe
The GS might start executing all pending queries and free the memory allocated by them, because it's running out of memory, but I don't know how it should "swap the memory load"

I'm using sql server 2008 r2 standard and i'm using windows server 2012 standard so i'm thinking to change to sql server 2012 enterprise
Would it solve my problem?

[深路在线]

More RAM...

[FL0wshY]

Originally Posted by 深路在线

More RAM...

I got 64 gb ram

[Schickl]

Originally Posted by 深路在线

More RAM...

That won't help at all
My PC has 32GB and that doesn't help a 32-Bit executable at all
The addresses are 32-Bit long and 2^32 = 4294967296 -> 4Gbyte

Now that really is some basic stuff you should know


@OP:
I doubt that upgrading your SQL server will help
I don't see what should make a more expensive version better(in this case)

[Mykha*]

@Schickl
not "swapping" specifically, but i have been running servers for long enough to know all about that. If i use standard on my server, sqlserver.exe stays at 4GB and gs crashes.
If i use enterprise, sqlserver.exe reaches 22Gb and gs stays exactly at 3.7.

@OP
Please do the following, use enterprise version and if that doesn't work use Win2008 + MSSQL Enterprise edition.

[Nezekan]

limit zones, use 2 gameservers (better even 3) and upgrade mssql to a decent version

[FL0wshY]

Originally Posted by Nezekan

limit zones, use 2 gameservers (better even 3) and upgrade mssql to a decent version

Did you try to read the whole thread?

Currently and stays at 2,9GB never moved since the last restart i have just played around in sql,server.cfg,certification and it is stays at 2,9GB now.
Looks great,
Thanks for everyone who helped me.

~ sorry portaldark if this was wrong section but, ye thanks goes to the people who replied to this thread for helping me out, thanks!

[Schickl]

Originally Posted by Nezekan

limit zones, use 2 gameservers (better even 3) and upgrade mssql to a decent version

Please tell me one feature a more expensive SQL Server has that would help the Gameserver save memory

[elfuria]

Does joymax have a 64 bit version of GS? Probably a noob question but eh xD

[lesderid]

Originally Posted by elfuria

Does joymax have a 64 bit version of GS? Probably a noob question but eh xD

Why don't you ask them?