db:sqlserver:jimetrics
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
db:sqlserver:jimetrics [2014/06/16 19:56] haidong refactored db design with new column StartupAcct in Instance table, modified relevant stored procedures as well |
db:sqlserver:jimetrics [2014/09/16 20:56] 127.0.0.1 external edit |
||
|---|---|---|---|
| Line 54: | Line 54: | ||
| [LastUpdate] [datetime2] NULL | [LastUpdate] [datetime2] NULL | ||
| CONSTRAINT [PK_Host] PRIMARY KEY CLUSTERED ([HostID]), | CONSTRAINT [PK_Host] PRIMARY KEY CLUSTERED ([HostID]), | ||
| - | CONSTRAINT [UNQ_HostName] UNIQUE NONCLUSTERED ([HostName])); | + | CONSTRAINT [UNQ_HostName] UNIQUE NONCLUSTERED ([HostName]) |
| + | WITH (DATA_COMPRESSION = PAGE)); | ||
| GO | GO | ||
| Line 138: | Line 139: | ||
| [LastUpdate] [datetime2] NULL | [LastUpdate] [datetime2] NULL | ||
| CONSTRAINT [PK_Instance] PRIMARY KEY CLUSTERED ([InstanceID]), | CONSTRAINT [PK_Instance] PRIMARY KEY CLUSTERED ([InstanceID]), | ||
| - | CONSTRAINT [UNQ_InstanceName] UNIQUE NONCLUSTERED ([InstanceName])); | + | CONSTRAINT [UNQ_InstanceName] UNIQUE NONCLUSTERED ([InstanceName]) |
| + | WITH (DATA_COMPRESSION = PAGE)); | ||
| GO | GO | ||
| Line 223: | Line 225: | ||
| , [DiskUsedGB] AS ([DiskSizeGB]-[DiskFreeGB]) PERSISTED | , [DiskUsedGB] AS ([DiskSizeGB]-[DiskFreeGB]) PERSISTED | ||
| , [CollectionDate] [datetime2] NOT NULL, | , [CollectionDate] [datetime2] NOT NULL, | ||
| - | CONSTRAINT [pk__Storage_RecordID] PRIMARY KEY CLUSTERED ([RecordID])); | + | CONSTRAINT [pk__Storage_RecordID] PRIMARY KEY CLUSTERED ([RecordID]) |
| + | WITH (DATA_COMPRESSION = PAGE)); | ||
| GO | GO | ||
| Line 294: | Line 297: | ||
| [CollectionDate] [datetime2] NOT NULL, | [CollectionDate] [datetime2] NOT NULL, | ||
| CONSTRAINT [pk__DbFileStatsID_SID] PRIMARY KEY CLUSTERED | CONSTRAINT [pk__DbFileStatsID_SID] PRIMARY KEY CLUSTERED | ||
| - | ([DbFileStatsID] ASC)); | + | ([DbFileStatsID] ASC) |
| + | WITH (DATA_COMPRESSION = PAGE)); | ||
| GO | GO | ||
| Line 370: | Line 374: | ||
| [CollectionDate] [datetime2] NOT NULL, | [CollectionDate] [datetime2] NOT NULL, | ||
| CONSTRAINT [pk__TableStatsID_ID] PRIMARY KEY CLUSTERED | CONSTRAINT [pk__TableStatsID_ID] PRIMARY KEY CLUSTERED | ||
| - | ([TableStatsID] ASC)); | + | ([TableStatsID] ASC) |
| + | WITH (DATA_COMPRESSION = PAGE)); | ||
| GO | GO | ||
| Line 415: | Line 420: | ||
| [CollectionDate] [datetime2] NOT NULL, | [CollectionDate] [datetime2] NOT NULL, | ||
| CONSTRAINT [pk__InstanceConfigID_ID] PRIMARY KEY CLUSTERED | CONSTRAINT [pk__InstanceConfigID_ID] PRIMARY KEY CLUSTERED | ||
| - | ([InstanceConfigID] ASC)); | + | ([InstanceConfigID] ASC) |
| + | WITH (DATA_COMPRESSION = PAGE)); | ||
| GO | GO | ||
| Line 466: | Line 472: | ||
| [CollectionDate] [datetime2] NOT NULL, | [CollectionDate] [datetime2] NOT NULL, | ||
| CONSTRAINT [pk__InstanceDmvPerfCounter_ID] PRIMARY KEY CLUSTERED | CONSTRAINT [pk__InstanceDmvPerfCounter_ID] PRIMARY KEY CLUSTERED | ||
| - | ([InstanceDmvPerfCounterID] ASC)); | + | ([InstanceDmvPerfCounterID] ASC) |
| + | WITH (DATA_COMPRESSION = PAGE)); | ||
| GO | GO | ||
db/sqlserver/jimetrics.txt · Last modified: 2018/05/14 22:00 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
