Vendor has produced a Read Only system for us in SQL
Server 2000.
The database size is around 10GB and there are around 2000
tables in it.
I find that they have configured the database to use 5
files in the primary filegroup with size of 2GB each. All
of them are located in a RAID 1 disk. The autogrow is not
enabled for that database as it is READ ONLY.
I would like to know what is the benefit of placing them
in 5 files in a filegroup instead of 1 single physical
file ? Is it due to performance issue ?
ThanksThis is a multi-part message in MIME format.
--020103050106080203040701
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
If they're all on the same spindle then there is no benefit. They may
as well have had them in a single file.
The main reason for multiple files in a filegroup is improving
performance by putting the files on different spindles (and also when
you get low on disk space on one logical volume you can seamlessly
"extend" the filegroup by adding another file to it that resides on a
different logical volume (presumedly with more disk space)).
Perhaps the vendor meant to actually locate the 5 physical files on 5
separate RAID arrays but...forgot?
--
*mike hodgson*
/ mallesons stephen jaques/
blog: http://sqlnerd.blogspot.com
Stephen wrote:
>Vendor has produced a Read Only system for us in SQL
>Server 2000.
>The database size is around 10GB and there are around 2000
>tables in it.
>I find that they have configured the database to use 5
>files in the primary filegroup with size of 2GB each. All
>of them are located in a RAID 1 disk. The autogrow is not
>enabled for that database as it is READ ONLY.
>I would like to know what is the benefit of placing them
>in 5 files in a filegroup instead of 1 single physical
>file ? Is it due to performance issue ?
>Thanks
>
--020103050106080203040701
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>If they're all on the same spindle then there is no benefit. They
may as well have had them in a single file.<br>
<br>
The main reason for multiple files in a filegroup is improving
performance by putting the files on different spindles (and also when
you get low on disk space on one logical volume you can seamlessly
"extend" the filegroup by adding another file to it that resides on a
different logical volume (presumedly with more disk space)).<br>
<br>
Perhaps the vendor meant to actually locate the 5 physical files on 5
separate RAID arrays but...forgot?<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<em><font face="Tahoma" size="2"> mallesons</font><font face="Tahoma"> </font><font
face="Tahoma" size="2">stephen</font><font face="Tahoma"> </font><font
face="Tahoma" size="2"> jaques</font></em><font face="Tahoma"><br>
</font><font face="Tahoma" size="2">blog:</font><font face="Tahoma"
size="2"> <a href="http://links.10026.com/?link=/">http://sqlnerd.blogspot.com">
http://sqlnerd.blogspot.com</a></font></span> </p>
</div>
<br>
<br>
Stephen wrote:
<blockquote cite="mid033901c57851$56fa1040$a501280a@.phx.gbl" type="cite">
<pre wrap="">Vendor has produced a Read Only system for us in SQL
Server 2000.
The database size is around 10GB and there are around 2000
tables in it.
I find that they have configured the database to use 5
files in the primary filegroup with size of 2GB each. All
of them are located in a RAID 1 disk. The autogrow is not
enabled for that database as it is READ ONLY.
I would like to know what is the benefit of placing them
in 5 files in a filegroup instead of 1 single physical
file ? Is it due to performance issue ?
Thanks
</pre>
</blockquote>
</body>
</html>
--020103050106080203040701--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment