put tempdb in memory

Hi all,
We have 4GB of memory on the server and have a 2GB
database. Is there a way to either put our database or
the tempdb in memory? We are runnning into disk queues.
(disks are configured with RAID1+0. disk configuration is
optimized.)
thanks in advance,
Anna> We have 4GB of memory on the server and have a 2GB
> database. Is there a way to either put our database or
> the tempdb in memory?
Support for this configuration went away with SQL Server 6.5 (for good
reason). Surely there are better uses for your RAM than storing data.|||Although you cannot place a database into memory you can pin a table into
memory with the DBCC PINTABLE statement (see BOL). Pinning tables into
memory is not recommended.|||Thank you so much, Bianca and Aaron!!!
>--Original Message--
>Hi all,
>We have 4GB of memory on the server and have a 2GB
>database. Is there a way to either put our database or
>the tempdb in memory? We are runnning into disk queues.
>(disks are configured with RAID1+0. disk configuration is
>optimized.)
>thanks in advance,
>Anna
>.
>