• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 69
  • Last Modified:

where should you install sql

question about installing sql server in a certain partition.  I was wondering if someone had a strong opinion on whether or not sql server should be installed on the system drive or it's own partition.  I am interested in pro's and con's but am more interested if it is big deal or if it is a murky answer.
0
jamesmetcalf74
Asked:
jamesmetcalf74
4 Solutions
 
ste5anSenior DeveloperCommented:
The SQL Server binaries and tools should go to the OS partition.

BUT: the databases should have their own based on different spindels, volumes and/or controllers. It depends on the size of the databases, the business value (recovery targets RTO, RPO) and the maintanence.
1
 
Scott PletcherSenior DBACommented:
You can install there, it's not a big deal.  I think some things get installed there even if you do pick a different drive location (at least they used to).
0
 
yo_beeDirector of Information TechnologyCommented:
If you install it on the system drive you want to make sure that all the DB's are not on there.

I like a setup if not virtualized

OS = RAID 1
Trans LOG:  RAID 1 + 0
DBs: RAID 5 or 6

If Virtualized still separate the locations for the OS, Trans Logs, and DB's, but no need to RAID it out.

Move all DB's to the Volume for DB's and make sure that the Log location is on the LOG vol.

This is a best practice for setting up a SQL server.
1
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
If you install SQL Server engine in a dedicated server as it's recommended, then you won't have any other applications sharing disk space with SQL Server.
Also, I others Experts said, what's really important is to separate data files, transaction log files and tempdb files. This will also help with the database performance.
0
 
jamesmetcalf74Author Commented:
Thank you gentlemen.  You have helped solve a debate.
0
 
yo_beeDirector of Information TechnologyCommented:
Great to hear. Please close this and award the points as you see fit.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now