Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

SQL server 2012 best practices

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
gicago
Asked:
gicago
1 Solution
 
Mohammed KhawajaCommented:
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
 
gicagoAuthor Commented:
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

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