Solved

Planning new Windows Server 2012 R2 with SQL Server and Autocad Vault Server

Posted on 2014-03-16
2
544 Views
Last Modified: 2014-03-18
I'm trying to plan out a new server and I am struggling to find good accurate material online.

35 domain users on Hyper-V Image #1. 6 SQL Server Users on SQL Server Image. 6 Autocad Vault Users. on Server 2012 / Autocad Vault Server.

300GB of existing Data. Growing at 25GB per year. 50GB are Autocad Drawings. 150GB are general file storage.


I'll give points to anyone who can answer any of my questions and give me links/references to back them up. 125 Points per question. Will split if multiple contributors.

#1. Am I able to run a Windows Server 2012 R2 as Hyper-V Host, A virtualized Windows Server 2012 R2 Domain Controller, A Virtualized SQL Server 2012, & a Add-on Windows Server 2012 dedicated to running Vault Server? Are there any issues which I should be aware of?

#2 For the Vault Server, am I better to have the drawings running inside that particular server image? 4th Hyper-V Image? an external drive or simple NAS?

#3. Is there any reason to not virtualize the file server as part of the main domain controller Hyper-V Image?


#4. Where can I go to get an idea of recommended hardware for my deployment plan?
0
Comment
Question by:MJCS
  • 2
2 Comments
 
LVL 6

Accepted Solution

by:
rick81 earned 500 total points
ID: 39933908
1.  Yes you can run win2012 as a host and have multiple win2012 VM's.  This will really boil down to your hardware and resources available to service all those machines.  You'll want plenty of disk space and probably 32GB at least.
2.  A physical machine or NAS will always have faster I/O than a VM but if you only have 6 users they may not notice.
3.  No a virtual DC should be fine.  Virtualising gives you better redundancy and flexibility and makes full use of your hardware.  And if things go wrong you can easily move the VM's to other hardware.
4.  At a minimum you'd want a decent server with SAS drives, RAID 10 + 64GB RAM.  Even a SAS array might be a good option.
I have run a similar setup to your question.  with a SAS array.  it services over 60 users and works very well.  No performance issues with the VM's.
0
 
LVL 6

Expert Comment

by:rick81
ID: 39933938
Keep all the data within the one VHD file.
Also you may want to have an additional virtual DC or another VM for file server only. This is probably a better way to go as it will take load off the DC for serving files.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question