-
Notifications
You must be signed in to change notification settings - Fork 47
SQLBENCH
This is a command-line tool that will run a fixed set of operations on CPU and memory, the file system, and a SQL Server database, so you can get a comparative summary between different clients and servers. CPU and memory tests are always run locally. File and SQL tests can be run locally or remotely.
SQLBENCH.EXE [-n timestorun] [-cpu] [[-file "folderpath"]...] [[-sql "connectionstring"]...] [-output "folderpath"]
This is a C# application that requires the full .NET 4x framework on Windows.
Download SQL_BENCH.ZIP and extract SQLBENCH.EXE to a folder of your choice. It is ready to use.
SQL_BENCH.ZIP v1.0.239.0
It does not require administrative permissions, but you must have permission to the folder, file share, or SQL Server database that you are benchmarking.
Note: All tests write to the Console Window and a file called TestLog.txt.
Note: The CPU/memory test writes a file called MathTests.csv to the current folder or a folder of your choice.
Note: The File test creates a file in the specified folder and reads and writes to it. It writes to a file called File.csv.
Note: The SQL test creates a TABLE called P1 in the server and database specified and reads and writes to it. It writes to a file called Database.csv.
This tool does not communicate with any external systems other than a SQL Server or File Server as specified in the command line and to write the three log files to the current folder or the folder specified. It does not modify the system in any way other than as described above. The test table is removed at the end of the run.