by Paul Galaspie
The following applications have been included on the CD-ROM that accompanies this book to help you with your database administration tasks:
The SQL Server DBA Assistant is an application written in 32-bit Visual Basic 4.0. Using the SQL Server Assistant, you can perform the following tasks:
The SQL Server DBA Assistant source code is included on the CD-ROM so that you can make your own modifications and enhancements to the application.
NOTE: The code in the application is discussed in detail in Chapter 27, "SQL OLE Integration."
Following are the prerequisites for using the SQL Server DBA Assistant:
SQLOLE.HLP | SQL-DMO help files, including object hierarchy |
SQLOLE65.DLL | In-process SQL-DMO server |
SQLOLE65.TLB | Type library for OLE automation controllers |
SQLOLE.HLPSQL-DMO | help files, including object hierarchy |
SQLOLE65.DLL | In-process SQL-DMO server |
SQLOLE65.TLB | Type library for OLE automation controllers |
To install the SQL Server DBA Assistant, run the executable SETUP.EXE file included on the CD-ROM.
Follow these steps to use the SQL Server DBA Assistant:
Figure I.1.
The SQL ServerDBA Assistant Logon dialog box.
Figure I.2.
The Memory Estimation page in the SQL Server DBA Assistant dialog box.
Figure I.3.
The Table Maintenance page in the SQL Server DBA Assistant dialog box.
Figure I.4.
The Bulk Copy page in the SQL Server DBA Assistant dialog box.
NOTE: The Database Estimator requires you to have the ODBC DLLs installed on your PC. The Database Estimator also comes with a detailed help file that covers all its functionality.
Tired of manually calculating space requirements (see Figure I.5)? Let the Estimator automatically calculate database space requirements! The following sections discuss some of the features of the Estimator product.
Figure I.5.
Calculating database space requirements manually.
Follow these steps to install the Database Estimator:
NOTE: This example assumes that you are installing the Estimator on drive C and that the CD-ROM containing the Estimator files is located in drive D.
Are you creating a new database and do you have to determine how much space is needed to store the data? Do you have an existing database and do you have to predict future space requirements?
The Estimator is designed to help a DBA determine the amount of storage space required for a new or existing table (and associated indexes). The Estimator lets you perform this type of analysis without resorting to complicated formulas (see Figure I.6).
Figure I.6.
Automatic space calculation.
To use the Estimator, you must enter the expected row size and the estimated number
of rows. The Estimator can estimate row sizes using three different methods:
To have the Estimator estimate row sizes based on the table name and column sizes you enter, perform the following steps:
Using ODBC to Read an Existing Table Definition Have you already created a table and do you have to determine future table size? The Estimator can connect to SQL Server (through ODBC) and load table definitions into the Estimator. To use ODBC, perform the following steps:
Figure I.7.
Selecting a table in SQL Server from the Estimator Select a Table dialog box.
Loading existing table definitions is useful for determining the impact on storage requirements before you make modifications (such as adding new fields or indexes). Quick Calculator Use the Quick Calculator to get a rough estimate of your storage space requirements without having to resort to field-level definitions (see Figure I.8). Just enter the overall column size, overall index size, and number of rows. Click the Calculate button, and you will have your answer!
Figure I.8.
The Quick Calculator.
Do you want to save an estimate for future use? No problem! Just click the Save button in the main Estimator window. The Save Estimate dialog box appears (see Figure I.9). Enter the filename and select the directory for the saved estimates. Click the OK button to save the estimate.
Figure I.9.
Saving an estimate.
To order books from QUE, call us at 800-716-0044
or 317-361-5400.
For comments or technical support for our books and software, select Talk to Us.
© 1997, QUE Corporation, an imprint of Macmillan Publishing USA, a Simon and Schuster
Company.