Performance - transactions/second

Does anyone know how many transactions can SQL Server process per second?
Any suggestions on SQL Server performance testing tools?
Thanks!Teresa wrote:
> Does anyone know how many transactions can SQL Server process per
> second?
> Any suggestions on SQL Server performance testing tools?
> Thanks!
A lot on a 8-way server and much less on a single CPU with 512MB RAM. Of
course, this assumes all code is running efficiently and the drive
subsystems are designed properly, etc.
If you have specific requirements, I would encourage you to speak with
your hardware vendor and have them recommend a solution that fits your
needs. Compaq used to have a SQL Server Sizer that could give you
hardware specs based on performance criteria, but I don't know if HP
still has the tool on the web site.
You can also visit TPC.org and see the performance results there, but I
would encourage you to speak with someone who can custom design a
solution for you.
David Gugick
Imceda Software
www.imceda.com|||Hi
It depends on application, implimentation and hardware, but [url]http://www.tpc.org[/ur
l]
786,646 transactions per minute.
Regards
Mike
"Teresa" wrote:

> Does anyone know how many transactions can SQL Server process per second?
> Any suggestions on SQL Server performance testing tools?
> Thanks!