With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Course Of The Month
3 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Can Lync Server 2010 Use an Existing SQL server?
Posted on 2011-03-04
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?
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?
[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
Active today
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
And yes, the SQL servers can be clustered.
More info:
http://technet.microsoft.com/en-us/library/gg425848.aspx
-Cliff
Active today
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
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
Active today
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
-Cliff
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
I have a large data set and a SSIS package. How can I load this file in multi threading?
In this article we will learn how to fix “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
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…
Suggested Courses
Course of the Month3 days, 14 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.