MCSA Guide to Microsoft SQL Server 2012 (Exam 70-462) 1st edition

Complete the steps in Microsoft SQL Server and take screenshots for each step. Include steps on how you got to the screenshot if possible. Thanks!

INSTRUCTIONS TO CREATE THE TABLES YOU NEED:

Hands-On Project 7-1: Monitoring and Analyzing Performance For this hands-on project, you will use the SQL Server named instance SQLSERVERHOA and the HandsOnOne database and tables that you created in previous chapters. The objective of this project is to practice using Windows utilitics and SQL Server management tools to monitor nce and diagnose query perf 1. Using the Windows Performance Monitor utility, add a set of counters to the real-time performance monitor display that you consider most relevant to the performance of your SQL Server instance. Document this step by taking a screen shot of the real-time displa 2. In SQL Server Management Studio, construct a SQL query that uses a SELECT statement and a JOIN clause to query data from both the Customer and Address tables. Analyze the cstimatcd cxecution plan. Identify the most costly plan steps. a. b. c. Are any of the steps that you identified in Step 2(a) a cause for concern? Explain. Describe how the performance of the query could be improved, or explain why the query is already optimal. 3. Implement any changes identified in 2(c) and execute the query using the option Include Actual Exccution Plan. Document this step by taking a screen shot of the actual exccution an 4. Use SQL Server Profiler to capture a trace and execute the query again. Analyze the trace ution of your query to document this 5. Launch the Database Engine Tuning Advisor from Qucry Editor to analyze your query. Did Run the sp_who2 procedure to determine the current sessions that are connected to the and determine how many milliscconds the query took to execute. Take a screen shot of the trace that shows the excc the analysis gencrate any recommendations? Explain why or why not. SQLSERVERHOA instance step