Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 12:31

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[PROOF] Sql 2000 VS Sql 2008 R2

Discussion on [PROOF] Sql 2000 VS Sql 2008 R2 within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 20
Join Date: Mar 2007
Posts: 2,650
Received Thanks: 4,729
[PROOF] Sql 2000 VS Sql 2008 R2

Since a lot of wanna-be-cool-admins are around these forums, i decided to release some screenshots for you to compare
i had a little job to remodel DreamWorld's server systems.
the first thing i did was downgrading DreamWorld Rage's database server from MS SQL Server 2008 R2 to MS SQL Server 2000.

As a result, the server's performance increased drastically, and the server lost its known inventory lags.

screen of the server with 600 people online on sql-server 2008 R2:


screen of the server with 950 people online on sql-server 2000:



now, before one of you wanna-be-pros comes here to flame or to talk some random bullshit about your oh so great sql server 2005 or 2008, please do me the favor, and give evidences / reasons why your newest database server is the best.

as always: this thread is for learning purposes and for those who thought me wrong with my "sql 2000 madness".
by the way: the database size is more then 4gb so stop bullshitting that sql server 2000 only handles 2gb of ram or only 2gb database files....
silkbotter is offline  
Thanks
3 Users
Old 01/04/2012, 18:50   #2
 
elite*gold: 0
Join Date: Apr 2010
Posts: 1,988
Received Thanks: 1,783
How about you make a guide about how to restore SQL2008 backup in sql2000? ^_^
i always knew that sql2000 was better, because the game was designed around 2001-2004 so they used sql2000
18andLife is offline  
Old 01/04/2012, 18:52   #3
 
elite*gold: 20
Join Date: Mar 2007
Posts: 2,650
Received Thanks: 4,729
it takes about 1 day to revert the database to 2000.
it's a lot of work.
no way I'm going to make any kind of guide for it.
sorry. and besides, this community doesn't deserve it.

and I'm 100% sure you won't be able to follow the guide anyways.
it's too "different each machine".
silkbotter is offline  
Thanks
5 Users
Old 01/04/2012, 18:56   #4
 
Shane¸'s Avatar
 
elite*gold: 100
Join Date: May 2010
Posts: 1,948
Received Thanks: 1,635


krallin' around with moarr cores
Shane¸ is offline  
Old 01/04/2012, 19:04   #5
 
elite*gold: 20
Join Date: Mar 2007
Posts: 2,650
Received Thanks: 4,729
funny.
this sin't a show-off.
and don't take it wrong, but your server doesn't seem to be running really smooth. look at the consumption of your cpus and your ram.
pretty much if you ask me
silkbotter is offline  
Old 01/04/2012, 19:05   #6
 
Shane¸'s Avatar
 
elite*gold: 100
Join Date: May 2010
Posts: 1,948
Received Thanks: 1,635
Quote:
Originally Posted by silkbotter View Post
funny.
this sin't a show-off.
and don't take it wrong, but your server doesn't seem to be running really smooth. look at the consumption of your cpus and your ram.
pretty much if you ask me
...3 servers...
bottom left corner...
Shane¸ is offline  
Old 01/04/2012, 20:35   #7
 
Xuz's Avatar
 
elite*gold: 0
Join Date: Nov 2011
Posts: 222
Received Thanks: 47
Quote:
Originally Posted by silkbotter View Post
and besides, this community doesn't deserve it.
So why you want to prove sql 2000 better than sql 2008 r2 to us and we don't deserve your help..
Xuz is offline  
Old 01/04/2012, 20:36   #8
 
elite*gold: 0
Join Date: Dec 2008
Posts: 533
Received Thanks: 227
You should learn and do it by yourself!
sandzo187 is offline  
Thanks
1 User
Old 01/04/2012, 20:42   #9
Chat Killer In Duty


 
PortalDark's Avatar
 
elite*gold: 5
Join Date: May 2008
Posts: 16,390
Received Thanks: 6,507
Quote:
Originally Posted by 18andLife View Post
How about you make a guide about how to restore SQL2008 backup in sql2000? ^_^
i always knew that sql2000 was better, because the game was designed around 2001-2004 so they used sql2000
i think I saw some forum giving a tool/method to do so, google it
PortalDark is offline  
Old 01/04/2012, 22:26   #10
 
elite*gold: 0
Join Date: Jun 2011
Posts: 691
Received Thanks: 521
I'm using 2k3 server and 2k sp4 sql in class online and it goes so **** smooth, never even bothered of trying 2k8 lulz^^.
Getzabelz is offline  
Old 01/04/2012, 22:41   #11
 
Kape7's Avatar
 
elite*gold: 0
Join Date: Dec 2007
Posts: 3,210
Received Thanks: 6,298
It's useless to run a server using slq2005 or higher, it has lots of stuff that SRO was never designed for use, which makes at the end a waste of RAM and server resources.
Kape7 is offline  
Old 01/04/2012, 23:21   #12
 
elite*gold: 0
Join Date: Apr 2010
Posts: 1,988
Received Thanks: 1,783
Quote:
Originally Posted by Getzabelz View Post
I'm using 2k3 server and 2k sp4 sql in class online and it goes so **** smooth, never even bothered of trying 2k8 lulz^^.
It's pretty hard to find a dedicated server nowadays with Windows Server 2003, almost all hosting offers server2008 :\
18andLife is offline  
Old 01/04/2012, 23:41   #13
 
