[dbo].[dbh_sql

Property	Value
Row Count	0
Created	2:46:16 PM Saturday, July 19, 2008
Last Modified	2:46:16 PM Saturday, July 19, 2008

	Name	Columns	Unique
	dbh_sql_mss_pk	sql_id
	dbh_sql_mss_inst_snapts_idx	dbh_instance, scan_type, snapshot_timestamp
	dbh_sql_mss_snapshot_ts_idx	capture_id, snapshot_timestamp

Name	Delete	Columns
dbh_sql_mss_capture_fk	Cascade	capture_id->[dbo].[dbh_captures].[capture_id]

Type	Action	Owning Principal
Grant	Delete	udmadmin_group
Grant	Insert	udmadmin_group
Grant	Select	udmadmin_group
Grant	Update	udmadmin_group

SQL Script

CREATE TABLE [dbo].[dbh_sql_mss]
(
[sql_id] [decimal] (8, 0) NOT NULL IDENTITY(1, 1),
[capture_id] [decimal] (8, 0) NULL,
[dbh_instance] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[snapshot_timestamp] [datetime] NOT NULL,
[scan_type] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[sql_owner] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sql_parser] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[session_id] [decimal] (8, 0) NULL,
[host_name] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[appl_name] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[os_user] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sql_handle] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[statement_start_offset] [decimal] (12, 0) NULL,
[plan_handle] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[cur_log_read] [decimal] (12, 0) NULL,
[cur_log_write] [decimal] (12, 0) NULL,
[cur_phy_read] [decimal] (12, 0) NULL,
[cur_cpu] [decimal] (16, 6) NULL,
[cur_elapsed_time] [decimal] (16, 6) NULL,
[plan_generation_num] [decimal] (8, 0) NULL,
[execution_count] [decimal] (8, 0) NULL,
[plan_creation_time] [datetime] NULL,
[last_exec_time] [datetime] NULL,
[last_log_read] [decimal] (12, 0) NULL,
[last_log_write] [decimal] (12, 0) NULL,
[last_phy_read] [decimal] (12, 0) NULL,
[last_cpu] [decimal] (16, 6) NULL,
[last_clr_time] [decimal] (16, 6) NULL,
[last_elapsed_time] [decimal] (16, 6) NULL,
[min_log_read] [decimal] (12, 0) NULL,
[min_log_write] [decimal] (12, 0) NULL,
[min_phy_read] [decimal] (12, 0) NULL,
[min_cpu] [decimal] (16, 6) NULL,
[min_clr_time] [decimal] (16, 6) NULL,
[min_elapsed_time] [decimal] (16, 6) NULL,
[max_log_read] [decimal] (12, 0) NULL,
[max_log_write] [decimal] (12, 0) NULL,
[max_phy_read] [decimal] (12, 0) NULL,
[max_cpu] [decimal] (16, 6) NULL,
[max_clr_time] [decimal] (16, 6) NULL,
[max_elapsed_time] [decimal] (16, 6) NULL,
[total_log_read] [decimal] (12, 0) NULL,
[total_log_write] [decimal] (12, 0) NULL,
[total_phy_read] [decimal] (12, 0) NULL,
[total_cpu] [decimal] (16, 6) NULL,
[total_clr_time] [decimal] (16, 6) NULL,
[total_elapsed_time] [decimal] (16, 6) NULL,
[diff_log_read] [decimal] (12, 0) NULL,
[diff_log_write] [decimal] (12, 0) NULL,
[diff_phy_read] [decimal] (12, 0) NULL,
[diff_io] [decimal] (12, 0) NULL,
[diff_cpu] [decimal] (16, 6) NULL,
[stmt_text] [text] COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[tag] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[folder] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[plan_owner] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_connect_string] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_name] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_version] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[create_date] [datetime] NULL,
[verify_date] [datetime] NULL,
[start_capture_time] [datetime] NULL,
[end_capture_time] [datetime] NULL,
[capture_interval] [decimal] (12, 2) NULL,
[var1] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var2] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var3] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var4] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var5] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text1] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dec1] [decimal] (12, 2) NULL,
[dec2] [decimal] (12, 2) NULL,
[dec3] [decimal] (12, 2) NULL,
[dec4] [decimal] (16, 6) NULL,
[dec5] [decimal] (16, 6) NULL,
[float1] [float] NULL,
[float2] [float] NULL,
[float3] [float] NULL,
[date1] [datetime] NULL,
[date2] [datetime] NULL,
[date3] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[dbh_sql_mss] ADD CONSTRAINT [dbh_sql_mss_pk] PRIMARY KEY CLUSTERED ([sql_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [dbh_sql_mss_snapshot_ts_idx] ON [dbo].[dbh_sql_mss] ([capture_id], [snapshot_timestamp]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [dbh_sql_mss_inst_snapts_idx] ON [dbo].[dbh_sql_mss] ([dbh_instance], [scan_type], [snapshot_timestamp]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[dbh_sql_mss] ADD CONSTRAINT [dbh_sql_mss_capture_fk] FOREIGN KEY ([capture_id]) REFERENCES [dbo].[dbh_captures] ([capture_id]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[dbh_sql_mss] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[dbh_sql_mss] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[dbh_sql_mss] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[dbh_sql_mss] TO [udmadmin_group]
GO

	Name	Data Type	Collation	Max Length (Bytes)	Identity
	sql_id	decimal(8,0)		5	1 - 1
$Indexes dbh_sql_mss_snapshot_ts_idx: capture_id\snapshot_timestamp$	capture_id	decimal(8,0)		5
$Indexes dbh_sql_mss_inst_snapts_idx: dbh_instance\scan_type\snapshot_timestamp$	dbh_instance	varchar(80)	SQL_Latin1_General_CP1_CS_AS	80
$Indexes dbh_sql_mss_snapshot_ts_idx: capture_id\snapshot_timestamp$ $Indexes dbh_sql_mss_inst_snapts_idx: dbh_instance\scan_type\snapshot_timestamp$	snapshot_timestamp	datetime		8
$Indexes dbh_sql_mss_inst_snapts_idx: dbh_instance\scan_type\snapshot_timestamp$	scan_type	char(1)	SQL_Latin1_General_CP1_CI_AS	1
	sql_owner	varchar(256)	SQL_Latin1_General_CP1_CS_AS	256
	sql_parser	varchar(256)	SQL_Latin1_General_CP1_CS_AS	256
	session_id	decimal(8,0)		5
	host_name	varchar(256)	SQL_Latin1_General_CP1_CS_AS	256
	appl_name	varchar(256)	SQL_Latin1_General_CP1_CS_AS	256
	os_user	varchar(256)	SQL_Latin1_General_CP1_CS_AS	256
	sql_handle	varchar(100)	SQL_Latin1_General_CP1_CS_AS	100
	statement_start_offset	decimal(12,0)		9
	plan_handle	varchar(100)	SQL_Latin1_General_CP1_CS_AS	100
	cur_log_read	decimal(12,0)		9
	cur_log_write	decimal(12,0)		9
	cur_phy_read	decimal(12,0)		9
	cur_cpu	decimal(16,6)		9
	cur_elapsed_time	decimal(16,6)		9
	plan_generation_num	decimal(8,0)		5
	execution_count	decimal(8,0)		5
	plan_creation_time	datetime		8
	last_exec_time	datetime		8
	last_log_read	decimal(12,0)		9
	last_log_write	decimal(12,0)		9
	last_phy_read	decimal(12,0)		9
	last_cpu	decimal(16,6)		9
	last_clr_time	decimal(16,6)		9
	last_elapsed_time	decimal(16,6)		9
	min_log_read	decimal(12,0)		9
	min_log_write	decimal(12,0)		9
	min_phy_read	decimal(12,0)		9
	min_cpu	decimal(16,6)		9
	min_clr_time	decimal(16,6)		9
	min_elapsed_time	decimal(16,6)		9
	max_log_read	decimal(12,0)		9
	max_log_write	decimal(12,0)		9
	max_phy_read	decimal(12,0)		9
	max_cpu	decimal(16,6)		9
	max_clr_time	decimal(16,6)		9
	max_elapsed_time	decimal(16,6)		9
	total_log_read	decimal(12,0)		9
	total_log_write	decimal(12,0)		9
	total_phy_read	decimal(12,0)		9
	total_cpu	decimal(16,6)		9
	total_clr_time	decimal(16,6)		9
	total_elapsed_time	decimal(16,6)		9
	diff_log_read	decimal(12,0)		9
	diff_log_write	decimal(12,0)		9
	diff_phy_read	decimal(12,0)		9
	diff_io	decimal(12,0)		9
	diff_cpu	decimal(16,6)		9
	stmt_text	text	SQL_Latin1_General_CP1_CS_AS	max
	tag	varchar(50)	SQL_Latin1_General_CP1_CS_AS	50
	folder	varchar(50)	SQL_Latin1_General_CP1_CS_AS	50
	description	varchar(2000)	SQL_Latin1_General_CP1_CS_AS	2000
	plan_owner	varchar(30)	SQL_Latin1_General_CP1_CS_AS	30
	db_connect_string	varchar(400)	SQL_Latin1_General_CP1_CS_AS	400
	db_name	varchar(256)	SQL_Latin1_General_CP1_CS_AS	256
	db_version	varchar(30)	SQL_Latin1_General_CP1_CS_AS	30
	create_date	datetime		8
	verify_date	datetime		8
	start_capture_time	datetime		8
	end_capture_time	datetime		8
	capture_interval	decimal(12,2)		9
	var1	varchar(400)	SQL_Latin1_General_CP1_CS_AS	400
	var2	varchar(400)	SQL_Latin1_General_CP1_CS_AS	400
	var3	varchar(400)	SQL_Latin1_General_CP1_CS_AS	400
	var4	varchar(400)	SQL_Latin1_General_CP1_CS_AS	400
	var5	varchar(400)	SQL_Latin1_General_CP1_CS_AS	400
	text1	varchar(1)	SQL_Latin1_General_CP1_CS_AS	1
	dec1	decimal(12,2)		9
	dec2	decimal(12,2)		9
	dec3	decimal(12,2)		9
	dec4	decimal(16,6)		9
	dec5	decimal(16,6)		9
	float1	float		8
	float2	float		8
	float3	float		8
	date1	datetime		8
	date2	datetime		8
	date3	datetime		8