XLab Answer Key_ Module 7_ Monitoring SQL Server 2014.pdf

Sep 26, 2016 - Highlight queries by average. 4. View the tables in the. InternetSales. 5. In the Results save the results as TopBaselineQueries. 6. In the query.
Télécharger le PDF
3MB taille 11 téléchargements 293 vues
commentaire
Report
Lab Answer Key: Module 7: Monitoring SQL Server 2014

1 of 9

Lab Answer

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Server 2014

Lab: Monitoring Exercise

Task 1: Prepare

1.

Ensure running,

are both ADVENTUREWORKS\Student

with the 2.

In the D:

Run as

administrator 3.

Click Yes

wait for the

script to

Task 2: Create

1.

Right-click

2.

In Computer

Tools, expand

Data Collector 3.

If a data completed

because you Yes when

prompted. 4.

Right-click

5.

In the Create

Server

Workload

26/09/2016 16:02

Lab Answer Key: Module 7: Monitoring SQL Server 2014

2 of 9

6.

On the

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

data logs,

select Performance 7.

On the

8.

In the list Time counter.

Add. Processor _Total is

selected 9.

In the list

Faults/sec counter.

Then click 10. In the list Time ( Lock Waits/sec

Average Wait Requests/sec and ensure that

_Total 11.

In the list

click the

Database

click the Free

memory ( 12. In the list Hit Ratio

the Cache _Total is

selected 13. In the list

select the

Transactions 14. In the Add dialog box,

Collector Set page, Click

Next. 15. On the

directory box,

type D: 16. On the

selected and

click Finish

Task 3: Run

26/09/2016 16:02

Lab Answer Key: Module 7: Monitoring SQL Server 2014

3 of 9

1.

In Computer

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

set you

created 2.

In the D:

Run with

PowerShell

This starts a

baseline 3.

When the

SQL

Server

Task 4: View

1.

In Computer

click

Performance 2.

In Performance

3.

In the Performance and click

select Log files the folder

with a name DataCollector01.

Properties dialog

box, click 4.

In Performance

5.

In the Add

and click

each other

counters for all of

the objects, 6.

Click any that the the keyboard

Highlight so arrow keys on note the

Last, Average 7.

On the

text-based

report, 8.

Right-click

report image

26/09/2016 16:02

Lab Answer Key: Module 7: Monitoring SQL Server 2014

4 of 9

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

as BaselineAverages. 9.

On the

original line

chart view. 10. Minimize

Task 5: View

1.

Start SQL

database engine

instance 2.

In SQL

the

D:\Labfiles\Lab07\Starter 3.

Highlight

queries by

average 4.

View the

tables in the

InternetSales 5.

In the Results

save the results

as TopBaselineQueries. 6.

In the query

View IO

Stats, and 7.

View the

the

InternetSales 8.

In the Results

save the results

as BaslineIO. 9.

Minimize

Result: At Workload, from DMVs

SQL Server obtained

26/09/2016 16:02

Lab Answer Key: Module 7: Monitoring SQL Server 2014

5 of 9

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Exercise

Task 1: Run

1.

In Computer

Workload data

collector 2.

In the D: PowerShell

3.

When the

Run with minutes to run. SQL

Server

Task 2: View

1.

In Performance

2.

In the Performance

ensure that Log

files is 3.

In the Performance Browse similar

click Add. name blg log file.

Then, in 4.

View the

5.

On the resulting

view the view the

text-based 6.

In the D: you saved

gif image compare the

baseline 7.

Close Internet

26/09/2016 16:02

Lab Answer Key: Module 7: Monitoring SQL Server 2014

6 of 9

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Task 3: View

1.

In SQL Transact-SQL

highlight the reads, and

then click 2.

View the you saved

TopBaselineQueries.csv file queries that

were identified 3.

In SQL

Transact-SQL

statement 4.

View the D:\Labfiles\Lab07

saved in the were identified

during 5.

Close Excel

Result: At metrics for

performance

26/09/2016 16:02

Lab Answer Key: Module 7: Monitoring SQL Server 2014

7 of 9

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 16:02

Lab Answer Key: Module 7: Monitoring SQL Server 2014

8 of 9

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 16:02

Lab Answer Key: Module 7: Monitoring SQL Server 2014

9 of 9

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 16:02