file group creation .

We have database of 3 GB . Database growth is 2% every week . I would like to know whether I should use secondory filegroups . Will creation of filegroups will increase the performance of SQL server . What is the impact of creation of these filegroups in longer terms ?
How should I map important tables and their indexes to one filegroup .
Thanks in advance .
Swati.
**********************************************************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...Hi
Only put filegroups in place if you have multiple volumes, running against
different disks on your server, preferably on different controllers. 3Gb is
not big and growth is not high enough to justify it.
On Table and Index creation, you can specify where to put the object with
the "ON" option for those commands. See BOL.
Cheers
Mike
"swati zingade" wrote:
> We have database of 3 GB . Database growth is 2% every week . I would like to know whether I should use secondory filegroups . Will creation of filegroups will increase the performance of SQL server . What is the impact of creation of these filegroups in longer terms ?
> How should I map important tables and their indexes to one filegroup .
>
> Thanks in advance .
> Swati.
>
> **********************************************************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
>|||> We have database of 3 GB . Database growth is 2% every week . I would like
to know whether I should use secondory filegroups . Will creation of
filegroups will increase the performance of SQL server . What is the impact
of creation of these filegroups in longer terms ?
> How should I map important tables and their indexes to one filegroup .
Here are some tips: http://www.sql-server-performance.com/filegroups.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Hi
Unless you have a separate disc sub-system to locate the additional
filegroup, there will probably be little performance benefit to gain by
having the extra one. Even then, it will depend on how the tables/indexes are
used as to whether multiple data files for a single filegroup or two separate
files groups will produce the most benefit.
You may want to check out the "SQL Server 2000 Performance Tuning Technical
Reference" ISBN 0-7356-1270-6
http://www.sql-server-performance.com/
John
"swati zingade" wrote:
> We have database of 3 GB . Database growth is 2% every week . I would like to know whether I should use secondory filegroups . Will creation of filegroups will increase the performance of SQL server . What is the impact of creation of these filegroups in longer terms ?
> How should I map important tables and their indexes to one filegroup .
>
> Thanks in advance .
> Swati.
>
> **********************************************************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
>|||Swati,
I have done extensive testing on this and have found that performance
can be DEGRADED by having multiple data files IF the data files reside
on the same volume.
You can get some performance benefit if the filegroups are placed on
separate physical disks preferably through separate disk or RAID
controllers. You will need to carefully decide what data you will be
putting in the filegroups to reap this performance gain.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
swati.zingade@.ugamsolutions.com wrote:
> We have database of 3 GB . Database growth is 2% every week . I would like to know whether I should use secondory filegroups . Will creation of filegroups will increase the performance of SQL server . What is the impact of creation of these filegroups in longer terms ?
> How should I map important tables and their indexes to one filegroup .
>
> Thanks in advance .
> Swati.
>
> **********************************************************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...