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 |
|
skumar_nasa
Starting Member
2 Posts |
 Posted - 2011-09-13 : 08:42:26
|
| We use a single database in SQL Server 2005 and the size is around 190 GB. We plan to spilt the database in following methods;1. single instance multiple database without synonyms2. single instance multiple database with synonyms3. multiple instance multiple database Need inputs on the below queries:Which best method we can go for?Pros and Cons of each method?Related help links/guides to split the database in the above types?suresh |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
skumar_nasa
Starting Member
2 Posts |
Posted - 2011-09-14 : 00:38:25
|
| We have 3 applications which depends on this single database. There are some common objects which are used for all the three applications. Apart from this all the other objects are WRT with their applications.For E.g. Abacus is the Database, RMS, CMS and DSM are the 3 applications.Currently these 3 applications have the same Abacus database. so at the time of fixes and releases we have to get the downtime for other 2 applications also, and for taking backup and restore it is taking more time. To avoid that, we planned to split the database, per application. So now Abacus will be split in to Abacus_Common(for Common Objects), Abacus_RMS(RMS objects + common objects), Abacus_CMS(CMS Objects + common objects), Abacus_DSM (DSM Objects + common objects).suresh |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-01 : 14:42:39
|
| If you are going to have multiple instances, you'll need to define max memory settings for each server and preferably you'll hv to mask the cpu as well so that you have dedicated cpu and memory for each instance. This is feasible if your server's hardware resources are abundant. Otherwise go with single instance with multiple databases. |
|
|
|
|
|
|
Inputs - splitting of database - SQL Server 2005