Server Lag

I have one linked server (GAMESERVER) the one from chumpy mssql 2005 guide,just this one,but is not really used,only when i access the account characters from BALQ EDITOR because the linked server was removed from stored procedures.

Get rid of it.

This is exactly what i sayd!
I already did this,i create a LINKED server because without that the BALQ TOOLZ can't open the ACCOUNTS

"Tools>Account>Characters" Account Name Search,this function.

Even if i remove the LINKED SERVER,the cabal server will still working without problem,as i told you the LINKED SERVER is used only for my BALQ TOOLZ.

For me what i have experienced is 500players ++ online doesn't lag at all
What kind of server are you using,i was wondering which dedicated server are you using though,i don't see any problem with my previous dedicated server with 100mbps connection with 8gb of rams allocating 4gigs to CentOS and others for background of the server.

Do check your worldsvr.ini which it shows the updatetime which is usually run
"UpdateInterval=300000" Which is a basic setting of 300000 <--- equals to 300seconds
If you set it lower than that,it will cause laggs i have tried that before.

Somehow, my mssql was express edition as well,so i don't see any problem with it.

I don't think it's the sql that's limiting the resource usage though.
Some more the web was hosted on the same dedicated server,so i couldn't see what was really wrong with it though cheers

Source : I have my own server a couple of years ago.

Well this is my :

UpdateInterval=300000

So i don't think that is from there...

So there's a couple of things already.
It's either the server's specification or connection.
I don't see 100players + would be affected by the database nor other problems.

Used to run 8 channels as well over here seems all were quite stable.
Cheers

Well,thank for the informations but how this supoused to help me?
Good day!

Quote:

---

Originally Posted by S37uP!Update

Well,thank for the informations but how this supoused to help me?
Good day!

---

Seriously, stop being a smartarse. That's all you seem to be doing lately, and you expect people to help you?

Weeew,sorry but i didn't wanted to be smartarse as you sayd,really sorry you understand me wrong,i just asked how this suposed to help me?Not in a bad way,maybe he writed me something and dind't understand it,that's all,for real now,i didn't wanted to look like smarter then other!

You stated before that there's no error in cabal logs, but how about the logs from centos, did you checked them out?
Since there's no problem within the databases, there's probably a vmware related issue, so please post here the type of vmware you are using(workstation, server), it's version and the resources allocated to your server.

VMware Workstation 8.0.2
5 GB RAM,Number of procesors : 2,Number of cores per proces : 1.

Did you checked centos logs as I said?
You can also try to lower the ram for centos, because it may not be enough ram for windows to menage the connections between vmware and sql

I already tryed to lower the resources of the centos,still same,lagging.
Where do i check the logs of centos?i mean cabal logs are in /var/log/cabal,the centos logs where do i check it?

/var/log/

There's alot of files wich one i have to open it?

Wich one do you want to look into?
the httpd logs,the cpu logs....

PS still cant pm u..(sended you an email)

May I remind you guys that this is not a CentOS support forum. You are expected to know how to check your system logs and debug issues. I would suggest taking this somewhere more appropriate, like the CentOS forums.

try to reinstall SQL. use SQL server 2005.

I don't know why,but i guess you didn't read the topic!
@Yama,i already asked on the centos forum,and they trashed my topic with reason they don't offer support for centos with mssql...