I need help with my week 2 study sheet for DBM296. I am working on SQL 2012 and trying to have a better understanding. 

 

 

Locking and Tuning Worksheet You will use the SQL Server® administrative tools to complete the following assignment. For all questions
below, please use the AdventureWorks2012 database in Toolwire. Part 1: Locking: You need to finish this part in one sitting for it to work correctly – do not take any breaks
or allow Toolwire® to close down. Open up a new query window (call this Window A) in SSMS and execute the following code: BEGIN TRANSACTION
UPDATE [HumanResources].[Employee]
SET VacationHours = 60
WHERE BusinessEntityID = 200 Now, open up another query window (call this Window B) in SSMS and execute the following code: BEGIN TRANSACTION
UPDATE [HumanResources].[Employee]
SET SickLeaveHours = 40
WHERE BusinessEntityID = 200 Next, open up another query window (call this Window C) in SSMS and execute the following code: SELECT * FROM [HumanResources].[Employee]
WHERE BusinessEntityID = 200; 1.
Describe what happened to the code executed in Window A. Did it finish successfully within 1
minute? Why or why not? Do not close the query window until you are done with Part 1. 2.
Describe what happened to the code executing in Window B. Did it finish successfully within 1
minute? Why or why not? Do not close the query window until you are done with Part 1. 3.
Describe what happened to the code executing in Window C. Did it finish successfully within 1
minute? Why or why not? Do not close the query window until you are done with Part 1. 4.
Review the contents of sys.dm_exec_requests. Are there any sessions being blocked? If so, for
each session being blocked, give the id of the process being blocked, the id of the blocking process, the
wait type of the process being blocked, and the wait time of the process being blocked. 5.
If there is a blocking process, does it represent the code from Window A, the code from Window
B, the code from Window C, or something else? 6. If there is a blocking process, what kind of lock would it be holding? How do you know? 7.
Now, issue a COMMIT TRANSACTION statement in Window A. Review the contents of
sys.dm_exec_requests again – are there any sessions blocking now? Part 2: Tuning: Stop and restart the SQL Server® instance. Then, paste the contents of the
TuningWorkload.sql file attached to this exercise into a new query window in SSMS, and run the code (all
statements) against the AdventureWorks2012 database. Now, query the Dynamic Management Views to determine if there are any missing indexes that would
have been helpful for making this workload perform faster. 8. Show a screenshot of the query (or queries) you wrote and the resulting output. 9.
List the indexes that would have been helpful for the workload to run – for each index, supply
the table name and the column name(s).

• 1493882463-Locking and Tuning Worksheet.docx

ComputerScienceExpert

(11)

Status NEW Posted 04 May 2017 07:05 AM My Price 9.00

-----------

Attachments

file 1493882467-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer