(Get Answer) – (Get Answer) – Performance Monitoring Assignment Help

(Get Answer) – (Get Answer) – Performance Monitoring Assignment Help Question Description1. What arewait types and what information do they provide for performance monitoring?2. Whatinformation does sp_who and sp_who2 provide for performance tuning analysis andhow could the information be used?3. What isthe statistics profile, what is it used for, what columns might be more usefulthan others?4.  What is this view useful for monitoring?5. what isthe estimated subtree cost value?  Whatis the estimated CPU cost for the inner join and what is the cost value?  What is the cost percentage for the clusteredindex 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