We have a single SQL Server instance with four databases. About 80 concurrent users.
Our CPU gets pinned (100% utilized) when all users make queries at the same time. The DML is 95% select statements, using stored procedures on top of views. Disk activity is very low, with most reads comming from cache. Procedure run time is fast with one user, less than a second. 10% of queries are returning a single image.
DL 360, with 2 CPUs and 1GB memory.
DB2 30 MB
DB3 300 MB
DB4 150 MB
Any help or direction would be appreciated.