Microsoft KB Archive/87953

{|
 * width="100%"|

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

 * }

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 &quot;scaling up&quot; 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

Issue type :

Technology :