Re: [Emerald] TempDB in RAM

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

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Duane Schaub: "[Emerald] Prev. Balance Bug"
Next message: Dale E. Reed Jr.: "Re: [Emerald] Servu and Home Directory"
Maybe in reply to: Brandon Bryant: "[Emerald] TempDB in RAM"

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.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

Previous message: Duane Schaub: "[Emerald] Prev. Balance Bug"
Next message: Dale E. Reed Jr.: "Re: [Emerald] Servu and Home Directory"
Maybe in reply to: Brandon Bryant: "[Emerald] TempDB in RAM"