Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AlexP
Starting Member
34 Posts |
 Posted - 2005-08-05 : 12:13:34
|
| All,This is scary. I have a client that runs ALL of their mission critical databases on one sql2000 server on one box that is a 700MHZ processor with a GIG of RAM! There are 55 databases running a call center and a fulfillment center.Please offer suggestions as to improve performance and redundancy. I know this is a loaded question.Thanks to all... |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-05 : 12:35:35
|
| from the information you have given us, this could be perfectly acceptable.I think the most important thing you can do is to ensure that all of their databases are being backed up properly. -ec |
 |
|
|
AlexP
Starting Member
34 Posts |
Posted - 2005-08-05 : 12:37:58
|
| thanks for the comment |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-05 : 12:49:29
|
| Backups are the most important, so knock that out first. I would also consider:1. Is their data stored on a RAID?2. is this server from a large vendor (hp, compaq, dell, etc.) or is it pieced together? I would be concerned about hardware failure with an older system like this.3. What kind of budget do they work with? Do they have IT staff on site or are you the guy?4. Have they considered (or do they currently) offsite their tape backups?-ec |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-05 : 12:51:45
|
| Additionally - do they run regular CHECKDBs?Paul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-08-05 : 13:34:15
|
| I totally agree with everything above.If you can afford it, I'd probably set this thing up for Failover Clustering and get some newer machines to set this cluster up on.This is not going to be cheap, but I bet being down for a few hours or days would cost the company a LOT more money.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda> |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-08-05 : 13:54:07
|
| 55 databases?That's a lot of databases for one box in my opinion.What's the transaction activity like?And what are they all for?Do you have 55 separate applications?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-05 : 13:57:31
|
quote:
Originally posted by X002548
55 databases?That's a lot of databases for one box in my opinion.What's the transaction activity like?And what are they all for?Do you have 55 separate applications?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
I once saw a government system with over 500 dbs on one (largish) box - funnily enough they had resource problems.Paul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
|
|
|
|
Cluster/Load Balancing or what?