I am at a Clients site the Server has 4 processors, 2048 Mg of Ram, SQL 2000 SP3.

The problem the Access Application slowing down and producing errors.

The situation is I have at any given time 200 or more Process IDs (though only 10% are active). Of the 200 over 60% use nt users and 40% use SQL Logins.

They do log shipping on all 36 databases every 15 minutes, and through out the business day 10 SQL Jobs run every 5 min, 10 min, 1 Hour increments.

Access since it is the most heavily used application is producing an error. Not in the development environment but in the production environment only.
This leads me to believe that this is a server hardware related error.

Is this box under powered? How many connected users are acceptable?

Disk space is not an issue.

Running Profiler the BOX gets hit with 50000 to 100000 SQL statements in hour.

All applications for the most part use embedded SQL (No compiling here)

I am seeing a large number of Locks Acquiring and Releasing is that normal for ODBC connected applications?

What else should I be locking at?