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.

MS Sql Server LazyDBA home page