{"id":493,"date":"2013-08-23T15:26:40","date_gmt":"2013-08-23T13:26:40","guid":{"rendered":"http:\/\/blog.lync2013.org\/?p=493"},"modified":"2014-05-08T10:24:19","modified_gmt":"2014-05-08T10:24:19","slug":"multiple-lync-2013-standard-edition-front-ends-single-database-instance-monitoring","status":"publish","type":"post","link":"https:\/\/modern-workplace.uk\/?p=493","title":{"rendered":"Configuring Multiple Lync 2013 Standard Edition Front Ends With a Single Database Instance for Monitoring"},"content":{"rendered":"
Intro and Scenario<\/span><\/strong><\/h5>\n

A few days ago I was talking with a friend of mine that was working on a scenario similar to that described here Why I added a Lync Director Pool (also if I don\u2019t like it)<\/a>.<\/span><\/p>\n

His company was deploying two Lync 2013 Front Ends (Standard Edition) paired on the same site. A question I was quite surprised was: how do I centralize data from monitoring, rather than spreading them across multiple instances (and thus, creating additional complexity in the reporting) ?<\/span><\/p>\n

The intuitive answer that I came up with was to use the same SQL instance for both Front Ends.<\/span><\/p>\n

The previous answer was also supported by a TechNet article: Defining Your Organizations’s Requirements for Monitoring<\/a><\/span><\/p>\n

Citing the interesting part:<\/span><\/p>\n

How many backend monitoring databases do you need? A single monitoring database can support tens of thousands of users (for Microsoft Lync Server 2010, it was estimated that a collocated database for both monitoring and archiving could support 240,000 users). In addition, a single monitoring database can be used by multiple Front End pools; if you have three Front End pools in your organization then you could associate all three of those pools with the same backend store.<\/i><\/span><\/p>\n

This simply means that, for many organizations, database capacity will not be the deciding factor when determining the number of backend monitoring databases that will be required. Instead, a more important consideration could be network speed. Suppose you have three Front End pools, but one of those pools is located across a slow network connection. In that case, you might want to use two monitoring databases: one database to service the two pools with the good network connection, and a separate database to service the pool with the slower network connection.<\/i><\/span><\/p>\n

\n

 <\/p>\n

Testing it in a Lab<\/span><\/strong><\/h5>\n

I have replicated the scenario in a lab, with no issue.The test environment is the one you can see in the following image<\/span><\/p>\n

\"03_schema\"<\/a><\/p>\n

I have defined a named instance in SQL server.<\/span><\/p>\n

\"01_defining_db\"<\/a><\/p>\n

Then I have used on both Front Ends to the same SQL instance for monitoring<\/span><\/p>\n

\"02_pointing\"<\/a><\/p>\n

Topology Builder presented no error. Adding monitoring to my Front Ends required a reboot. After that, I had no problem with Lync monitoring and the related reporting.<\/span><\/p>\n

\n

 <\/p>\n

Was it Enough for me ?<\/span><\/strong><\/h5>\n

Of course not. I proceeded to open a case with Microsoft, to confirm that the solution was supported. The response was positive<\/strong>.<\/span><\/p>\n

The sr. support engineer who managed the solution was extremely professional. I cannot quote him for privacy reasons, but I have expressed my satisfaction.<\/span><\/p>\n

\n

 <\/p>\n

So all\u2019s well ?<\/span><\/strong><\/h5>\n

As I am writing the solution has been successfully applied in a real-world scenario. I have also to admit that the existing documentation may be a bit confusing. Discussing the problem\u00a0with Johan Veldhuis @jveldh\u00a0<\/strong>, he talked to me about a TechNet post Components and Topologies for Monitoring<\/a> that seemed to point in the opposite direction as indicated.<\/span><\/p>\n

However, at this point I would say that the closed case may be considered as the final answer.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Multiple Lync 2013 Standard Edition Using a Single Database Instance for Monitoring<\/p>\n","protected":false},"author":1,"featured_media":1254,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_sitemap_exclude":false,"_sitemap_priority":"","_sitemap_frequency":"","twitterCardType":"","cardImageID":0,"cardImage":"","cardTitle":"","cardDesc":"","cardImageAlt":"","cardPlayer":"","cardPlayerWidth":0,"cardPlayerHeight":0,"cardPlayerStream":"","cardPlayerCodec":"","footnotes":""},"categories":[18,19],"tags":[155,702,100,32,156,33,35,157,158,36,26,159,44,160,161],"class_list":["post-493","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-english","category-lync","tag-configure-monitoring","tag-lync","tag-lync-2013-2","tag-lync-2013-client","tag-lync-2013-monitoring","tag-lync-2013-server","tag-lync-client","tag-lync-database","tag-lync-instance","tag-lync-microsoft","tag-lync-server","tag-lync-sql","tag-microsoft-lync-2013","tag-monitoring","tag-monitoring-instance"],"_links":{"self":[{"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/posts\/493","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=493"}],"version-history":[{"count":3,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/posts\/493\/revisions"}],"predecessor-version":[{"id":1256,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/posts\/493\/revisions\/1256"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/media\/1254"}],"wp:attachment":[{"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}