English 中文(简体)
Why isn t SQL Server 2008 R2 using all available RAM?
原标题:

We have an analytics database server running SQL 2008 R2 with 192 GB of physical RAM. However, we re noticing that during analytics process, the server only uses around 70 GB, but tempdb swells to 300+ GB. The current Maximum Memory is set to 2147483647 MB. The server is running Windows 2008 R2. Is there a way to make SQL Server use more RAM and less disk-based tempdb?

问题回答

I figured out what is going on. We re currently using the Standard Edition of SQL Server 2008 R2, which, apparently, can only use a maximum of 64 GB of RAM.

http://msdn.microsoft.com/en-us/library/ms143685.aspx





相关问题
C++: Uninitialized variables garbage

int myInt; cout << myInt; // Garbage like 429948, etc If I output and/or work with uninitialized variables in C++, what are their assumed values? Actual values in the memory from the "last ...

How do I know if my PHP application is using too much memory?

I m working on a PHP web application that let s users network with each other, book events, and message eachother. There s only about 100 users. I set up the application on a VPS with Ubuntu 9.10, ...

Reserve RAM in C

I need ideas on how to write a C program that reserve a specified amount of MB RAM until a key [ex. the any key] is pressed on a Linux 2.6 32 bit system. * /.eat_ram.out 200 # If free -m is execute ...

How do I limit RAM to test low memory situations?

I m trying to reproduce a bug that seems to appear when a user is using up a bunch of RAM. What s the best way to either limit the available RAM the computer can use, or fill most of it up? I d ...

How does PHP handle variables in RAM?

I am curious how PHP handles variables in memory? If I have 100 constants or variables set that hold values related to my application and not on a per user basis, like site name, version number, ...

Hard disk drive and RAM memory - Dynamic Power Management

From what I have seen there is a pretty good support for dynamic power management in the both Windows and Linux when it comes to the CPU (scaling frequency so as to reduce energy consumption). Is ...

What should I load into memory when my app loads?

I have objects I am saving to the file system using serialization. When I load the app, should I load all the objects into memory or just stubs (for searching capabilities)? If I load just stubs, ...

热门标签