The following changes that affect system diagnostics and monitoring are described in this section:
A new stored procedure, sp_iqstatistics, returns information about available in-memory statistics.
A new stored procedure, sa_dependent_views, provides information about dependent views for a table or view. Modifications to the ALTER VIEW, ALTER FUNCTION, and CREATE FUNCTION SQL statements support the new procedure.