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

Anonymous
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

Mburu
School: UT Austin

Please find the attached word document

Running head: SQL SERVER CONCEPTS

1

SQL Server Concepts
Students’ name
Professor
Course
Date

SQL SERVER CONCEPTS

2
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
Review

Anonymous
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