-
Ultimate SQL Performance???
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|