95%(66)63 out of 66 people found this document helpful
This preview shows page 8 - 12 out of 19 pages.
Use Management Studio to:Register servers.Connect to an instance of the Database Engine, SSAS, SSRS, SSIS or Azure SQL Database.Configure server properties.Manage database and SSAS objects such as cubes, dimensions, and assemblies.Create objects, such as databases, tables, cubes, database users, and logins.Manage files and filegroups.Attach or detach databases.Launch scripting tools.Manage security.View system logs.Monitor current activity.Configure replication.Manage full-text indexes.(Administer Servers with SQL Server Management Studio, 2016)Operating System/Hardware RequirementsHardware and Software RequirementsComponentRequirement.NET FrameworkSQL Server 2016 RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2016 setup automatically installs .NET Framework. You can also manually install .NET Framework from .For more information, recommendations, and guidance about .NET Framework 4.6 see .Windows 8.1, and Windows Server 2012 R2 require before installing .NET Framework 4.6.
Birchwood Lane School – Database Proposal for System of Record 9ComponentRequirementNetwork SoftwareSupported operating systems for SQL Server 2016 have built-in network software. Named and default instances of a stand-alone installation supportthe following network protocols: Shared memory, Named Pipes, TCP/IP and VIA.Note: Shared memory and VIA are not supported on failover clusters.Also, note that the VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.For more information about Network Protocols and Network Libraries, see .Hard DiskSQL Server 2016 requires a minimum of 6 GB of available hard-disk space.Disk space requirements will vary with the SQL Server 2016 components you install. For more information, see Hard Disk Space Requirementslater in this topic. For information on supported storage types for data files, see Storage Types for Data Files.DriveA DVD drive, as appropriate, is required for installation from disc.MonitorSQL Server 2016 requires Super-VGA (800x600) or higher resolution monitor.InternetInternet functionality requires Internet access (fees may apply).(Hardware and Software Requirements for Installing SQL Server, 2016)Processor, Memory, and Operating System Requirements
Birchwood Lane School – Database Proposal for System of Record 10ComponentRequirementMemory*Minimum:Express Editions: 512 MBAll other editions: 1 GBRecommended:Express Editions: 1 GBAll other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.Processor SpeedMinimum:x64 Processor: 1.4 GHzRecommended:2.0 GHz or fasterProcessor Typex64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support(Hardware and Software Requirements for Installing SQL Server, 2016)Features
Birchwood Lane School – Database Proposal for System of Record 11