1 create table monSysLoad(-- 0 Rows, Data: 2 KB, Index: 0 B
2 StatisticID smallint not null,
3 InstanceID tinyint not null,
4 EngineNumber smallint not null,
5 Sample real not null,
6 SteadyState real not null,
7 Avg_1min real not null,
8 Avg_5min real not null,
9 Avg_15min real not null,
10 Peak real not null,
11 Max_1min real not null,
12 Max_5min real not null,
13 Max_15min real not null,
14 Peak_Time datetime not null,
15 Max_1min_Time datetime not null,
16 Max_5min_Time datetime not null,
17 Max_15min_Time datetime not null,
18 Statistic varchar(30) null
19 )
20
21 Grant Select on monSysLoad to public
22
| JOINS |
| From Columns | To Table | To Columns | Cnt | Cstr | Strength | | [EngineNumber] | master..monEngine | [EngineNumber] | 2 | | Simple Join |
|
| ALIASES USED for master..monSysLoad |
| l |
| 1 |
| SCHEMA |
 |