sybase11.9.2 數(shù)據(jù)庫設(shè)備最多能支持多少？

aokzhu

由于客戶的數(shù)據(jù)庫增長較快，目前已經(jīng)有30多G了，數(shù)據(jù)設(shè)備已經(jīng)增加到13個(gè)（每個(gè)2G）。

如果數(shù)據(jù)庫不斷增長，客戶擔(dān)心某個(gè)時(shí)點(diǎn)，數(shù)據(jù)庫會(huì)不會(huì)“崩潰”？

關(guān)于Sybase數(shù)據(jù)庫方面有個(gè)疑問想確認(rèn)一下：

    sybase 11.9.2最多能夠支持多少個(gè)設(shè)備文件阿？有沒有官方的說明文件？

  
了解此方面的各位高手，請賜教。

andkylee

255個(gè)。不用擔(dān)心。 每次初始化的時(shí)候把size搞大一點(diǎn)，2G太小。 離用完還遠(yuǎn)著呢！
每個(gè)設(shè)備的大小，在12.x版本上是32G。感覺11.9.2應(yīng)該也是32G。

sunlan

回復(fù) 1# aokzhu


vdevno – is the virtual device number. It must be unique among the
database devices associated with Adaptive Server. The device
number 0 is reserved for the master device. Valid device numbers
are between 1 and 255, but the highest number must be one less
than the number of database devices for which your Adaptive
Server is configured. For example, for an Adaptive Server with
the default configuration of 10 devices, the available device
numbers are 1–9. To see the maximum number of devices
available on Adaptive Server, run sp_configure, and check the
number of devices value.

sybasefans

每個(gè)設(shè)備最多多大？