My sql indexing knowledge is very small, but I have a feeling the database slowdown is due to design/indexing. Attached is a copy of the database diagram. The only indexes...

We're using IIS5 and ASP, and it pretty much sounds like I'll need to separate the application and the database. That should pretty much tell me where the issues are...

The eventual goal is to use this for our middle school and elementary school teachers. At what point do you say ok, we need a server farm, tiered application, etc......

Actually, the application uses stored procedures, with SET NOCOUNT ON. As I look at the server right now, with grades due today, memory usage is pretty much at 1.2gig used....

Thanks, worked great!