Pages: 1 2 3 4 5 [6] 7 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 6 post(s) |
WhitePhantom
Gallente Edenists
|
Posted - 2007.08.05 23:33:00 -
[151]
Originally by: MagnaLord Finally i've understood why the dev team took out Bookmarks to gates (they was giving lag) and why all those database server issues
in two words... Microsoft SQLServer
i don't understand why there still is ppl that think they can develop serious business applications with it... Go Oracle...
Please
Don't you at least have something other then basicly Oracle is better then MSSQL?
|
Lord Zim
|
Posted - 2007.08.06 01:46:00 -
[152]
Edited by: Lord Zim on 06/08/2007 01:46:39
Originally by: MagnaLord Finally i've understood why the dev team took out Bookmarks to gates (they was giving lag) and why all those database server issues
in two words... Microsoft SQLServer
Excuse me, but what? Where did you get that information from?
Originally by: MagnaLord i don't understand why there still is ppl that think they can develop serious business applications with it... Go Oracle...
I must admit, this statement also makes me wonder where you get that from. especially since I've seen sql servers with 7000-8000 sql databases of up to 50-1000mb each, and we've got toy databases of no more than 40-50GB which is quite core to our business, AND the mailsystem I've got to admin has 3-4 million emails going through it via smtp, and with 10+ million pop/imap connections every day ... each of which all initiate at least 5 sql calls each. None of them hardly ever give me grief. Nigh-on each and every time we've had a problem with the server, it's been because of user error, or insufficient hardware. We had a bit of a locking issue with the mailserver sql server, which was because it was running on 3 year old hardware. And each and every time a user on the server with 7000-8000 databases on it has complained, he's managed to create a lock situation himself. Which had solved itself before we got there.
So, what have you done with sql server that was so traumatizing?
(Edit: removed duplicate sentences)
|
zombu2
Caldari Nubs. D-L
|
Posted - 2007.08.06 07:26:00 -
[153]
is it MSSQL fixed yet?? (oh wait you can t fix broken by design )
My Sig got hijacked by a Wookie like it is my fault your webserver has only a 10Mb Hdd [gold] Your signature exceeds the maximum |
Panshun
Raw Edge O X I D E
|
Posted - 2007.08.06 11:41:00 -
[154]
Edited by: Panshun on 06/08/2007 11:41:44 As someone rightly pointed out in another thread, if you think about the architecture and database requirements of this game they aren't really that massive in todays terms. In short, I'm pretty sure that technically MS SQL Server can cope. Most of the entities in the model are going to be static tables, very few are going to be massively hit live tables. Not saying that there aren't a large number of transactions, but as they're probably only going to be a few entities involved with those it's not going to be beyond the ken of a reasonable systems designer to tweak/tune and partition the hell out of said tables. Market, ship positions/status maybe being the largest, and there are so many ways to skin those requirements it's pretty much an exercise in futile intellectual ************ to even try guessing how CCP have modelled those.
The only possible 'omg! your using MS SQL wah!' I can raise is it's stability and scalability. I spent most of the end of my career (yep, I've quit IT now, feels good) designing Data Warehouses which start around a terabyte in size and grow from there, mostly on MMP hardware. I used Oracle extensively , because its the most stable and scalable/distributable. I don't think eve needs anywhere near the kind of performance in database terms of your average large scale business app. For example, way back I was one of the designers for the trading backbone of the London Stock Exchange, now that was a massive OLTP system really. What effected the 'what database platform ?' decision there was what would run on the fault tolerant boxes, and what would let us design an effective and elegant method of getting that amount of transactions moved around quickly enough. This was Oracle again, but none of the core tools were built using any of the Oracle development products. Eve isn't going to be anywhere near that level of throughput requirement anytime soon.
Using Oracle for eve would to me be a serious financial fail, looking at the hardware architecture CCP have the costs would be silly high considering Oracles pricing model. Also, the cost of switching database, to any database (DB2 whatever) would be quite mad. Doing so would also possibly result in all manner of new problems too of course until things get resettled.
As it goes, the platform is never really that important in terms of performance as the main RDBMSs stand today. What is important though is the physical design of the database, thats where you get your performance, and you design based on whatever your platform does best tbh as well as common sense.
So, the only issue is stability, which you can sort out with redundancy, live backups, replication etc, etc. Dunno myself what you can do in MS SQL in that regard, but I've always found that hardware solutions are best there. For example I once had a couple of terabyte sized database being continuosly mirrored (hardware solution) once. I could switch to mirrored version simply by pressing a couple of buttons and point the RDBMS at the new instance (literally a few seconds work).
Basically, bashing MS SQL Server is pointless, as much as I personally hate the product I'm sure it's up to the job its being asked to do here.
|
Cardnyl Sin
Gallente Agony Unleashed Agony Empire
|
Posted - 2007.08.06 13:19:00 -
[155]
I know its a long shot but any chance we could get some reimbursement time tacked onto our accounts collectively?
Some of my former MMOs used to do this and it was much appreciated. -So newbie its not even funny.- |
Dr Slaughter
Coreli Corporation Corelum Syndicate
|
Posted - 2007.08.06 15:11:00 -
[156]
Originally by: Panshun Edited by: Panshun on 06/08/2007 11:41:44(yep, I've quit IT now, feels good)
Lucky sod.
Pity they don't seem to be able to put the market onto it's own instance and effectively go active/active on the db cluster.
Originally by: Red Button Someday (hopefully soon. 30/08/2003) load balancing across SOL servers will be fluent and load will shift between servers as the service loa |
Pelf Matagraph
|
Posted - 2007.08.06 16:46:00 -
[157]
God I hate these discussions. But I have to throw my hat in the ring like the techie chump I am.
As face value I'd have to say that MySQL outclasses anything, if you can use it's feature set- there's some things it doesn't do well.
I've three MS server 2003 running MSSQL. I personally want to shoot them, every day, twice a day. On the flip side I have 30 datacenter machines running MySQL under RHE4 and RHE5 with nary a problem.
I'd vote MySQL on Linus (or BSD) every time.
But I don't know anything really. I'm just the IT Director for a US Non-Profit corp, and I own an ISP.
Although I have to admit second guessing CCP without having had my hands in their server farm (That's cluster for the technical nigglers) is quite arrogant on my part.
-- I don't post on my main. The reason is simple- to remain obscure. EVE as a society is a rough place, and I like being anonymous. I'm not afraid. I'm just prudent. |
Razer Morphis
Minmatar Sebiestor tribe
|
Posted - 2007.08.06 17:55:00 -
[158]
Everyone knows MSSQL is a joke.
Everyone except CCP.
Oracle/PostgreSQL, anyone?
----------------------
|
Yagyu Retsudo
|
Posted - 2007.08.06 18:37:00 -
[159]
I suppose to be fair we cannot blame MSSQL.
We can blame CCP's implementation of it. There are far more mission-critical applications running 24/7/365 all around the world, all of which handle vastly larger amounts of transactions per second. All of which, if they failed, would have serious, far-reaching economic consequences.
My patience is wearing thin with the geniuses in Iceland, and that should be a wakeup call, since I love their game. My tip - ambulation in stations is cool and all - I heard the dev on video mention FPS no less than 4 times while describing the technology - I merely hope that you fix what's broke before you add yet another layer of complexity.
|
Wanoah
Minmatar NeuroGEN
|
Posted - 2007.08.06 23:23:00 -
[160]
Originally by: CCP Wrangler
We have been diagnosing this as much as possible, we have an open support request at Microsoft and we have gotten senior consultant from a company called Miracle to look over the errorlogs and traces with us, with no luck at all.
A company called Miracle, eh? Well, let's hope they can come up with a miracle.
Actually, Miracle support some of our Oracle servers where I work. Good people there.
|
|
Nadjar
|
Posted - 2007.08.07 00:10:00 -
[161]
Not another crash? No sig here, move along. |
Syril Mert
Dawn of a new Empire Pure.
|
Posted - 2007.08.07 00:15:00 -
[162]
Yup. Another crash. Time to go to bed :)
|
hUssmann
Caldari Veto. Veto Corp
|
Posted - 2007.08.07 00:16:00 -
[163]
Edited by: hUssmann on 07/08/2007 00:16:06 And once again the server is crashing and causing major desync, I'm getting really sick of this.
Ginger Magician > You are merely an effective ganker of haulers who runs at the first sign of combat. |
Lucky 8
Minmatar
|
Posted - 2007.08.07 00:17:00 -
[164]
Edited by: Lucky 8 on 07/08/2007 00:17:43 You guys need to stop sending out emails.
Quote: WE'VE UPGRADED OUR LAG-FIGHTING WEAPONS TO SHARKS WITH FRIGGIN' LASER BEAMS
Kinda rings hollow. --
Originally by: Nicho Void This thread is like a chum slick for forum alt trolls.
|
DirtyHarry
Caldari Reikoku Band of Brothers
|
Posted - 2007.08.07 00:17:00 -
[165]
node crash while a trade was open, all items are gone, gg ccp, time to join the 20day reimbursement queue.
Havocide - DirtyHarry |
Delusion 'Fel
Minmatar Nefarious Ratiocinations
|
Posted - 2007.08.07 00:20:00 -
[166]
eve yo-yo ing here, up 2 mins down a min, up 3 mins, down a min...... not sure wether to stick it out (need to wait 45 mins to free up a manufacturing queue... >.< ) or go to bed :S
|
Cowerpower
Gallente Center for Advanced Studies
|
Posted - 2007.08.07 00:21:00 -
[167]
Server took a dump at 00:02 in the middle of fighting 20+ rats. Full T2 fitted Domi go bubye most likely.not even time to warp (qq) Might be a good idea to postpone this upgrade till the current issues are resolved ?
|
Alatari
Winterdawn
|
Posted - 2007.08.07 00:27:00 -
[168]
Got disconnected 15mins or so again, but was able to reconnect to the server also immediately. Since (i) there were 18K people online when I reconnected and (ii) a number of my other applications (IM, webbrowers) also 'disconnected' I suspect this was caused by a network problem elsewhere and not CCP's servers.
-- You can't do that with a Planet. |
Alrione
Amarr Black Lagoon Inc.
|
Posted - 2007.08.07 00:29:00 -
[169]
I got disconnected with trade open. Great >.< Bunch of stuff is just gone now. CCP tell yor cleaners not to pull any plugs -------------------------------- Your signature exceeds the maximum allowed dimensions of 400x120 pixels and filesize of 24000 bytes -Sahwoolo Etoophie |
Zauran
|
Posted - 2007.08.07 00:35:00 -
[170]
OK it will be soon be 4 days of this incident not resolved. CCP, have you started to send some of the fingers of the Microsoft on-site techies to Redmond? Not that MSoft would particularly care, but it would be fun anyway...
Seriously, we can go on about MSSQL this and MySQL that but the bottom line is - sort this effin s**t out. 4 days is way too long for these sorts of problems to get resolved. C'mon dream team, you can do it! (can you?)
|
|
Steph Wing
Gallente The Graduates Brutally Clever Empire
|
Posted - 2007.08.07 00:38:00 -
[171]
Has it occured to anyone else that the mods prefer a single topic about such issues not because it reduces clutter, but because it makes the issue easier to ignore?
About TGRAD |
KillinVillin
Synergy. Imperial Republic Of the North
|
Posted - 2007.08.07 00:46:00 -
[172]
Does anyone even know what time it is over there?
Originally by: CCP Wrangler Well, I didn't write it.
|
Torquemanda Corteaz
Gallente Infinite Improbability Inc Mostly Harmless
|
Posted - 2007.08.07 00:57:00 -
[173]
the new ramsan that will hopefully alleviate the current strain that the database is under (which is what is causing the crashes) was supposed to be installed last tuesday
HOWEVAR the ramsan is currently in H&M customs and excise in the UK and the addition of it is delayed till it is released.
So please send all hatemail and death threats to customs
|
Rabbit Boiler
|
Posted - 2007.08.07 01:07:00 -
[174]
Originally by: Torquemanda Corteaz the new ramsan that will hopefully alleviate the current strain that the database is under (which is what is causing the crashes) was supposed to be installed last tuesday
HOWEVAR the ramsan is currently in H&M customs and excise in the UK and the addition of it is delayed till it is released.
So please send all hatemail and death threats to customs
If you do send HM Customs and Excise any hate they lock you up in Belmarsh. No trial, no charge. Just a black van in the night.
|
Sleepkevert
Paradox v2.0 Interstellar Alcohol Conglomerate
|
Posted - 2007.08.07 01:24:00 -
[175]
Edited by: Sleepkevert on 07/08/2007 01:26:28
Originally by: Cowerpower Server took a dump at 00:02 in the middle of fighting 20+ rats. Full T2 fitted Domi go bubye most likely.not even time to warp (qq) Might be a good idea to postpone this upgrade till the current issues are resolved ?
Actually (believe it or not), this upgrade is meant to resolve some issues READ BEFORE YOU EVEN POST "FIX BEFORE CONTENT" ITS GETTING LAME NOW...
Oh, and for CCP, keep up the good work. And, yeah, I also got disconnected so something is going on.
EDIT: Just look at this shiny graph. Shows the disconnect quite nicely...
|
Torquemanda Corteaz
Gallente Infinite Improbability Inc Mostly Harmless
|
Posted - 2007.08.07 02:19:00 -
[176]
Originally by: Rabbit Boiler
If you do send HM Customs and Excise any hate they lock you up in Belmarsh. No trial, no charge. Just a black van in the night.
I know sending any hate mail to a government organization is just asking for trouble... but you had to spoil my fun didn't you?
|
Gedulous
|
Posted - 2007.08.07 02:47:00 -
[177]
Folks,
I'm a professional SQL Server DBA working for EDS Australia. I have access to some pretty high level partner resources. If you want a hand, feel free to let me know a bit more about what's going on and I'll see what I can chase up for you. If you're getting any error messages it would be nice to see what they are. Information about hardware, server version and patch level would also be handy. In the past I've seen this kind of thing end up being related to HBA, onboard array controller and NIC driver bugs. Have you ensured that all your drivers and firmware are patched to the latest level? If you want to contact me to discuss further, get in touch via our Adelaide office on +61 8 8464 1111.
A response to all the *n*x-bigots out there... SQL Server benchmarks pretty close to the other (far more expensive) DBMSs out there in terms of TPC, with much better price per transaction than most. MySQL doesn't even rate a mention on TPC.
Saying "PC hardware doesn't cut it" is just ignorant... especially given that most of the large RISC unix players are starting to move towards Intel or AMD chips. Take a look at the Sunfire X4600's or HP Superdome blade rigs if you don't believe the "PC" platform is performant. CISC has been outperforming RISC for about 5 years - get over it. Hell... and for those suggesting LINUX in the same paragraph as "PC Hardware sux"... what hardware platform do you think LINUX runs on?
Speaking of which... aside from the cost differential with licensing, do you have any idea how much more effort (i.e. labour cost) Oracle takes to administer than MS SQL Server? Or how long it can take to get Oracle to provide hotfixes compared with Microsoft? Oracle DBA's spend a lot more time micromanaging their DBMS than MS SQL DBAs.
If you're going to have a ***** at the CCP guys for their choice of platforms, at least understand what the drivers for their choice might have been! If your criticism is INFORMED, then I'll maybe listen to it, but uninformed criticism is just a sign of mental laziness and I have nothing but contempt for that trait.
Regards
Geddrick ANZAC Eclectic Defense Syndicate
|
Mannington Skank
Gallente Allied Secret Service Operations
|
Posted - 2007.08.07 04:21:00 -
[178]
All I want to know, is when do we get some compensation for the downtime? Blizzard gives a free day of service for downtime... Turbine used to, Sony still does, and I think its time CCP started reimbursing (spelling) us for downtime. Server down for over an hour? I want an hours subscription added to my account. I do not feel that this is too much to ask for. And yes, I know about what the eula says reguarding this...
|
ReePeR McAllem
The Carebear Stare
|
Posted - 2007.08.07 11:23:00 -
[179]
Originally by: Mannington Skank All I want to know, is when do we get some compensation for the downtime? Blizzard gives a free day of service for downtime... Turbine used to, Sony still does, and I think its time CCP started reimbursing (spelling) us for downtime. Server down for over an hour? I want an hours subscription added to my account. I do not feel that this is too much to ask for. And yes, I know about what the eula says reguarding this...
QFT!
|
Amaron Ghant
Caldari b00's Crew
|
Posted - 2007.08.07 12:27:00 -
[180]
Originally by: Mannington Skank All I want to know, is when do we get some compensation for the downtime? Blizzard gives a free day of service for downtime... Turbine used to, Sony still does, and I think its time CCP started reimbursing (spelling) us for downtime. Server down for over an hour? I want an hours subscription added to my account. I do not feel that this is too much to ask for. And yes, I know about what the eula says reguarding this...
If you know what the EULA says about this, and you agreed to it when you created your account, why the hell bang on about it now? |
|
|
|
|
Pages: 1 2 3 4 5 [6] 7 :: one page |
First page | Previous page | Next page | Last page |