Post reply

DATABASE INSTANCES IN SQL EXPRESS(not SQL instances)

  • April 3, 2009 at 9:18 am

    #201783

    Is it possible to have different database instances within the same SQL Server instance?If so will each dattabasehave a buffer pool of 1GB allocated to it?

    thanks in advance.

  • April 4, 2009 at 10:34 am

    #972078

    I don't think so it's possible to set the memory limit or buffer pool memory for each database in SQL Server. SQL Server is smart enough to allocate enough memory to run queries/processes faster as and when needed.

    --Ramesh

  • April 4, 2009 at 11:56 am

    #972096

    wannabe dba (4/3/2009)

    Is it possible to have different database instances within the same SQL Server instance?If so will each dattabasehave a buffer pool of 1GB allocated to it?

    That's right as advised its not possible to allocate memory to a specific database in the buffer pool, if the memory is sufficient enough then sql server itself will allocate the memory for the frequently queried objects.

Viewing 3 posts - 1 through 2 (of 2 total)

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