Database file size for VLDBs

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: wawork@xxxxxxxxxxx (Randy K)
Date: Wed, 19 Apr 2006 21:20:08 GMT

We are about to build our first multi TB raster database on SQL Server
2000. This will be on an IBM SAN made up of SATA drives w/ RAID 5
configuration. Right now we are thinking of doin 4 1TB LUNs or 2 2TB
LUNs.

Either way is there a benefit to creating multiple database files per
LUN vs 1 large database file per LUN? Before raid 5 it would be
necessary to strip across separate drives.

Thanks
Randy K
wawork@xxxxxxxxxxx
.

Prev by Date: Re: Move databases between servers
Next by Date: Re: SQL server re-set up
Previous by thread: SQL Server 2005SP1 does not install ...
Next by thread: SQL 2005 and SP1 integrated
Index(es):
- Date
- Thread

Relevant Pages

Re: Partial reinstall of XPE database
... Thanks, Andy. ... >> D drive was where my XPE database files were installed, ...
(microsoft.public.windowsxp.embedded)
Re: Do I need to set..
... "Sylvain Lafontaine" wrote: ... Right-click on the database | Tasks | Detach... ... the databases on SQL-Server in the same way that you are seeing your MDB ... to individual database files. ...
(microsoft.public.access.adp.sqlserver)
[ANN] Accuracer 1.34 and SQLMemTable 1.31 have been released
... Now Accuracer database files can be compacted and repaired. ... SQL scripts running speed was essentially increased, ...
(borland.public.delphi.thirdpartytools.general)
Re: Sharepoint backing up
... You might find the database files under ... Program Files / MS SQL Server / MSSQL / Data ... What is the likely file name for the database file so I know what ... SBS 2003 installation so we know where we are. ...
(microsoft.public.sharepoint.windowsservices)
Re: Exchange Database Storage Design
... Have a look at http://technet.microsoft.com/en-us/library/bb124518.aspx, which where we have our storage guidance for Exchange 2007. ... is the recommended number of databases per LUN? ... recommended database per LUN ratio? ...
(microsoft.public.exchange.setup)