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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2007-06-22 : 09:44:07
|
| I have a database that has been running well for a few years.It has a single data file.It has now become very large and is creaking and running slow sometimes.Is it possible to now create a secondary data file or do i have other options?Many Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-22 : 10:09:44
|
| Yes you can create another file and it will use that file until the two are the same size then it will expand them alternately.I doubt if this will have much affect on the performance though - sounds like you should review the queries and indexing.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-22 : 15:20:38
|
| Unless you put second data file on another disk array. |
|
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2007-06-22 : 23:46:56
|
| Thanks for the info.Is it likely to make a noticeable difference to performance if I put the new data file on a separate disk array? Or would i be better concentrating my efforts on learning how to optimise queries and indexes...ALso can i throw something else into the mix. What about filegroups - is it common practise to create more than one filegroup and does this also aid performance (if done properly) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-23 : 22:01:17
|
| If you put all filegoups in same disk array, you'll not get much performance gain. Does put data file on different disk have noticeable performance gain? Depends. If you never had disk contention, then not help much. |
|
|
|
|
|
|
Can i move to a secondary data file