+ Post New Thread
Results 1 to 4 of 4
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 ...
  1. #1
    stevef1's Avatar
    Join Date
    Jun 2007
    Posts
    31
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0

    SQL2008

    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

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,154
    Thank Post
    522
    Thanked 2,551 Times in 1,980 Posts
    Blog Entries
    24
    Rep Power
    877
    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.

  3. #3
    stevef1's Avatar
    Join Date
    Jun 2007
    Posts
    31
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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

  4. #4

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,154
    Thank Post
    522
    Thanked 2,551 Times in 1,980 Posts
    Blog Entries
    24
    Rep Power
    877
    Quote Originally Posted by stevef1 View Post
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SQL2008 VERY SLOW FOR ALL USERS
    By Darylrese in forum MIS Systems
    Replies: 63
    Last Post: 25th March 2011, 01:09 PM
  2. [SIMS] Help please with FMS SQL2008 Migration
    By drdos256 in forum MIS Systems
    Replies: 22
    Last Post: 15th November 2010, 01:05 PM
  3. Installing SQL2008
    By mdrabble in forum MIS Systems
    Replies: 3
    Last Post: 14th October 2010, 11:07 AM
  4. SIMS - SQL2005 > SQL2008 Migration Problem
    By RobFuller in forum MIS Systems
    Replies: 26
    Last Post: 24th March 2010, 10:39 PM
  5. Help Please june Update + sql2008
    By woodham in forum MIS Systems
    Replies: 7
    Last Post: 6th July 2009, 03:26 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •