INF: SQLSTRES-Sample DB-Library Application for Windows NT

ID: Q87953

The information in this article applies to:

Microsoft SQL Server version 4.2x

SUMMARY

SQLSTRES is a sample Windows NT-based DB-Library (DB-Lib) application. SQLSTRES can simulate a large number of SQL Server clients to help determine the effect of "scaling up" an application when adding more users.

MORE INFORMATION

The following file is available for download from the Microsoft Software Library:

~ SQLSTRES.EXE

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

Q119591 : How to Obtain Microsoft Support Files from Online Services

When you develop a SQL Server client application, questions often arise as to how response time and throughput will be affected when you deploy the application and many users access the application simultaneously.

You can use standard benchmarks to gauge performance and scalability, but these factors are variable and highly dependent on the types of queries and updates performed by a specific application. In the development phase of an application it is often difficult to simulate realistic operating environments with large numbers of workstations. The SQLSTRES application enables you to simulate many users executing the operations of your particular application from a single workstation:

SQLSTRES uses Windows NT threads to simulate each client connection, with status, and the results of queries displayed in MDI child windows.

SQLSTRES loads the Transact-SQL queries to be performed from ISQL-compatible text files, thereby allowing you control over the queries being executed.

SQLSTRES enables you to specify the number of clients to simulate and the number of iterations to perform.

SQLSTRES.EXE contains the following files:


   Filename             Description
   --------             -----------
   SQLSTRES.C           Main source code file
   SQLSTRES.H           Source code header file
   SQLSTRES.RC          Windows resource script file
   SQL.C                Source code file for DB-LIBRARY-specific
                        functions
   DIALOGS.DLG          Dialog box resource script file
   DIALOGS.H            Dialog box header file
   DIALOGS.RES          Windows NT Dialog Editor resource
   MAKEFILE             NMAKE file
   TEST1.SQL            Sample query file
   TEST2.SQL            Sample query file
   README.TXT           This file

Additional query words: dblib ISQL Transact-SQL softlib

Keywords : kbprg SSrvDB_Lib SSrvWinNT
Version : 4.2
Platform : WINDOWS
Issue type :