• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • 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 KhawajaManager - Infrastructure:  Information TechnologyCommented:
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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

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