Post reply

Minimum Memory Recommended for SQL Server

  • June 15, 2004 at 7:37 am

    #84814

    I need to install SQL Server 2000 on the same server which we have Analysis Server running.  I need SQL installed in order to schedule the processing of our olap cubes. That is all. Just want to run a job that runs a DTS package that processes the cubes.

    What is the minimum memory that I should give to SQL Server to do this? I want to have as much memory available to Analysis Server as possible.

     

    THANKS

  • June 15, 2004 at 11:54 am

    #510513

    You need to remember that when you process your cubes, you would be pulling the data out of SQL Server and you do not want to restrict memory to SQL Server . We run both Analysis Service and SQL Server on the same machine and we have left it to dynamically allocate memory.

  • June 15, 2004 at 9:26 pm

    #510569

    You actually only need to install DTS to do what you are after.  DTS can be installed without requiring the installation of SQL Server. 

    When you run DTS, you can either get the package from SQL Server or from a file.

    This leaves scheduling of execution of the package - you can use a Windows Scheduled Task or any other scheduling engine capable of running a windows command.

  • June 22, 2004 at 6:04 am

    #511389

    I think the minimum amout of memory is 512 MB RAM..

    Also SQL Server is Monister in dealing with Memory .. because it takes almost all the memory you give to your machine

    so if you give your SQL Server more Rams .. then you get higher performance ..


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

  • June 23, 2004 at 4:31 am

    #511589

    Thanks for all the info.  Got it sorted out now....

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply