What Prizm Collects from SQL Server

WITH tablelist AS (
  SELECT T.TABLE_SCHEMA, T.TABLE_NAME, COUNT(COLUMN_NAME) AS ColumnCnt
  FROM INFORMATION_SCHEMA.COLUMNS C
  INNER JOIN INFORMATION_SCHEMA.TABLES T
    ON T.TABLE_CATALOG = C.TABLE_CATALOG
    AND C.TABLE_SCHEMA = T.TABLE_SCHEMA
    AND C.TABLE_NAME = T.TABLE_NAME
  WHERE UPPER(T.TABLE_NAME) = UPPER('<table_name>')
    AND UPPER(T.TABLE_SCHEMA) = UPPER('<schema_name>')
  GROUP BY T.TABLE_SCHEMA, T.TABLE_NAME
),
TableRecCnt AS (
  SELECT SCHEMA_NAME(obj.schema_id) AS Table_Schema, obj.name AS TableName,
    SUM(p.rows) AS RecordCount,
    SUM(a.total_pages) * 8 * 1024 AS TABLE_SIZE
  FROM sys.objects AS obj
  INNER JOIN sys.partitions AS p ON obj.object_id = p.object_id
  INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id
  WHERE UPPER(SCHEMA_NAME(obj.schema_id)) = UPPER('<schema_name>')
    AND UPPER(obj.name) = UPPER('<table_name>')
    AND p.index_id < 2
  GROUP BY obj.schema_id, obj.name
)
SELECT r.RecordCount AS ROW_COUNT, t.ColumnCnt AS COLUMN_COUNT, r.TABLE_SIZE
FROM tablelist t
INNER JOIN TableRecCnt r ON t.TABLE_SCHEMA = r.Table_Schema AND t.TABLE_NAME = r.TableName

SELECT DATEDIFF(second,
  CONVERT(datetimeoffset, dmb.last_user_update),
  CONVERT(datetimeoffset, GETDATE())) AS freshness
FROM sys.dm_db_index_usage_stats dmb
JOIN sys.tables tbl ON dmb.object_id = tbl.object_id
WHERE OBJECT_NAME(dmb.object_id) = '<table_name>'
  AND tbl.schema_id = SCHEMA_ID('<schema_name>')
  AND dmb.last_user_update IS NOT NULL

SELECT fk.name AS relationship_name,
  SCHEMA_NAME(tp.schema_id) AS parent_schema,
  OBJECT_NAME(fkc.parent_object_id) AS parent_table,
  COL_NAME(fkc.parent_object_id, fkc.parent_column_id) AS fk_column,
  SCHEMA_NAME(tr.schema_id) AS referenced_schema,
  OBJECT_NAME(fkc.referenced_object_id) AS referenced_table,
  COL_NAME(fkc.referenced_object_id, fkc.referenced_column_id) AS pk_column
FROM sys.foreign_keys fk
JOIN sys.foreign_key_columns fkc ON fk.object_id = fkc.constraint_object_id
JOIN sys.tables tp ON fkc.parent_object_id = tp.object_id
JOIN sys.tables tr ON fkc.referenced_object_id = tr.object_id

SELECT OBJECT_SCHEMA_NAME(o.object_id) AS source_schema,
  o.name AS source_object,
  o.type_desc AS source_type,
  d.referenced_schema_name,
  d.referenced_entity_name,
  d.referenced_minor_name AS referenced_column
FROM sys.objects o
CROSS APPLY sys.dm_sql_referenced_entities(
  SCHEMA_NAME(o.schema_id) + '.' + o.name, 'OBJECT'
) d
WHERE o.type IN ('V', 'P', 'FN', 'IF', 'TF')
  AND o.is_ms_shipped = 0

SELECT COUNT(*) AS QUERY_COUNT
FROM sys.dm_exec_query_stats s
CROSS APPLY sys.dm_exec_sql_text(s.sql_handle) AS st
WHERE st.text LIKE '%<schema_name>.<table_name>%'
  AND s.creation_time >= DATEADD(DD, -<days>, GETDATE())