Tag Info

New answers tagged

0

Execute the following: select SERVERPROPERTY('Edition') SELECT name, cast(value_in_use as int)/1024 from sys.configurations where name = 'max server memory (MB)' If the first query returns standard or web edition you are stuck and need to upgrade to the enterprise edition. The second query returns the set maximum size of memory that the engine is ...


0

If you use SQL Server 2008 R2 Standard Edition, you are limited to 64GB RAM per SQL-Server instance. Memory Supported by the Editions of SQL Server


1

By default, the results are entirely buffered in memory for two reasons: 1) Unless using the -A option, output rows are aligned so the output cannot start until psql knows the maximum length of each column, which implies visiting every row (which also takes a significant time in addition to lots of memory). 2) Unless specifying a FETCH_COUNT, psql uses the ...


3

Open SQL Server Configuration Manager In the SQL Server Services pane, locate the instance that has the problem Right-click that instance and select Properties On the Startup Parameters tab, type -f, click Add, then click Apply Right-click that instance and select Start (or Restart) This will start the instance in minimal configuration mode (single user, ...


0

To start with you have SQL Server 2012 and memory architecture changed significantly in this version there is only one memory allocator (yes there is VAS allocator as well but I still would say there is only one 'Any Page' allocator) and this does Almost All memory allocations. Here is what BOL has to say. Please read this definition clearly Max server ...



Top 50 recent answers are included