The following table lists hardware and software requirements for SQL Trend Analyzer.
Component | Server | Client |
Processor | Intel 486 or higher | Intel 486 or higher |
Memory and disk space | 32 MB RAM or higher 50 MB free drive space or higher | 24 MB RAM or higher |
Operating system | Microsoft Windows NT Server or Windows NT Workstation, version 3.51 or later | Windows NT Server or Windows NT Workstation, version 3.51 or later |
Software | Microsoft SQL Server, version 6.5 or later | Excel 97 ODBC, version 3.0.23.1 or later ODBC SQL Server Driver, version 2.65.0213 or later |
Other | A SQL file named Dataname (for example, Data1) of 20 MB or more A SQL file named Logsname (for example, Logs1) of 5 MB or more | |
Note The client setup portion of SQL Trend Analyzer will not work on
Windows 95.
To install SQL Trend Analyzer
From the command prompt, go to the Sql\Sqltrend directory on the BackOffice Resource Kit CD-ROM.
Run the following command:
setup server,sa_password,'path of collection file'
For example:
setup clown,red,'c:\temp'
This will install and start SQL Trend Analyzer on the server Clown (SA password "red") and will collect information, storing it in the temp directory.
If the server has no SA password, substitute two double quotes ("") for the SA password. Also, make sure that the directory path is enclosed in single quotes. The command will look like this:
setup clown,"",'c:\temp'
Note To verify that SQL Trend Analyzer is collecting data, look in the collection file directory for a file of the form SQL Trace current date.log. This file should be increasing in size as you click Refresh, provided that there is SQL Server activity.