What are wait types and what information do they provide for performance monitoring?, computer science homework help

timer Asked: May 31st, 2016
account_balance_wallet $5

Question Description

1.  What are wait types and what information do they provide for performance monitoring?

2.  What information does sp_who and sp_who2 provide for performance tuning analysis and how could the information be used?

3.  What is the statistics profile, what is it used for, what columns might be more useful than others?

4.   What is this view useful for monitoring?

5.  what is the estimated subtree cost value?  What is the estimated CPU cost for the inner join and what is the cost value?  What is the cost percentage for the clustered index scan and the non-clustered index seek?  What does the index scan cost tell you?

need 2-3 pages covering all the above with in text citations and references make sure no plagrisiam

Tutor Answer

School: UT Austin

Please find the attached word document



SQL Server Concepts
Students’ name


Wait Types

Wait Types as used in the SQL server refers to discrete steps applied in the query
processing. The wait types are responsible for identifying steps executed by the SQL statements
and their latencies. This function makes the wait type very helpful during the SQL tuning or
analysis. The basic categories of the wait types include resource waits, external waits and queue
waits (Auer, 2014).
The resource waits provide information concerning the different resource in the SQL
server. These types of waits provide information for troubleshooting for most of the performance
issues. The external wait is used to indicate that an external code executed by the SQL server
which is beyond its control. Moreover, this kind of wait provides signals when the connection is
idle. On the o...

flag Report DMCA

Goes above and beyond expectations !

Similar Questions
Related Tags

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors