Insufficient system memory in the resource pool for executing SQL scripts in SQL Server 2008

Question

Friends greetings

I had one problem: I have a tool that was developed in C # .Net 2005, and it will create a database by executing SQL scripts; scripts run in batch mode.

When run in XP, it works great; but the problem starts when it runs on Windows Vista 32-bit OS with SQR Server 2008 Express, I log an error in the log file; Below is a log with the size of the script files.

I don’t understand why there was less memory left to free the scripts, earlier I ran into this and split Master_Meata_Data into two files (Master_Data_Metadata1 and Master_Data_Metadata2); still i am facing the same problem in Vista ...

08/28/2009 Getting started with DB: Local \ SQLEXPRESS: WINDOWS :: 1031: NEWDB bgWorkerCreateDB_DoWork: C: \ Program Files \ CreateNewDB \

ReadAndExecuteScript: C: \ Program Files \ CreateNewDB \ Drop_Create.sql (size 3 KB)

ReadAndExecuteScript: C: \ Program Files \ CreateNewDB \ Tables.sql (size 999 KB)

ReadAndExecuteScript: C: \ Program Files \ CreateNewDB \ Master_Data.sql (Sizr 649KB)

ReadAndExecuteScript: C: \ Program Files \ CreateNewDB \ Master_Data_Metadata1.sql (size 2.72MB) Friday, August 28, 2009 ReadAndExecuteScript SQL error: There is not enough system memory in the "internal" resource pool to run this query.

, 28 2009 . 17:10 ReadAndExecuteScript: C:\Program Files\CreateNewDB\Data_Metadata2.sql( 1,55 ) , 28 2009 . SQL ReadAndExecuteScript: "internal" .

ReadAndExecuteScript: C:\Program Files\CreateNewDB\Initialize_Data.sql( 14.3MB)

ReadAndExecuteScript: C:\Program Files\CreateNewDB\Views1.sql( 2 )

ReadAndExecuteScript: C:\Program Files\CreateNewDB\Views2.sql( 4 )

ReadAndExecuteScript: C:\Program Files\CreateNewDB\Views3.sql( 2 )

ReadAndExecuteScript: C:\Program Files\CreateNewDB\Fn_Duration.sql( 2.27KB)

ReadAndExecuteScript: C:\Program Files\CreateNewDB_Fn_GetDate.sql( 1 )

Answer 1

, XP, Vista, , script, , .

- GO? , , , . 1 SQL script, . GO, ( ) .

Answer 2

, , , ,

ALTER RESOURCE GOVERNOR 
    { DISABLE | RECONFIGURE }
|
        WITH ( CLASSIFIER_FUNCTION = { schema_name.function_name | NULL } )
|
    RESET STATISTICS
[ ; ]

ALTER WORKLOAD GROUP { group_name | "default" }
[ WITH
    ([ IMPORTANCE = { LOW | MEDIUM | HIGH } ]
           [ [ , ] REQUEST_MAX_MEMORY_GRANT_PERCENT = value ]
           [ [ , ] REQUEST_MAX_CPU_TIME_SEC = value ]
           [ [ , ] REQUEST_MEMORY_GRANT_TIMEOUT_SEC = value ]
           [ [ , ] MAX_DOP = value ]
           [ [ , ] GROUP_MAX_REQUESTS = value ] )
 ]
[ USING { pool_name | "default" } ]
[ ; ]

.

MSDN ALTER RESOURCE GOVERNOR

MSDN ALTER WORKLOAD