Implementing SQL Server DBaaS services involves the following steps:
Planning SQL Server fabric groups
Installing and configuring SQL Server Standalone or Always On Servers
Creating SQL Server groups
Adding SQL Servers to the groups
Creating plans and assigning services
The installation and configuration of SQL Standalone or Always On isn't covered in this book. It is recommended to follow Microsoft's standard guidelines and best practices for installing and configuring SQL Servers. The SQL Server installation guides can be found at https://msdn.microsoft.com/en-us/library/bb500442.aspx.
The following steps outline the process to create SQL groups:
Log into the Windows Azure Pack management portal for administrators.
Browse the sql servers workspace.
Click on Create a SQL Server Group.
Provide GROUP NAME, choose the type that is Standalone servers orHigh availability (Always on enabled) and select the checkbox to enable the SQL resource governance (this will...