XPrime Sizing
Tool
for Microsoft® SQL Server™ 2000
XPrime provides a simple way to determine the optimal
number of XDA nodes for your environment. Take a
look
at this sizing tool and download the SQL script:
2. Execute the
query; this creates the XPrime size calculator procedure.
3. Open another
Query Analyzer window and type the following command:
EXEC XPRIME_XDA_SIZING tbl_name|'*',db_name
tbl_name = name of user defined table
‘*’ = all user defined tables in a database
db_name = name of target database to size
4. Execute the
query. The procedure calculates the optimal number
of XDA
nodes needed and displays information similar to
the following (the actual data displayed will vary
based
on the information entered in the EXEC command):
Total Data Space Required (MBytes)===> 5,916
Total Index Space Required (MBytes)===> 2,835
Total DBMS Space Required (MBytes)===> 8,751
Minimum Recommended Number of XDA Nodes ====> 3
