SQLServerCentral.com Content tagged T-SQL, Space Usagehttp://www.sqlservercentral.com/Content tagged T-SQL, Space Usage posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Three Sample reports for the Automated DBA: Space Usage SnapShotter1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot

]]>http://www.sqlservercentral.com/scripts/Administration/67437/Mon, 13 Jul 2009 06:00:00 UThttp://www.sqlservercentral.com/scripts/Administration/67437/The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.

]]>http://www.sqlservercentral.com/scripts/Administration/67098/Wed, 17 Jun 2009 06:00:00 UThttp://www.sqlservercentral.com/scripts/Administration/67098/The Automated DBA: Space Usage Snapshotter Lite (non-sysadmin dbo)Records snapshots of space usage stats by partition, index, table, schema, filegroup, and database. Stats include Reserved, Used, and Data for row, lob, and overflow.

]]>http://www.sqlservercentral.com/scripts/Administration/67099/Mon, 15 Jun 2009 06:00:00 UThttp://www.sqlservercentral.com/scripts/Administration/67099/