Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Database device sizings

2 posts in Windows NT Last posting was on 2000-03-10 07:16:46.0Z
Puvendran Selvaratnam Posted on 2000-03-08 05:19:02.0Z
From: "Puvendran Selvaratnam" <puvendran.selvaratnam@btfinancialgroup.com>
Subject: Database device sizings
Date: Wed, 8 Mar 2000 16:19:02 +1100
Lines: 18
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <PANoC6Li$GA.74@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: aupozx665.btal.com.au 203.10.111.3
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2442
Article PK: 1089895

Hi all,

At our site (NT 4 , ASE 11.5.1) we have tended create devices for our bigger
databases in chunks of 1 GB.

Is there benefits in increasing this size apart from running out of "number
of allowable devices" in due course ?

We employ RAID 5 technology.

Thanking you in advance

Puvendran


Gary Estridge Posted on 2000-03-10 07:16:46.0Z
From: "Gary Estridge" <aaaa@aaaa.com>
References: <PANoC6Li$GA.74@forums.sybase.com>
Subject: Re: Database device sizings
Date: Fri, 10 Mar 2000 02:16:46 -0500
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <oyGIGFmi$GA.74@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 199.orlando-08-09rs.fl.dial-access.att.net 12.77.195.199
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2433
Article PK: 1089886

Smaller devices can mean more trouble to recreate if you have a disaster.
If you had multiple raid devices you would be able to better spread your IO
across different devices(log and data on separate devices etc.). Even with
one RAID device make sure your still creating separate data and log devices
to help your IO throughput.

Gary Estridge
Sr. Consultant
Sybase Professional Services

"Puvendran Selvaratnam" <puvendran.selvaratnam@btfinancialgroup.com> wrote
in message news:PANoC6Li$GA.74@forums.sybase.com...
> Hi all,
>
> At our site (NT 4 , ASE 11.5.1) we have tended create devices for our
bigger
> databases in chunks of 1 GB.
>
> Is there benefits in increasing this size apart from running out of
"number
> of allowable devices" in due course ?
>
> We employ RAID 5 technology.
>
> Thanking you in advance
>
> Puvendran
>
>
>
>
>