RE: Any problem for using a single data file?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Pankaj Agarwal [MSFT] (pankaja_at_online.microsoft.com)
Date: 09/01/04 

Date: Wed, 01 Sep 2004 22:52:42 GMT

Hello Alex

It depends on what you are trying to achieve. There is no set requirement
or recommendation either way. However creating a lot of small files for a
database could lead to additional maintenance chores. From performance
standpoint, there should really be no difference either way unless you
achieve stripping with multiple database files across several disk
controllers and drives. However for a database of about 20GB in size, this
striping may only give you small performance benefit.

Thank you for using Microsoft newsgroups.

Sincerely

Pankaj Agarwal
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • Re: Any problem for using a single data file?
    ... > Hello Alex ... > database could lead to additional maintenance chores. ... > striping may only give you small performance benefit. ... > Thank you for using Microsoft newsgroups. ...
    (microsoft.public.sqlserver.server)
  • RE: Another design advice
    ... Could you post the reason of such recommendation? ... > One of the main concerns I have is with respect to primary keys. ... > types of transactions such as expenses, payments, deposits, etc... ... > this on the database. ...
    (microsoft.public.sqlserver.programming)
  • Re: open a db connection in a constructor ?
    ... and it doesn't affect the business layer code at at all. ... But you can only switch database - you can not switch to ... There is a performance benefit when you need to render ... It is inadvisable to use data readers in remoting scenarios, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Maximum recommended IS size
    ... bigger the database, the longer it will take to perform database utilities ... like offline defrag, isinteg etc ... Does Microsoft have a recommendation? ...
    (microsoft.public.exchange.admin)
  • Re: database
    ... > Any recommendation for a database with capabilities and features close to ...
    (Debian-User)