I also forgot to say that SQL Server should be the only thing running on the box.

>Hi All:
> My app front end is in VFP and back end is SQL 7.0. The app is install on 6 different users. These users are using Win95 as their OS. The problem is that it takes forever to get them connected to the SQL server after clicking on the icon. And once they do get connected, the app runs very slow. All the procedure are on sql. So where else should I be looking in order to improve the speed? Second problem is that I am running Win 2000 and when I am trying to query the data(10,000 records) on sql, the system totally slows down for the user on Wind95. It get to the point, where it takes an hour to run a single report. Would increasing the memory or processor on Sql help?
>Thanks