What is the benefit of putting indexes in a different file group.
I've use file groups to "organize" subject areas within a Data
Warehouse, but have never had the luxury of having a big enough server
to assign a file group to a separate disk (or set of disks). Isn't the
benefit of file groups related to disk and separating the read/writes
per file group / disk??
-----Original Message-----
From: Trevor Weir
[mailto:mssqldba-ezmlmshield-x41143276.[Email address protected]
Sent: Wednesday, July 27, 2005 5:17 PM
To: LazyDBA Discussion
Subject: RE: Filegroups
Each file group is specific to one database.
1. Back up the database.
2. In Enterprise Manager, create separate file groups for indexes and
data (you can even split them into groups like datagroup1, datagroup2,
index1,index2, etc) by right-clicking a database, Properties,
Filegroups.
3. Go to the Data Files tab and create 1 file for each file group (you
can have multiples, but if your db is set to auto grow, the db won't
expand until ALL files in the file group that needs to grow are full).
4. Double-click each table you want to relocate, click the properties
button (2nd from the left next to the save button"), and move it to the
appropriate filegroup. Depending on the size of the table, it could take
a while. Once you tell it to save the changes DO NOT INTERRUPT IT.
5. To move the indexes, right-click a table, go to all tasks, then
manage indexes. Edit each index you want moved and change the file
group. Once again, DO NOT INTERRUPT IT.
Trevor
-----Original Message-----
From: Chris Wood
[mailto:mssqldba-ezmlmshield-x91690729.[Email address protected]
Sent: Wednesday, July 27, 2005 11:30 AM
To: LazyDBA Discussion
Subject: Filegroups
Hi,
I have an instance of sql server that is giving performing poorly, I
have already moved the database log file to another drive and checked
that the correct indexes are in place & the server has the correct
setup.
The main logical data drive is now 190gb big (over 140g of which is
free) this obviously made of up of a number of physical drives within
the Raid 5 set. Do I have to get the network guys to split this logical
drive into a number of logical drives before I can separate the single
datafile into a number of filegroups and place them on separate disks to
gain performance?
Does sql server put objects onto the primary filegroup unless specified?
how do I move some of this data across a number of filegroups to try and
improve performance.
----------------------------------------------------------------------
Scope is a registered charity number 208231.
Visit our website at http://www.scope.org.uk
This message, and any file(s) transmitted with it are confidential and
are intended only for the person(s) to whom they have been addressed by
the sender. This message may contain confidential and/or privileged
material. If you are not the intended recipient of this message, or if
you believe it was transmitted to you in error, you are required to
delete the message and any copies of it, and to notify the sender
immediately. Any unauthorised disclosure, copying, distribution, or
printing of this message or accompanying files, or unauthorised use of
any information contained therein, by anyone other than the intended
recipient(s) is prohibited and may be unlawful.
Any views expressed in this message or in any file(s) transmitted with
it are those of the author, and may not necessarily represent the views
of Scope.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page