Re: [Emerald] TempDB in RAM

Dale E. Reed Jr. ( (no email) )
Wed, 25 Nov 1998 09:24:41 -0800

Brandon Bryant wrote:
> OK, I'm convinced it's the thing to do. Now how do I do it? (put TempDB in RAM)

Using the Enterprise manager, right click over your SQL Server and
select configure.

Go to the third tab (configuration) and find the tempdb in ram setting.
The current/running value should be 0 (which means its on disk). Change
that to like 16-24, save the configuration and re-start your sql server.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |