Tag Archive for: SQL Server

Deploy and provision best practices with Microsoft SharePoint Server 2016 #BRK3035

29 Sep 2016
September 29, 2016

Microsoft SharePoint Server 2016 provides a new suite of IT capabilities to drive improvements in both scale and resiliency. Learn the best practices to deploying and provisioning SharePoint Server 2016 with these capabilities in mind.

A session with Todd Klindt (@toddklindt) and Jason Himmelstein (@sharepointlhorn) – this will be super good!

WP_20160929_12_48_47_Rich

Here are my notes:

MinRole

MinRole rocks and its actually self-healing, can be installed on 1 server (plus sql). Minimum MinRole multi-server farm requires 4, with high availability its 8. Thats a lot of (virtual) metal…

WP_20160929_12_57_34_Rich

HA and Distributed Cache: do a graceful shutdown, thats per-se no HA.

There is a big change in Feature Pack 1 to support smaller environments because that has been requested so many times – good stuff!

WP_20160929_13_09_28_Rich

So once the feature pack is out you can combine services and do front-end and distributed cache on one server, and application and search.

Cloud SSA / hybrid search

Indexing is the stuff when the monkey bangs the coconut on the ground to check whats inside (Todd Klindt)

Man, I will steal that quote.

Once you use it, you dont have to have a bigger topology – index is in the cloud – and enables you to externalize onPrem data repositories.

Test it on a test environment, setting up cloud search could have impact on provider hosted apps.

SQL Server Performance

Pre-Grow, Auto-Grow, Instant File Instantiation – all the stuff that speeds up your databases/sql – speeds up your SharePoint.

Load testing

Measure before you scale!

WP_20160929_13_35_52_Rich

Jason told a customer case, were they improved the wrong metrics (custom code, sql performance) to then later on identify that the bottleneck was the CPU. Now they rerun the performance test and compare them with the previous baseline. There is a recording how to setup loadtesting from SPC 2014.

Summary

High expectations, high quality session – Todd and Jason are always a great combo and do great infotainment!

Go watch the session once its available!

TechEd 2013: Best Practices in Virtualizing and Managing Microsoft SharePoint with Microsoft System Center and Windows Server

28 Jun 2013
June 28, 2013

Session by Simon Skinner (@CymonSkinner)

image

SharePoint is now a company standard, but what is supported, sensible, or even practicable? How do we go about monitoring and managing SharePoint? In this session, we discuss the virtualization path and best practices using Hyper-V for high availability and why virtualization makes sense. […]

Here are my notes:

Read more →

TechEd 2013: Optimizing Microsoft SQL Server 2012 for SharePoint 2013

27 Jun 2013
June 27, 2013

If SQL Server does not perform, SharePoint can not show its full potential – to quote the session description:

More than 90% of the content accessed via SharePoint is stored in SQL Server and without the correct configuration of SQL Server it can have a detrimental impact on the performance of SharePoint. Regardless of whether you have a dedicated DBA or the SharePoint administrator is also the DBA there are critical SQL Server configurations that can be made that will optimize SharePoint […]

image

Here are my session about the session by Brian Alderman (@brianalderman)

Read more →

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close