1 Case
1: -d option with no table
2 <Database Usage Statistics
>
4 <Database Name
> SYSTEMDB
</Database Name
>
5 <Max Size
> 1048576 </Max Size
>
6 <First Page
> 17d7c000
</First Page
>
7 <Total Pages
> 111 </Total Pages
>
8 <Used Normal Pages
> 13 </Used Normal Pages
>
9 <Used Merged Pages
> 2 </Used Merged Pages
>
10 <Chunks Used
> 15 </Chunks Used
>
13 <UsedSlots
> 1 </UsedSlots
>
14 <FreeSlots
> 99 </FreeSlots
>
17 <UsedSlots
> 0 </UsedSlots
>
18 <FreeSlots
> 100 </FreeSlots
>
20 <TotalNodes
> 0 </TotalNodes
>
24 <TotalBuckets
> 2048 </TotalBuckets
>
25 <UsedBuckets
> 0 </UsedBuckets
>
26 <TotalLockNodes
> 0 </TotalLockNodes
>
29 <Database Name
> userdb
</Database Name
>
30 <Max Size
> 10485760 </Max Size
>
31 <First Page
> 17e7a000
</First Page
>
32 <Total Pages
> 1279 </Total Pages
>
33 <Used Normal Pages
> 0 </Used Normal Pages
>
34 <Used Merged Pages
> 0 </Used Merged Pages
>
35 <Chunks Used
> 0 </Chunks Used
>
37 </Database Usage Statistics
>
40 Tables and Indexes are created
41 Case
2: -d option with
1 table
42 <Database Usage Statistics
>
44 <Database Name
> SYSTEMDB
</Database Name
>
45 <Max Size
> 1048576 </Max Size
>
46 <First Page
> 17d7c000
</First Page
>
47 <Total Pages
> 111 </Total Pages
>
48 <Used Normal Pages
> 13 </Used Normal Pages
>
49 <Used Merged Pages
> 2 </Used Merged Pages
>
50 <Chunks Used
> 15 </Chunks Used
>
53 <UsedSlots
> 1 </UsedSlots
>
54 <FreeSlots
> 99 </FreeSlots
>
57 <UsedSlots
> 0 </UsedSlots
>
58 <FreeSlots
> 100 </FreeSlots
>
60 <TotalNodes
> 0 </TotalNodes
>
64 <TotalBuckets
> 2048 </TotalBuckets
>
65 <UsedBuckets
> 0 </UsedBuckets
>
66 <TotalLockNodes
> 0 </TotalLockNodes
>
69 <Database Name
> userdb
</Database Name
>
70 <Max Size
> 10485760 </Max Size
>
71 <First Page
> 17e7a000
</First Page
>
72 <Total Pages
> 1276 </Total Pages
>
73 <Used Normal Pages
> 2 </Used Normal Pages
>
74 <Used Merged Pages
> 1 </Used Merged Pages
>
75 <Chunks Used
> 3 </Chunks Used
>
77 </Database Usage Statistics
>
79 Case
3: -d option after removing table
80 <Database Usage Statistics
>
82 <Database Name
> SYSTEMDB
</Database Name
>
83 <Max Size
> 1048576 </Max Size
>
84 <First Page
> 17d7c000
</First Page
>
85 <Total Pages
> 111 </Total Pages
>
86 <Used Normal Pages
> 13 </Used Normal Pages
>
87 <Used Merged Pages
> 2 </Used Merged Pages
>
88 <Chunks Used
> 15 </Chunks Used
>
91 <UsedSlots
> 1 </UsedSlots
>
92 <FreeSlots
> 99 </FreeSlots
>
95 <UsedSlots
> 0 </UsedSlots
>
96 <FreeSlots
> 100 </FreeSlots
>
98 <TotalNodes
> 0 </TotalNodes
>
102 <TotalBuckets
> 2048 </TotalBuckets
>
103 <UsedBuckets
> 0 </UsedBuckets
>
104 <TotalLockNodes
> 0 </TotalLockNodes
>
107 <Database Name
> userdb
</Database Name
>
108 <Max Size
> 10485760 </Max Size
>
109 <First Page
> 17e7a000
</First Page
>
110 <Total Pages
> 1279 </Total Pages
>
111 <Used Normal Pages
> 0 </Used Normal Pages
>
112 <Used Merged Pages
> 0 </Used Merged Pages
>
113 <Chunks Used
> 0 </Chunks Used
>
114 </DatabaseStatistics
>
115 </Database Usage Statistics
>