Solved

Can Lync Server 2010 Use an Existing SQL server?

Posted on 2011-03-04
3
1,223 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
  • 2
3 Comments
 
LVL 57

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 36

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 57

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Internet Protocol Security question 3 73
query execution hang 5 32
Query Help - MSSQL - Averages 5 27
insert wont work in SQL 14 22
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

822 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