db hammer
Andre
the tool with hopes of doing some benchmarks on my server but have no idea
how to use it. My official copy of the book is on its way, but by the time
I receive it, it will be too late.
Any info anyone can provide is appreciated.
Thanks, Andre
Andre
If anyone has any experience with db hammer, I'd appreciate knowing what you
did to get it to work.
so far, the sql 2k resource kit is pretty unresourceful!
Andre
"Andre" <AndreGets...@nospam.com> wrote in message
news:ukdbNVvWCHA.2016@tkmsftngp09...
linda deng[MS]
There are some steps to install the Database Hammer.
1. Copy the Database Hammer files from the DatabaseHammer folder on the
Microsoft SQL Server 2000 Resource Kit CD to a folder on your local hard
drive.
2. Run the script in createdb.sql against the database of your choice. This
will create a table for the sample to work against.
3. Run the script within storedProcs.sql against the database chosen in
Step 2. This will create the stored procedures used by the Database Hammer
sample.
4. Open the LoadSlave.vbp project file using Visual Basic 6.0.
5. Either compile the LoadSlave application and then run it, or run it from
with in Visual Basic 6.0. The LoadSlave and LoadMaster applications should
be run on the server to reduce the time it takes to load the initial data.
6. Open the LoadMaster.vbp project file using Visual Basic 6.0. Either
compile the LoadMaster application and then run it, or run it from within
Visual Basic 6.0. This must be on the same computer that was chosen in Step
4.
7. Enter the names of the server and database that were used in Step 2.
After entering a user ID and password that have access to that database,
click Start. It will take some time to insert ten million rows of test data
into the sample table created in Step 2. These records will be used later
in load-testing the server. The process of inserting the test data can be
paused at any time by clicking
Pause, and resumed by clicking Resume.
Use the Database Hammer.
1. Open the ProcSlave.vbp project file using Visual Basic 6.0, compile the
ProcSlave application and then run it. The ProcSlave and ProcMaster
application can be run either on the server, to analyze how the database
performs under ideal conditions, or on a typical client machine, to analyze
how the server performs when network latencies are involved. You can also
run the ProcSlave and ProcMaster applications on several different client
computers simultaneously, to further load your server.
2. Open the ProcMaster.vbp project file using Visual Basic 6.0. Either
compile the ProcMaster application and then run it, or run it from within
Visual Basic 6.0. This must be on the same computer that was chosen in Step
1.
3. Enter names of the server and database that were used in step 2 of the
installation section. After entering a user ID and password that has access
to that database, click Start.
4. The ProcMaster application will spawn the number of instances of the
ProcSlave application specified in the Instances text box. At any time, you
can view the statistics for all of the ProcSlave instances by clicking
Stats, pause the ProcMaster application, once started, by clicking Pause
and resume, once paused, by clicking Resume.
5. To customize this application for your own use, you need to change the
GetCommand procedure in the ProcSlaveClass.cls class module. As it is
currently written, it performs a SQL UPDATE statement 50 percent of the
time and a SQL SELECT statement 50 percent of the time. You can create a
more complex command pattern, such as 10 percent UPDATE statements, 35
percent INSERT statements, and 55 percent S
ELECT statements.
Below is information regarding another SQL Server stress utility called
SQL70IOSTRESS. For more information, you can refer to
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q231619.
Sincerely,
Linda Deng
Microsoft Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.