Physical Database Design | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Physical Database Design

We have our production database on a single file group and on a single disk.
Now we are in the process of physically desinging the database where we are splitting the single database file group into number of files groups and to reside on different disks. Our database file is hosted on SAN(Storage Area Network). We need to know the steps to be taken for the grouping of tables and indexes across the filegroups/disks. (I’ve deleted other posts that has no reply, moving this thread to Perf.Tuning HW for relvancy)
Please don’t duplicate your posts.
This has been mantion by many poeple on this forum.
So Please delete one of them.
quote:Originally posted by ganesh_srinivasan We have our production database on a single file group and on a single disk.
Now we are in the process of physically desinging the database where we are splitting the single database file group into number of files groups and to reside on different disks. Our database file is hosted on SAN(Storage Area Network). We need to know the steps to be taken for the grouping of tables and indexes across the filegroups/disks.

Check other similar posts in this forum for further information.
By default, indexes are created on the same filegroup as the base table on which the index is created. However, it is possible to create nonclustered indexes on a filegroup other than the filegroup of the base table. http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=7825 for relevant information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>