title: How to move TempDB to RAM in SQL Server 2005 / 2008?
body: <p>On the internet I found instructions to move SQL Server's TempDB to RAM but unfortunately those instructions don't seem to work for 2005 or 2008 anymore because the menu entries Microsoft describes in the article don't exist.
  How is it done in version 2005 and 2008?</p>
  
  <p>Here are the non-working instructions I found:</p>
  
  <blockquote>
    <p>Configure tempdb to temporarily reside
    in RAM. To do this, perform the
    following steps:</p>
    
    <p>Right-click the server name and click Configure on the shortcut menu.
    Alternatively, you can click the
    Server menu, point to SQL Server, and
    then click Configure. Click the
    Configuration tab. Scroll down until
    you see the "tempdb in RAM (MB)"
    configuration option. In the Current
    column, type a number of megabytes of
    RAM to allocate to tempdb (for
    example, 2). This will only be
    temporary. Then click OK.</p>
  </blockquote>