1. 创建表
创建表,存储每天的表空间占用情况
CREATE TABLE [dbo].[t_rpt_table_spaceinfo]
(
[schema_name] [sysname] NOT NULL,
[table_name] [sysname] NOT NULL,
[record_date] [date] NOT NULL,
[record_time] [time](7) NOT NULL,
[rows_count] [bigint] NULL,
[reserved] [bigint] NULL,
[data_size] [bigint] NULL,
[index_size] [bigint] NULL,
[unused] [bigint] NULL,
CONSTRAINT [PK_t_rpt_table_spaceinfo] PRIMARY KEY CLUSTERED
(
[schema_name] ASC,
[table_name] ASC,
[record_date] ASC,
[record_time] ASC
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余4页未读,立即下载