Benchmarking Tools

Hello
Does anyone know of any benchmarking tools to perform load testing and
performance benchmarking on SQL 2005 and SQL 2000 on 32-bit and
64-bit?
I was looking at Benchmark Factory from Quest Software but it does not
seem to work with 64-bit.
Thanks
Sameer
> I was looking at Benchmark Factory from Quest Software but it does not
> seem to work with 64-bit.
You should verify with Quest to determine whether that's the case. My
understanding is that it's a client app, and you don't have to run it on the
server itself (shouldn't run it on server as a matter of fact). You can
always run it on a 32-bit machine adn access a remote SQL instance. So I'd be
surprised if it doesn't work with an x64 SQL2005 instance.
Linchi
"Sameer" wrote:

> Hello
> Does anyone know of any benchmarking tools to perform load testing and
> performance benchmarking on SQL 2005 and SQL 2000 on 32-bit and
> 64-bit?
> I was looking at Benchmark Factory from Quest Software but it does not
> seem to work with 64-bit.
> Thanks
> Sameer
>

Benchmarking Tools

Hello
Does anyone know of any benchmarking tools to perform load testing and
performance benchmarking on SQL 2005 and SQL 2000 on 32-bit and
64-bit?
I was looking at Benchmark Factory from Quest Software but it does not
seem to work with 64-bit.
Thanks
Sameer
> I was looking at Benchmark Factory from Quest Software but it does not
> seem to work with 64-bit.
You should verify with Quest to determine whether that's the case. My
understanding is that it's a client app, and you don't have to run it on the
server itself (shouldn't run it on server as a matter of fact). You can
always run it on a 32-bit machine adn access a remote SQL instance. So I'd be
surprised if it doesn't work with an x64 SQL2005 instance.
Linchi
"Sameer" wrote:

> Hello
> Does anyone know of any benchmarking tools to perform load testing and
> performance benchmarking on SQL 2005 and SQL 2000 on 32-bit and
> 64-bit?
> I was looking at Benchmark Factory from Quest Software but it does not
> seem to work with 64-bit.
> Thanks
> Sameer
>

Benchmarking Tools

Hello
Does anyone know of any benchmarking tools to perform load testing and
performance benchmarking on SQL 2005 and SQL 2000 on 32-bit and
64-bit?
I was looking at Benchmark Factory from Quest Software but it does not
seem to work with 64-bit.
Thanks
Sameer> I was looking at Benchmark Factory from Quest Software but it does not
> seem to work with 64-bit.
You should verify with Quest to determine whether that's the case. My
understanding is that it's a client app, and you don't have to run it on the
server itself (shouldn't run it on server as a matter of fact). You can
always run it on a 32-bit machine adn access a remote SQL instance. So I'd b
e
surprised if it doesn't work with an x64 SQL2005 instance.
Linchi
"Sameer" wrote:

> Hello
> Does anyone know of any benchmarking tools to perform load testing and
> performance benchmarking on SQL 2005 and SQL 2000 on 32-bit and
> 64-bit?
> I was looking at Benchmark Factory from Quest Software but it does not
> seem to work with 64-bit.
> Thanks
> Sameer
>

Benchmarking Database Performance

First of all, sorry if this is in the wrong section, didn't know where to put it.

I'm doing a university paper comparing Microsoft Access versus SQL Server 2000 and I want to run a benchmark on them to see which is faster, does anyone know of any applications that will let me do this?

You may think this is silly since SQL Server is quite obviously faster, thing is a can't just say that in my paper, I have to be more specific so was hoping I could run some benchmarks and show the scores on the paper.

I know I can run an ASP script that can time how long the query takes to run, however this can't test multiple concurrent users accessing the system (useless I get all my friends computers around my house, bring up the page and get them to click on refresh all at the same time :) ).

I basically want to run a simple SQL SELECT statement on an identical database in both database systems (Northwind), but for mutliple users. Anyone know of any application?

Or does anyone know any performance tests that has been done on comparing Access with SQL Server? All I can find is material comparing high-end database against high-end database (Oracle vs SQL Server vs IBM DB2 etc.). If I can't do my own I can always use other peoples. Cheers!From the book "SQL Server Resource Kit", the CD that comes with the book contains a utility named "Database Hammer". The utility creates it's own database on SQL Server and performs a lot of transactions to test performance. It is most useful for comparing Server A to Server B, both running SQL Server.

Here's a link:

http://www.winnetmag.com/Article/ArticleID/26083/26083.html

Of course, this utility will not work against an Access database, but it should give you some ideas. Hope this helps...|||After some hunting around I found Quest Software's Benchmark Factory that seems to do the job really well. SQL Server 2000 handles about 21 transactions per second with 5 concurrent users, Access can only manage about 11. Does this seem right? This was from running a fairly complex SQL SELECT statement, performing mutliple inner joins on many tables in the Northwind sample database.

Would performing actual transactions on the Northwind database (INSERTs, UPDATEs etc) show bigger performance differences between Access and SQL Server?

Also does anyone have any experience with using Benchmark Factory? How do test more than 5 concurrent users? It only seems to let me select upto five, but the help files seem to indicate that you can test with as many as 100s of users.

Thanks for any help! :)|||From the book "SQL Server Resource Kit", the CD that comes with the book contains a utility named "Database Hammer". The utility creates it's own database on SQL Server and performs a lot of transactions to test performance. It is most useful for comparing Server A to Server B, both running SQL Server.

Here's a link:

http://www.winnetmag.com/Article/ArticleID/26083/26083.html

Of course, this utility will not work against an Access database, but it should give you some ideas. Hope this helps...

Thanks for the help, although my paper is on comparing Access and SQL Server, I'm building a system next year that uses an SQL Server backend database that handles tens thousands of records, and that utility will certainly help me with some optimisations.

Benchmarking database

Is there a ready made database for benchmarking a server's performance
to see what tweaks external to SQL Server will have an effect?

--
A)bort, R)etry, I)nfluence with large hammer."Trevor Best" <bouncer@.localhost> wrote in message
news:8o4020lu7rnc51mm1urc0aghn669tk46eo@.4ax.com...
> Is there a ready made database for benchmarking a server's performance
> to see what tweaks external to SQL Server will have an effect?
> --
> A)bort, R)etry, I)nfluence with large hammer.