elite*gold: 20
Join Date: Mar 2007
Posts: 2,650
Received Thanks: 4,729
Quote:
Originally Posted by Xuz View Post
So why you want to prove sql 2000 better than sql 2008 r2 to us and we don't deserve your help..
read the first post. then you will understand why i prove it. because there are simply too many noobs out there who say that the minimum or optimal requirements are at least sql server 2005. and if i remember back, there weren't people who agreed with me.
in this topic, you can see, that it is indeed better using a 2000 version :P
just saying.

now why this community doesn't deserve it: easy:
you guys flame me for asking for 50 euros for teaching you stuff and for securing your server.
now in this particular way again..first you guys still believe in your crap ultra-high-end database stuff, and now suddenly you start trolling around that i should create a tutorial/guide instead?
do you have any idea what work it takes to redo the db back to sql server 2000? if the db would be empty it would take less them 30 minutes. but on a db with some chars on it already makes the whole thing way more complicated.
so either way this community is full of shitheads who think they know it all and leechers who demand me to do some kind of "click-by-click guides" because they are too spoiled to learn and try it by their own.

this community is too young! most of you have absolutely NO idea about life and work!
I am not 16 years old and i do not go to school and eat at mommys table when i get home from school.
i have many more responsibilities. i got a real life! a household, bills to pay, i have children to feed, i have to go to work every fucking day. i have to come up with solutions on my job...without asking for guides somewhere!
you don't seem to be able to see this whole thing on a different perspective - of mine! because for me time is money! i have about 4 hours daily to spend time with my wife/children and to spend some time on my computer.
do you really think i would spend that time doing free stuff? i already released enough stuff for this community, and i NEVER got any volunteer donation for my work, so , why should i keep on doing it?
think this way. you have 4$ in your pocket. you need at lease 2 to buy food..and you would like to save some money.. would you really give that money to someone else? i mean - WOULD YOU give that money to a spoiled rich little brat (child) who has nothing else to do then run around asking for free money? i don't think so!
now for you to understand:
money - my time
spoiled child - 95% of the epvpers community

i think this statement has been clear enough!
grow up! nothing in this freaking world is free! and as sooner as you understand that, and as sooner you start LIVING ON YOUR OWN WITHOUT YOUR PARENTS HELP, the quicker you learn how the world really works and what you have to do to earn your living!
don't be a lazy fucked-up kid! do something for your skills and pay the ones who deserve it!
silkbotter is offline  
Thanks
5 Users
Old 01/04/2012, 23:54   #14
 
Schickl's Avatar
 
elite*gold: 0
Join Date: Feb 2009
Posts: 1,064
Received Thanks: 539
So just because the newer one uses more RAM means it's less efficient/slower or w/e?
actually the more it caches the better
I'm pretty sure that not all the RAM is wasted
RAM is extremely fast and still offers quite much space
ofc it will be slower if the resources needed to manage all the used RAM use all your system resources, but by looking at your task manager i can see that it's not the case

I'm pretty sure that a lot of improvements regarding caching/parsing queries/etc have been done, but ofc they also added new stuff, which could make it slower

I don't think that is the case here
Schickl is offline  
Old 01/05/2012, 00:17   #15
 
elite*gold: 0
Join Date: Jun 2011
Posts: 691
Received Thanks: 521
Quote:
Originally Posted by 18andLife View Post
It's pretty hard to find a dedicated server nowadays with Windows Server 2003, almost all hosting offers server2008 :\
Yea, I'm aware of that xD, but luckily we got it .
Getzabelz is offline  
Reply


Similar Threads Similar Threads
[G1 Ankauf] Suche 2000 G1 Biete: 600 elite*gold :o [600 e*gold gegen 2000 G1 C]
02/04/2011 - WarRock Trading - 0 Replies
^this Titel sagt alles. Wer einverstanden ist PN me, oder in den Thread, eine weitere Kontaktmöglichkeit wäre Skype stefaaan.1 den aus Köln wählen. Handle entweder per MM, oder ihr vertraut mir und gebt first aufgrund meiner positiven TBM Bewertungen. Mfg,
MS 2000/2003/2008 Root Server
05/25/2010 - Metin2 Private Server - 2 Replies
Hallo Kennt jemand ein tut wie man auf Windows Server 2000 / 2003 / 2008egal welche ;) Mt2 Root Server erstellen kann. (konfigurieren):confused: Ich hab viel gesucht aber nix gefunden, vielleicht kennt einer von euch ne link. TNX :)
MMAStory [V62!] [Hamachi] [rates = 2000/2000/15]
07/06/2009 - MapleStory - 0 Replies
MMAStory 2000 exp 2000 meso 15 drop Hamachi Details Hamachi Details MMAStory MMAStory2
[Need Help]SQL 2000 not running on a Windows web server 2008??!!
02/16/2009 - Private Server Advertising - 2 Replies
Hello all, i have a dekaronserver on my pc and its running, then i wanna it make 24/7 so i buy a root server BUT i cant install it error: The version of this file not compatible with the version of Windows you\\\'re running. Check your computer\\\'s system information to see whether you need an x86 (32-bit) ot x64 (64-bit) version of the program, and then contact the software publisher. can any 1 help me pls? i try SQL 2008 but i cant understand it o.o if you help me i make you gm :)



All times are GMT +1. The time now is 12:36.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.