SQL 2000 db transactions/sec

32960 pts.
Microsoft SQL Server 2000
Microsoft Windows Server 2003
SQL Server database
SQL Server performance
What number of SQL 2000 database transactions/sec would be of concern on a system? Windows Server 2003, 4GB RAM, 2CPU (dual core). Thanks for the guidance.

Answer Wiki

Thanks. We'll let you know when a new response is added.

That all depends on how complex the transacations are and how well indexed the tables are.

If the tables aren’t indexed correctly and the transactions are complex then a couple of hundred per second may be to many.

If the tables are well indexed and the transactions are small and simply then thousands could be fine.

It also depends on how much data the database has that the transactions need to access.

In other words I don’t think there is enough information to give you a solid answer.

Discuss This Question: 3  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Troy Tate
    Thanks for the information. I am seeing peaks about 200 transactions per sec but typically not much above that. Can you explain more about what a complex transaction means? The database in question captures QA data from circuit board manufacturing. It's updating lot tracking information and what step the board is in the manufacturing process. I do not believe the volume of data is not large per transaction.
    0 pointsBadges:
  • Labnuke99
    Note that this is also a single database server. There are no other databases on this system other than the default SQL 2000 databases. The databases reside on a Stonefly SAN. Are you familiar with that SAN or do you know of any issues of running SQL2000 on an iSCSI SAN?
    32,960 pointsBadges:
  • Denny Cherry
    200 tps is a decent amount of load. Complex transactions means transactions which have a lot of business logic in them, where simple transactions are just an insert, update, delete, or select with maybe some basic logic in there. I don't know that SAN specifically. In general there shouldn't be any issues using an iSCSI SAN, but using iSCSI does present its own issues if you are having network issues.
    69,005 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: