Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
COURSE of the MONTH
14 days, 18 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 1 day ago
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
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses
Course of the Month14 days, 18 hours left to enroll
771 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.