Solved

Can Lync Server 2010 Use an Existing SQL server?

Posted on 2011-03-04
3
1,225 Views
Last Modified: 2013-11-29
I am curious if Lync Server 2010 databases be hosted on a shared SQL server (or cluster)? i.e. SQL server is hosting other third party application databases or even OCS 2007 R2 databases? This TechNet article seems to indicate it is a supported scenario: http://technet.microsoft.com/en-us/library/gg398102.aspx

I understand the best practice would be to provide Lync a named instance exclusively for its databases, but are there any performance guidelines or sizing considerations to account for when collocating the Lync SQL instance on a shared SQL server?
0
Comment
Question by:jhindson
[X]
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
  • 2
3 Comments
 
LVL 58

Accepted Solution

by:
Cliff Galiher earned 350 total points
ID: 35074766
Lync Server *ENTERPRISE* (not standard) can have its back-end databases hosted in an instance with multiple other databases, as long as you follow the other restrictions outlined (aka you can't have two monitoring databases in one instance, etc). You'll define the instance to use while using the topology builder, and then the topology builder tool will create the actual databases.

And yes, the SQL servers can be clustered.

More info:

http://technet.microsoft.com/en-us/library/gg425848.aspx

-Cliff
0
 
LVL 37

Assisted Solution

by:Jian An Lim
Jian An Lim earned 150 total points
ID: 35074807
there is no simple answer.

especially you you are sharing it with other database that i have no idea what is.



What microsoft recommend is the hardware requirement for database server based
http://technet.microsoft.com/en-us/library/gg398835.aspx




Is it better to have one large server running multiple databases, or several smaller servers running one database each?
http://www.sql-server-performance.com/faq/multiple_databases_servers_p1.aspx

0
 
LVL 58

Expert Comment

by:Cliff Galiher
ID: 35074840
To add to that, one larger server running multiple *instances* is still better than running multiple databases. The separation of memory, ability to individually tune for the application, etc makes this a near must. I'd never personally run completely different applications off the same instance as the tuning metrics will never align.

-Cliff
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

733 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