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
Solved

Can Lync Server 2010 Use an Existing SQL server?

Posted on 2011-03-04
3
1,224 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

839 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