Spliting database from 1 to 3 datafiles | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Spliting database from 1 to 3 datafiles

Hi.
I’m doing some performance tests, and I need to split a 90gb database in 3 datafiles.
I created the others datafiles, and of course they are empty, so I’m using dbcc dbreindex(table) to compact my tables and to force SQL Server to distribute the pages between all files. Is there any smart method to split the datapages? Thanks
Esio Nunes
One way is to change each table you need to new filegroup.
For that use Enterprise Manager, Databases, YouDatabase, tables, design, and change Cluster index destination to new filegroup.
Also you can use Alter in Query Analyzer. (Check BOL for Alter details).
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
Sorry, I was thinking in 2000.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
But it is a SAP database, with more or less 40000 tables (this structure scrares me, in SQL 2000 just sysobjects is a 120000 lines in 35MB..), so I’m looking for some massive method.
Since this method (change de filegroup) works, it will be impossible to do. And, on time, I will continue using just one filegroup. I don’t know the database logical design, so, I can’t split my filegroups. Esio Nunes
A 90 GB SAP database isn’t that big at all. It should work real fine with just one file. —
Frank Kalis
Moderator
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de
]]>