In principle, you could use any database that you know how to recreate
easily, eg. Northwind. However I would guess that most people would prefer
to benchmark and performance test using a test database that looks like (or
is a copy of) their production database, in order to make the test
meaningful for their environment.

Simon

Benchmarking a server

is there a freebie utility/database that could benchmark a sqlserver?
Would like to try out different disk configurations (raid, swapfile
location, cluster size, etc) for getting the best results.

Or would I be better off writing a load script to stress the server on
a copy of my own database?

--
A)bort, R)etry, I)nfluence with large hammer.Trevor Best <bouncer@.localhost> wrote in message news:<t8113013fufan78fg8rkaj71908clb0n44@.4ax.com>...
> is there a freebie utility/database that could benchmark a sqlserver?
> Would like to try out different disk configurations (raid, swapfile
> location, cluster size, etc) for getting the best results.
> Or would I be better off writing a load script to stress the server on
> a copy of my own database?

Depending on what you want to test, this is one possible tool:

http://support.microsoft.com/defaul...9&Product=sql2k

The SQL 2000 Resource Kit has a tool called DB Hammer (or something
similar) which creates multiple client connections.

But if you want to test how fast various processes (meaning stored
procedure or application code) run, then the best test will be to use
your own test database, because then you know that you're testing
something which is meaningful for you.

Simon

Benchmark Software for Microsoft SQL Server

Hi,
Anybody know any TCP-C benchmarking software for Microsoft SQL Server?
Thanks,
Adriano.Adriano,
TPC-C is an on-line transaction processing benchmark.
http://www.tpc.org/tpcc/default.asp
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Adriano Galle Dal Prá" <dalpra@.cwb.palm.com.br> wrote in message
news:uJ$Y02vcDHA.1656@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Anybody know any TCP-C benchmarking software for Microsoft SQL Server?
> Thanks,
> Adriano.
>
>|||find the MS Enterprise Data Center 1.5 page
the 08-Data Services OLTP load generator is essentially a
simplified tpc-c kit modified for more generic testing
if you need full tpc-c testing assistance, check with
www.perftuning.com
>--Original Message--
>Hi,
>Anybody know any TCP-C benchmarking software for
Microsoft SQL Server?
>Thanks,
>Adriano.
>
>.
>