7 View the query results and verify that a list of three servers and their IP

7 view the query results and verify that a list of

This preview shows page 552 - 555 out of 588 pages.

7. View the query results and verify that a list of three servers and their IP addresses is returned. 8. Keep SQL Server Management Studio and Internet Explorer open. Task 4: View database metrics 1. In Internet Explorer, in the Azure portal, navigate to the operations SQL Database blade. 2. On the operations blade, note the charts displayed in the Monitoring section, which show resource utilization in terms of DTU percentage. 3. Click Edit , in the Resource utilization chart, click Total database size , and then click OK . 4. Click the chart. This will display the Metric blade. 5. On the Metric blade, click Add alert . Then, on the Add an alert rule blade, specify the following settings and click OK : o Resource: leave the default setting in place o Name: operations storage alert o Description: storage alert for operations database
Image of page 552
MCT USE ONLY. STUDENT USE PROHIBITED Implementing Microsoft Azure Infrastructure Solutions L7-55 o Metric: total database size o Condition: greater than o Threshold: 1024 o Period: over the last 5 minutes o Email owners, contributors, and readers: selected o Additional administrator email(s): any email address o Webhook: leave blank 6. Keep Internet Explorer open for the next exercise. Results : After completing this exercise, you should have created an Azure SQL Database named operations on a new server with a name of your choosing. You should also have used SQL Server Management Studio to create a table named dbo.serverlist and created an alert to help you monitor database storage. Exercise 2: Migrating a Microsoft SQL Server Database to Azure SQL Database Task 1: Deploy a database to Azure 1. In SQL Server Management Studio, in Object Explorer, in the Connect drop-down list, click Database Engine . 2. In the Connect to Server dialog box, specify the following settings, and click Connect : o Server type: Database Engine o Server name: MIA-CL1 o Authentication: Windows Authentication 3. In SQL Server Management Studio, in Object Explorer, under the MIA-CL1 server, expand Databases and verify that the sales database is listed. 4. Right-click the sales database, point to Tasks , and then click Deploy Database to Windows Azure SQL Database . 5. In the Deploy Database “sales” Wizard, on the Introduction page, click Next . 6. On the Deployment Settings page, click Connect . Then in the Connect to Server dialog box, specify the following settings (replacing server_name with the unique name of your SQL Database server) and click Connect : o Server type: Database Engine o Server name: server_name .database.windows.net o Authentication: SQL Server Authentication o Login: Student o Password: Pa$$w0rd
Image of page 553
MCT USE ONLY. STUDENT USE PROHIBITED L7-56 Planning and implementing Azure SQL Database 7. On the Deployment Settings page, ensure that the new database name is sales and note the temporary file name used for the .bacpac file that will be exported and imported, ensure that the Service Objective is set to S2 , and then click Next .
Image of page 554
Image of page 555

You've reached the end of your free preview.

Want to read all 588 pages?

  • Summer '17

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture