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

• Microsoft SQL Server, version 4.2

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

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 scaleability, 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.

MORE INFORMATION

You can find SQLSTRES.EXE (size: 89983 bytes) 
                         , a self-extracting file, on the following

• Microsoft's World Wide Web Site on the Internet

        On the www.microsoft.com home page, click the Support icon.
        Click Knowledge Base, and select the product.
        Enter kbfile SQLSTRES.EXE (size: 89983 bytes) 
                                 , and click GO!
        Open the article, and click the button to download the file.
  
  

• Internet (anonymous FTP)

        ftp ftp.microsoft.com
        Change to the Softlib/Mslfiles folder.
        Get SQLSTRES.EXE (size: 89983 bytes) 
  

• The Microsoft Network

        On the Edit menu, click Go To, and then click Other Location.
        Type "mssupport" (without the quotation marks).
        Double-click the MS Software Library icon.
        Find the appropriate product area.
        Locate and Download SQLSTRES.EXE.
  

• Microsoft Download Service (MSDL)

        Dial (425) 936-6735 to connect to MSDL
        Download SQLSTRES.EXE (size: 89983 bytes) 
  

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online
               Services

   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