Solved

SQL server 2012 best practices

Posted on 2014-09-18
2
334 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 24

Accepted Solution

by:
Mohammed Khawaja earned 500 total points
Comment Utility
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
Comment Utility
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

#Citrix #XenApp #Citrix Scout #Citrix Insight Services #Microsoft VMMAP #Microsoft ADEXPLORE #Microsoft RAMMAP #Microsoft TCPVIEW #Microsoft AUTORUNS #Microsoft PROCESS EXPLORER #Microsoft PROCESS MONITOR
Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

743 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now