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
Explanation & Answer
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...