SQL2008

[stevef1]

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?

 

stevef1

[localzuk]

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.

[stevef1]

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?

 

thanks

[localzuk]

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?

 

thanks

 

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...).

 

Yes, that is what you'd do.