Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL server 2012 best practices

Posted on 2014-09-18
2
362 Views
Last Modified: 2014-10-13
Hello my dear experts :)

I was wondering if anyone can tell me a couple of best practices for Microsoft SQL server 2012.

I am planning a SQL farm for multi tenant Xenapp deployment and would like to know general guidelines for security and performance best practices and also scalability issues or general guidelines for SQL scalability (multiple VMs running the same database (or multiple databases).

I know the basic stuff like creating separate accounts for every sql service, separate the OS, Database and Log disks, use windows authentication instead of SQL "sa" account and change the default sql port.

I would like to know for other best practices or setup settings to mind during installation. For example is it better to place multiple instances on one server or install multiple sql servers (VMs), what is better in terms of scalability and security?

 I wouldn`t mind links for further investigations cause I am already googleing around so im just asking for extra input and advices.

Thanks in advance.
0
Comment
Question by:gicago
2 Comments
 
LVL 25

Accepted Solution

by:
Mohammed Khawaja earned 500 total points
ID: 40329924
It all comes down to cost.  Assuming you have one physical server, you need to consolidate where you will have multiple tenant DBs in a same instance or for security reasons, you will create different instance for each tenant.  SQL server is licensed where you purchase CALs or if you do not wish to purchase CALs then you can license it per core.  If number of users is large then purchase core licenses and then  create SQL instance.

If money is not a factor then create a separate VM for each tenant and install their own SQL server.
0
 
LVL 1

Author Closing Comment

by:gicago
ID: 40376493
Hi, I was kind of asking for more best practices (not only licensing) but later on found it on the web. We have decided to go with one instance because XenDesktop makes one DB per Site and we wont have more than one site that is divided into tenant delivery groups.

Thanks for helping and sorry for the delay in answering.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

When we have a dead host and we lose all connections to the ESXi, and we need to find a way to move all VMs from that dead ESXi host.
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

808 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