hi, I am about to loose faith in MSSQL 6.5 for his reason. I am dealing with 9 GB of data in 9 tables. the server is very very slow. it takes ages to retrieve a simple query from one table, what about from two tables?

Please help , what can I do to improve performace... I have 1152 MB of memory. 45 GB Harddrive. I have increase the memory in the sql configuration to 131072 and the locks to 12000.....still I am getting SQL Server out of lock.. .what am I doing wrong, is the configuration wrong? I do not want to convince myself that MSSQL is not Capable of dealing with such amount of Data... any help from SQL wize

thanks for your help