100%(5)5 out of 5 people found this document helpful
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 operationsSQL Database blade. 2.On the operationsblade, note the charts displayed in the Monitoringsection, which show resource utilization in terms of DTU percentage. 3.Click Edit, in the Resource utilizationchart, click Total database size, and then click OK. 4.Click the chart. This will display the Metricblade. 5.On the Metricblade, click Add alert. Then, on the Add an alert ruleblade, specify the following settings and click OK: oResource: leave the default setting in place oName: operations storage alertoDescription: storage alert for operations database
MCT USE ONLY. STUDENT USE PROHIBITEDImplementing Microsoft Azure Infrastructure Solutions L7-55oMetric: total database sizeoCondition: greater thanoThreshold: 1024oPeriod: over the last 5 minutesoEmail owners, contributors, and readers: selected oAdditional administrator email(s): any email address oWebhook: 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.serverlistand 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 Connectdrop-down list, click DatabaseEngine. 2.In the Connect to Serverdialog box, specify the following settings, and click Connect: oServer type: Database EngineoServer name: MIA-CL1oAuthentication: Windows Authentication3.In SQL Server Management Studio, in Object Explorer, under the MIA-CL1server, expand Databasesand verify that the salesdatabase is listed. 4.Right-click the salesdatabase, point to Tasks, and then click Deploy Database to Windows Azure SQL Database. 5.In the Deploy Database “sales”Wizard, on the Introductionpage, click Next. 6.On the Deployment Settingspage, click Connect. Then in the Connect to Serverdialog box, specify the following settings (replacing server_namewith the unique name of your SQL Database server) and click Connect: oServer type: Database EngineoServer name: server_name.database.windows.netoAuthentication: SQL Server AuthenticationoLogin: StudentoPassword: Pa$$w0rd
MCT USE ONLY. STUDENT USE PROHIBITEDL7-56Planning and implementing Azure SQL Database 7.On the Deployment Settingspage, ensure that the new database name is salesand 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.