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
> 17d84000
</First Page
>
7 <Total Pages
> 109 </Total Pages
>
8 <Used Normal Pages
> 11 </Used Normal Pages
>
9 <Used Merged Pages
> 2 </Used Merged Pages
>
10 <Chunks Used
> 13 </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
>
39 Tables and Indexes are created
40 Case
2: -d option with
1 table
41 <Database Usage Statistics
>
43 <Database Name
> SYSTEMDB
</Database Name
>
44 <Max Size
> 1048576 </Max Size
>
45 <First Page
> 17d84000
</First Page
>
46 <Total Pages
> 109 </Total Pages
>
47 <Used Normal Pages
> 11 </Used Normal Pages
>
48 <Used Merged Pages
> 2 </Used Merged Pages
>
49 <Chunks Used
> 13 </Chunks Used
>
52 <UsedSlots
> 1 </UsedSlots
>
53 <FreeSlots
> 99 </FreeSlots
>
56 <UsedSlots
> 0 </UsedSlots
>
57 <FreeSlots
> 100 </FreeSlots
>
59 <TotalNodes
> 0 </TotalNodes
>
63 <TotalBuckets
> 2048 </TotalBuckets
>
64 <UsedBuckets
> 0 </UsedBuckets
>
65 <TotalLockNodes
> 0 </TotalLockNodes
>
68 <Database Name
> userdb
</Database Name
>
69 <Max Size
> 10485760 </Max Size
>
70 <First Page
> 17e7a000
</First Page
>
71 <Total Pages
> 1279 </Total Pages
>
72 <Used Normal Pages
> 1 </Used Normal Pages
>
73 <Used Merged Pages
> 0 </Used Merged Pages
>
74 <Chunks Used
> 1 </Chunks Used
>
76 </Database Usage Statistics
>
78 Case
3: -d option after removing table
79 <Database Usage Statistics
>
81 <Database Name
> SYSTEMDB
</Database Name
>
82 <Max Size
> 1048576 </Max Size
>
83 <First Page
> 17d84000
</First Page
>
84 <Total Pages
> 109 </Total Pages
>
85 <Used Normal Pages
> 11 </Used Normal Pages
>
86 <Used Merged Pages
> 2 </Used Merged Pages
>
87 <Chunks Used
> 13 </Chunks Used
>
90 <UsedSlots
> 1 </UsedSlots
>
91 <FreeSlots
> 99 </FreeSlots
>
94 <UsedSlots
> 0 </UsedSlots
>
95 <FreeSlots
> 100 </FreeSlots
>
97 <TotalNodes
> 0 </TotalNodes
>
101 <TotalBuckets
> 2048 </TotalBuckets
>
102 <UsedBuckets
> 0 </UsedBuckets
>
103 <TotalLockNodes
> 0 </TotalLockNodes
>
106 <Database Name
> userdb
</Database Name
>
107 <Max Size
> 10485760 </Max Size
>
108 <First Page
> 17e7a000
</First Page
>
109 <Total Pages
> 1279 </Total Pages
>
110 <Used Normal Pages
> 0 </Used Normal Pages
>
111 <Used Merged Pages
> 0 </Used Merged Pages
>
112 <Chunks Used
> 0 </Chunks Used
>
113 </DatabaseStatistics
>
114 </Database Usage Statistics
>