Performance-monitoring-assignment-help-

by

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