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 and make sure no plagrisiam
