+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Installing SQL 2012 for door access:paths for shared feature directory best practic ? in Technical; Hi I am planning to install SQL 2012 Standard64bit on Windows 2012 for our newdoor access control server. I have ...
  1. #1

    Join Date
    Sep 2012
    Location
    UK
    Posts
    36
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Installing SQL 2012 for door access:paths for shared feature directory best practic ?

    Hi

    I am planning to install SQL 2012 Standard64bit on Windows 2012 for our newdoor access control server.
    I have installed a VM with C partition 50 GB and D partition with 500 GB onour new Windows 2012 server. This server will be a dedicated only for accesscontrol and it will not work hard as SIMS server.
    The prerequisites by the vendor says:
    SQL to be installed in Mixed Mode
    SQL Server Management Studio installed
    500GB Hard Disk space

    During the installation -Feature selection-
    By default the path for :
    Shared feature directory is C:\Program files\Microsoft SQL Server
    Shared feature directory (x86) is C:\Program files\Microsoft SQL Server

    Please suggest, if I need to leave the path for shared feature directory as adefault location C drive:
    or do I need to give a path on D drive:

    Also during the Database Engine configuration is it ok to specify the path as D: for the User database directory or do I need to create additional drives ?
    Please suggest
    Thanks

    Last edited by genesis; 2nd July 2014 at 09:41 PM.

  2. #2


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,649
    Thank Post
    275
    Thanked 780 Times in 607 Posts
    Rep Power
    224
    Your C: partition is a bit small at 50GB. We default to 80GB thin-provisioned so we've got wiggle room for patches and the like over the lifetime of the server.

    So I'd say put all your SQL-related stuff on D: (given the I/O will be pretty low)

    However, either you have a lot of doors or your access control vendor is pulling numbers out of their posterior with regard to disk space.

    I'd probably set C: to 80GB and D: to 100GB (thick-provisioned) and push back on the "500GB disk space", which (to be fair to the vendor) exists because of daft customers.

    If you can thin-provison your disks, 80 and 500 would be fine, since it'll only grow if it really needs to.

    You might want to think about how you'd handle that VM going pear-shaped - if the locks can't talk to the server do they default to analogue (keys), or are the entry codes stored at the lock and the server is just responsible for updating and removing?
    Last edited by pete; 3rd July 2014 at 03:01 PM.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    I'm with Pete, though we're finding that even 80GB is pushing it for a server these days, with all the updates, and stuff. Especially if the db is left in the default location as third parties like to come in and plonk backups into the default backup location on C too.
    I'd probably say go for 120 / 160 on C, as it's harder to change. The data partition can be extended, or just replaced with a larger one and files copied over. I've done this a few times. Putting as much on D as possible is useful, and make sure backups are configured to go there too.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 7
    Last Post: 25th June 2014, 04:49 PM
  2. [Windows Software] SQL 2012 for Sims
    By zag in forum Licensing Questions
    Replies: 1
    Last Post: 7th October 2013, 11:27 AM
  3. Problems installing SQL 2005 for SIMS
    By timbo343 in forum Windows
    Replies: 6
    Last Post: 7th November 2007, 10:27 AM
  4. GPMC "Access Denied" for Administrator
    By Gatt in forum Windows
    Replies: 9
    Last Post: 8th February 2006, 06:25 PM
  5. Change profile path for all users
    By mark in forum Scripts
    Replies: 5
    Last Post: 10th September 2005, 06:16 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
  •