MIS Systems Thread, SQL2008 in Technical; Hi, anyone using the SIMs SQL 2008 server for other applications at the same time as SIMs?
i was thinking ...
19th November 2010, 11:12 AM #1
- Rep Power
Hi, anyone using the SIMs SQL 2008 server for other applications at the same time as SIMs?
i was thinking that just using for SIMs and not other applications is a waste of SQL 2008.
any ideas or thoughts?
19th November 2010, 11:54 AM #2
I have 3 SQL instances on our SIMS/SQL box. All SQL Express though - we should really be moving to SQL Full now, as our SIMS DB is 1.2Gb in size.
I used to have more than one DB per instance, but to maximise memory availability, I've switched to multiple instances instead.
19th November 2010, 12:04 PM #3
- Rep Power
Bit more clarity, it would be the same server not the same SIMs database, the server has 12 Gig ram, intel xeon cpu, raid drives, so its a pretty big spec. i just want 1 server with SQL on it and as we have it on the SIMs server thought that would do
so all i need to do is re run the install, create my databse and that it?
19th November 2010, 12:25 PM #4
Well, I'd recommend installing a second instance on the same server yes. (You are calling an instance a database I think? whereas an instance is a host for any number of database, following the same serving rules/policies etc...).
Originally Posted by stevef1
Yes, that is what you'd do.
By Darylrese in forum MIS Systems
Last Post: 25th March 2011, 01:09 PM
By drdos256 in forum MIS Systems
Last Post: 15th November 2010, 01:05 PM
By mdrabble in forum MIS Systems
Last Post: 14th October 2010, 11:07 AM
By RobFuller in forum MIS Systems
Last Post: 24th March 2010, 10:39 PM
By woodham in forum MIS Systems
Last Post: 6th July 2009, 03:26 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)