hekaton_objects.sql 1.11 KB
Newer Older
Dave Wentzel's avatar
Dave Wentzel committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
USE PerformanceCollector 
GO

if not exists (select * from sys.objects where object_id = object_id('PerformanceCollector.xtp_table_memory_stats'))
BEGIN
CREATE TABLE PerformanceCollector.xtp_table_memory_stats(
	[table_name] [nvarchar](128) NULL,
	[memory_allocated_for_table_mb] [bigint] NULL,
	[memory_used_by_table_mb] [bigint] NULL,
	[memory_allocated_for_indexes_mb] [bigint] NULL,
	[memory_used_by_indexes_mb] [bigint] NULL
) ON [PRIMARY]
END
GO


if not exists (select * from sys.objects where object_id = object_id('PerformanceCollector.xtpmem'))
BEGIN
CREATE TABLE PerformanceCollector.xtpmem(
	[clerck_type] [nvarchar](60) NOT NULL,
	[name] [nvarchar](256) NOT NULL,
	[memory_node_id] [smallint] NOT NULL,
	[pages_mb] [bigint] NULL
) ON [PRIMARY]
END
GO

if not exists (select * from sys.objects where object_id = object_id('PerformanceCollector.xtp_buckets'))
BEGIN

CREATE TABLE PerformanceCollector.xtp_buckets(
	[table_name] [nvarchar](128) NULL,
	[index_name] [sysname] NULL,
	[empty_bucket_count] [bigint] NULL,
	[total_bucket_count] [bigint] NOT NULL
) ON [PRIMARY]
END
GO