+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, SQL setup for SIMS in Technical; Does anyone have any guidance on what settings should be implemented in SQL 2008 R2 Full to run a SIMS ...
  1. #1

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,171
    Thank Post
    431
    Thanked 316 Times in 267 Posts
    Rep Power
    153

    SQL setup for SIMS

    Does anyone have any guidance on what settings should be implemented in SQL 2008 R2 Full to run a SIMS Database? I have a server ready with Server 2008 R2 and 16GB RAM and I just need to install SQL. Are there any tweaks I should be doing to enable it to use both Processors (2 quad cores) and as much RAM as it needs? I have bought 2 x Processor licence so am covered for 2 processors.

    Any pointers would be greatly appreciated.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,639
    Thank Post
    683
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    To begin with just leave it as is. It should be able to use and manage all it needs. You'd only tweak if you were having problems.
    On install, you'll probably get the warning about firewalls, you just need to let the sqlbrowser.exe through Setting up a test from backup

  3. Thanks to vikpaw from:

    fiza (21st July 2011)

  4. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    I've been saying to install Capita's SQL Express then put the 2008 disc in the upgrade the edition then do a new install and install SQL Management studio. Once SQL management studio installed, enable AWE. Not recommending R2 yet. I've yet to hear of a good reason to install it.

  5. #4

    Join Date
    Apr 2010
    Posts
    2,057
    Thank Post
    83
    Thanked 188 Times in 155 Posts
    Rep Power
    84
    I have an install step by step for sql2008r2 but i dont have it with me. I'll mail it later. can you pm me your email.

  6. #5

    Join Date
    Apr 2010
    Posts
    2,057
    Thank Post
    83
    Thanked 188 Times in 155 Posts
    Rep Power
    84
    Are there any tweaks I should be doing to enable it to use both Processors (2 quad cores) and as much RAM as it needs? I have bought 2 x Processor licence so am covered for 2 processors.
    Dont think you need to do anything with processor or ram in sql.

  7. #6

    Join Date
    Mar 2011
    Location
    Bournemouth
    Posts
    280
    Thank Post
    16
    Thanked 74 Times in 64 Posts
    Rep Power
    22
    SQL should use all the memory and cores by default anyway, most of the optimisation comes from designing the IO subsystems.

    As for tweaking SQL itself, you should start with adding additional tempdb files of a reasonable but equal size, one for each core assigned to SQL. You should also ensure that the database file growth options are set correctly. I've seen SIMS databases set to 1MB growth which has terrible overhead and causes horrific OS level fragmentation. I'd recommend you set the database to a fixed size with room to spare, set a reasonable growth size (depends on your database size) and use windows defrag while sql is disabled to ensure the database files are contiguous before going live.

    - Chris

  8. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,639
    Thank Post
    683
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    Growth rate of about an eighth of the maximum you'd want i think is reasonable. My initial is 140MB with growth at 125MB. It doesn't often go crazy, but when it does it's easy to shrink it down again. This was with a nearing 4GB mdf file. I worked it out a while ago, based on best practise, and it seems to be okay.

    If we're talking best practise now, you could look up the threads regarding the type of raid to use for each db, and where to put them, i.e. separate data partitions with temp db separate etc. but there's no point reiterating all that here.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 136
    Last Post: 18th September 2012, 08:42 AM
  2. [SIMS] .Net 4.0 for SIMS Spring Release?
    By hutchy in forum MIS Systems
    Replies: 63
    Last Post: 27th July 2011, 07:54 PM
  3. Who's doing their SQL 2008 Migration for SIMS today?
    By chazzy2501 in forum General Chat
    Replies: 4
    Last Post: 30th April 2010, 11:31 AM
  4. ESXi disk setup for SQL server VMs - advice sought
    By fox1977 in forum Thin Client and Virtual Machines
    Replies: 2
    Last Post: 29th January 2009, 11:34 AM
  5. Problems installing SQL 2005 for SIMS
    By timbo343 in forum Windows
    Replies: 6
    Last Post: 7th November 2007, 10:27 AM

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
  •