Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dineshrajan_it
Posting Yak Master
217 Posts |
 Posted - 2010-02-19 : 02:28:06
|
| Hi,i have a db having around 250 tables and more to come by. We have just a primary file. so i have decided to split the filesThese are my Consideration. 1)primary file containing only system tables2)1st .ndf file containing read-only tables3)2nd .ndf file containing highly transaction tables4)3rd .ndf file containing tables with freq used joins .Any corrections needed.Iam a slow walker but i never walk back |
|
|
dineshrajan_it
Posting Yak Master
217 Posts |
Posted - 2010-02-19 : 03:49:34
|
| Hianyone from forum team pls reply back. its indeed imp for me right nowIam a slow walker but i never walk back |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-02-19 : 08:11:49
|
| How big is you databases? You need to Split Data Files across Different Drives to Distribute Workloads. |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2010-02-19 : 14:49:14
|
| Do you have the data and log files on separate spindles?=======================================Few things are harder to put up with than the annoyance of a good example. (Mark Twain) |
|
|
|
dineshrajan_it
Posting Yak Master
217 Posts |
Posted - 2010-02-23 : 01:29:31
|
quote:
Originally posted by sodeep
How big is you databases? You need to Split Data Files across Different Drives to Distribute Workloads.
Well the size goes beyond 1GB for both primary and log fileIam a slow walker but i never walk back |
|
|
|
dineshrajan_it
Posting Yak Master
217 Posts |
Posted - 2010-02-23 : 01:30:06
|
quote:
Originally posted by Bustaz Kool
Do you have the data and log files on separate spindles?=======================================Few things are harder to put up with than the annoyance of a good example. (Mark Twain)
I have them on same spindlesIam a slow walker but i never walk back |
|
|
|
Jaime
Starting Member
19 Posts |
Posted - 2010-02-26 : 23:59:02
|
| Then splitting the database into several files is not likely to accomplish anything useful. What exactly are you trying to accomplish by creating these three secondary files? |
|
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-02-27 : 02:39:08
|
| 1GB is too small. |
|
|
|
|
|
|
Multiple filegroups