SharePoint Server 2016 Deployment Installation (vi)--Installing SQL Server 2016 (bottom)

Once installed, you can download the SQL Server Management Studio (SSMS) tool from the following address, which is an integrated environment for accessing, configuring, controlling, managing, and developing all of the components of SQL Server. SSMS combines a number of graphical tools with a rich scripting editor to enable developers and administrators of all skill levels to access SQL Server.

https://msdn.microsoft.com/zh-cn/library/mt238290.aspx?f=255&MSPPError=-2147217396

Double-click Setup, click Install

650) this.width=650; "height=" 497 "title=" clip_image001 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image001 "src=" http://s3.51cto.com/wyfs02/ M00/8a/0e/wkiom1glevfydpb7aajy7kzyznu308.png "border=" 0 "/>

Waiting for installation

650) this.width=650; "height=" 497 "title=" clip_image002 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image002 "src=" http://s3.51cto.com/wyfs02/ M01/8a/0e/wkiom1glevisyq4daadpo2u64ow124.png "border=" 0 "/>

After the installation is complete, SSMS requires that the computer be restarted.

650) this.width=650; "height=" 497 "title=" clip_image003 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image003 "src=" http://s3.51cto.com/wyfs02/ M00/8a/0e/wkiom1glevmcoh2xaae-kbl4ita827.png "border=" 0 "/>

After rebooting, find SSMS in the Program menu, open

650) this.width=650; "height=" 497 "title=" clip_image004 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image004 "src=" http://s3.51cto.com/wyfs02/ M02/8a/0e/wkiom1glevrrkzpmaaibtzx3dii773.png "border=" 0 "/>

Select the current SQL Server, click Connect

650) this.width=650; "height=" 325 "title=" clip_image005 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image005 "src=" http://s3.51cto.com/wyfs02/ M00/8a/0a/wkiol1glevvt-xciaad5c08vkra953.png "border=" 0 "/>

After connecting to the SQL service, a bright sky! Ha ha

650) this.width=650; "height=" 497 "title=" clip_image006 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image006 "src=" http://s3.51cto.com/wyfs02/ M00/8a/0e/wkiom1glevyqsnteaahjozx81km899.png "border=" 0 "/>

It is strongly recommended that you modify the maximum memory value for SQL because the default SQL Server eats up all of the physical machine's memory, causing the performance of the server itself to degrade.

Especially when it comes to providing services for SharePoint. Although you seem to have all of his memory assigned to SharePoint, the SP's web-side access can be very limited if the SP server connects to a SQL Server server that is problematic, or if stability is a problem.

Right-first row database server name, select Properties

650) this.width=650; "height=" 497 "title=" clip_image007 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image007 "src=" http://s3.51cto.com/wyfs02/ M02/8a/0e/wkiom1glev3jkt-yaahsvnu_iew713.png "border=" 0 "/>

In memory options, you can see that the maximum server memory footprint is almost unlimited. WTF!!

650) this.width=650; "height=" 497 "title=" clip_image008 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image008 "src=" http://s3.51cto.com/wyfs02/ M00/8a/0a/wkiol1glev7ajdb0aafact6itwe363.png "border=" 0 "/>

I allocated the server memory originally 16G, so decisively modified to 12G, click OK.

650) this.width=650; "height=" 497 "title=" clip_image009 "style=" border:0px;padding-top:0px;padding-right:0px; Padding-left:0px;background-image:none, "alt=" clip_image009 "src=" http://s3.51cto.com/wyfs02/M00/8A/0A/ Wkiol1glev-rc9jnaafdyznvgoy400.png "border=" 0 "/>

This article is from the "June Ma Run Space" blog, be sure to keep this source http://horse87.blog.51cto.com/2633686/1871665

SharePoint Server 2016 Deployment Installation (vi)--Installing SQL Server 2016 (bottom)