sunny.tjk
SSCertifiable
Points: 5041
More actions
August 4, 2010 at 3:31 pm
#141494
Would it make sense to separate 2 databases on different LUNS, considering one db to be highly transactional and the other more of a data warehouse type?
thanks everyone.
Lynn Pettis
SSC Guru
Points: 442467
August 4, 2010 at 3:34 pm
#1202413
If you can get them on different LUNS that are comprised of different and dedicated spindles, yes, do it that way.
Adiga
One Orange Chip
Points: 27284
August 4, 2010 at 10:50 pm
#1202486
If you have the resources, you may also spread the data files of those databases on different LUNs to boost performance.
Pradeep Adiga Blog: sqldbadiaries.comTwitter: @pradeepadiga
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply