I have a big problem :
Since 3 days ago the transaction/sec on the database we used are grown up to 300/400 per seconds and the client application hang up
The database running on sql server 2000 standard edition sp3a, on a server with 2 gb of ram a nd 2 Xeon processor.
There are 4 tables on this database with about 65.000 records each one, with a primary key.
There are store procedure to run the queries
The application on client side is written in visual basic for applicatin on a access 2003 front end. The sql table are connected via ODBC connection
The client are 20 on a XP Porfessions sp1 computers.
When they start to work, after 3 minuts, the transaction/sec ride 400/sec and remain established until we shutdown the access appliction on client side.
What's happened? do you have any ideas ?
This architecture is running since 1 month with 20 users and all it's ok. COuld be a index problem or a database problem?
Thnk's in advance for your help