数据库大小问题 [英] Database size question
问题描述
我们的数据库大小目前为4G,并且以每天45亿美元的价格递增。 SQL数据库的最大大小是多少?什么是
大小超出服务器性能将开始下降?
Our database size is currently 4G and is incrementing at a rate of
45M/day. What is the max size of a SQL database? And what is the
size beyond which the server performance will start to go down?
推荐答案
dchow写道:
dchow wrote:
我们的数据库大小目前是4G,并且以45M /天的速度递增。 SQL数据库的最大大小是多少?什么是服务器性能开始下降的尺寸?
Our database size is currently 4G and is incrementing at a rate of
45M/day. What is the max size of a SQL database? And what is the
size beyond which the server performance will start to go down?
在什么硬件上?
从我坐的地方你可能已经通过了这一点你只是
我也不知道。
但是直到最终用户开始抱怨我会留在你的位置
做好准备
归档不需要的东西或转移到Oracle,DB2或Informix上
UNIX平台。
-
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach .washington.edu / e ... oa / aoa_crs.asp
da ***** *@x.washington.edu
(替换''x'''用'u'来回复)
On what hardware?
From where I sit you''ve probably already passed that point you just
don''t know it.
But until end-users start complaining I''d stay where you are while
getting ready to either
archive off what isn''t required or move to Oracle, DB2, or Informix on a
UNIX platform.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace ''x'' with a ''u'' to reply)
IBM服务器上的SQL server 2000,带四核CPU,4G内存,50G SCSI硬件
磁盘。我没有服务器和CPU型号。
2003年10月27日星期一15:41:17 -0800,Daniel Morgan
< da ** ****@x.washington.edu>写道:
SQL server 2000 on IBM server with quad CPU, 4G memory, 50G SCSI hard
disk. Didn''t have the server and CPU model with me.
On Mon, 27 Oct 2003 15:41:17 -0800, Daniel Morgan
<da******@x.washington.edu> wrote:
dchow写道:
dchow wrote:
我们的数据库大小目前为4G,并以45M /天的速度递增。 SQL数据库的最大大小是多少?什么是服务器性能开始下降的大小?
Our database size is currently 4G and is incrementing at a rate of
45M/day. What is the max size of a SQL database? And what is the
size beyond which the server performance will start to go down?
在什么硬件上?
我坐在哪里你'可能已经过了这一点你只是不知道它。
但是在最终用户开始抱怨之前我会留在原地准备
准备好了要么存档不需要的内容,要么在UNIX平台上移植到Oracle,DB2或Informix。
On what hardware?
From where I sit you''ve probably already passed that point you just
don''t know it.
But until end-users start complaining I''d stay where you are while
getting ready to either
archive off what isn''t required or move to Oracle, DB2, or Informix on a
UNIX platform.
dchow写道:
dchow wrote:
IBM服务器上的SQL Server 2000具有四核CPU,4G内存,50G SCSI硬盘。没有我的服务器和CPU型号。
SQL server 2000 on IBM server with quad CPU, 4G memory, 50G SCSI hard
disk. Didn''t have the server and CPU model with me.
你说50G SCSI硬盘就像是一个单独的磁盘?任何RDBMS的情况都不是很好
。
我会说你已经远远低于其他RDBMS产品了。
可以做。但是,这是不是很重要?直到最终用户开始注意到差异或某些
流程开始花费的时间比窗口允许的时间更长
。
- -
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
< a href =mailto:da ****** @ x.washington.edu> da ****** @ x.washington.edu
(替换'' x''和'u''回复)
You say 50G SCSI hard disk like it is a single disk? Not a good
situation with any RDBMS.
I''d say your are already runnnig far under what other RDBMS products
could do. But does
it matter? Not until end-users start to notice a difference or some
process starts taking longer
than its window allows.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace ''x'' with a ''u'' to reply)
这篇关于数据库大小问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!