MS-SQL performance fine tuning

[Kyyap]

hi guys
I have a DB server running on MS-SQL7.0 with WinNT4.0
and with the hardware configuration as below
Server Model : HP NetServer LH4
Processor : Xeon 550MHz
RAM : 256Mb
Hard Disk : 3 x 9Gb configured with RAID-5
Tape Drive : HP SureStore DAT24
this DB server hosted in HQ office there are about 10 branches
from outstation accessing it through WAN link doing online transaction
,recently we encounter some problem on the DB server when too many query
running, and it prompt a message like this
"A time out occurred while waiting for memory resources to execute the query."
Is there any other way to fine tunning the performance of the DB server for
the time being other then upgrade the physical memory of the server.

thanks

[JC]

you can have sql server use a minimum amount of memory per query. just right
click the server and select properties then go to the 'Memory' tab. SQL server
will then use the amount for every query. or you can set the minimum amount
of memory that SQL server will use, the operating system will then reserve
this much memory exclusively for SQL server.

"Kyyap" <kyyap@genting.com.my> wrote:
>
>hi guys
> I have a DB server running on MS-SQL7.0 with WinNT4.0
>and with the hardware configuration as below
> Server Model : HP NetServer LH4
> Processor : Xeon 550MHz
> RAM : 256Mb
> Hard Disk : 3 x 9Gb configured with RAID-5
> Tape Drive : HP SureStore DAT24
>this DB server hosted in HQ office there are about 10 branches
>from outstation accessing it through WAN link doing online transaction
>,recently we encounter some problem on the DB server when too many query
>running, and it prompt a message like this
>"A time out occurred while waiting for memory resources to execute the query."
>Is there any other way to fine tunning the performance of the DB server
for
>the time being other then upgrade the physical memory of the server.
>
>thanks
>

[shijobaby]

http://sqlerrormessages.blogspot.com...red-while.html