We are in retail business and we operate on 1 Navision Server per region base with around 40-50 users at a time. The data size of SQL database is around 200-300 GB as we expereince heavy surge in data in around 1-2 GB per day. There are around 9 such servers for 9 different locations. The servers are hosted on SUN Blade Servers having quad core processors with aroound 16 GB RAM. Each server is connected to SUN Storagetek 6140( having 16 disks of 146 GB in one expansion) having 146 GB x 4 or 6 disks having data files on RAID 1+0.
Anyways we are expereincing huge problems if someone accesses the system for reports or if someone tries to process some data.
Now the management decides to have 2 regions in 1 Server that means We are going to put 2 Navision SQL Database on 1 Server to save costs (SQL Licence Cost) and we are coming up with more 6 regions.
The management doesnt want to spend on extra servers but is ok on Disks part. But the data will spread across many disks as possible of course in different set of RAID 1+0 luns for both the databases. I would like to know what would be the impact on such a scenario.
First of all is this feasible? Do I need more RAM , more CPU, more disks ?
In some regions there is data around 400 GB. I am worried that there would be some impact on the server with such heavy usage. What would one need to do in such scenario ? What special care i need to take while I do this activity? I would appreciate if all you gurus guide & advice me.