SQL Server 2005 Memory
I have a server with 8 dual core processors, 32GB of RAM, windows server 2003 32bit, sql server 2005 enterprise, and a 500GB database running on it. 1. How does sql server use memory in this case? 2. I have heard from sql server pro’s that sql server can only use 4GB of RAM is that [...]

Answer Question   |  October 26, 2010  1:54 PM
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server memory

Why does SQL server use no more than 500MB in RAM?
Why does sql server use no more than 500mb in ram? We have sql server 2005 running on server 2003 32bit with 32GB of ram and in the task manager under processes, Mem Usage sqlservr.exe is only using 430, 268 K. SQL Server min memory is set to use 25GB and max is set to use [...]

Answer Question   |  October 15, 2010  5:50 PM
CPU, RAM, SQL, SQL Server, SQL Server 2005, SQL Server memory, Windows Server 2003 32-bit

Maximum memory on a 64-bit operating system?
I need to install a new SQL server and we are buying a 64-bit OS. What’s the maximum amount of memory that the operating system can hold/support/make use of?

Answer Question   |  July 13, 2010  6:01 PM
64-bit (x64), Capacity planning, Memory management, Operating systems, SQL Server administration, SQL Server memory

SQL Server 2005 Express SP3 Memory Usage
Upon Startup of my system the sqlwriter process immediately grabs 700mb of RAM and holds it. As I use the SQL Server to do different thing the memory usage grows and causes the memory on my system to decline. The SQL Server never releases the memory and it causes my system to respond slowly. I [...]

Answer Question   |  May 6, 2010  12:50 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server memory, SQL writer

SQL Server memory usage
I have a situation where a total of 13 GB RAM is being used by SQL server. Is there any way I can break down the 13 GB usage by application?  Is there any data or technique which could be used?

Answer Question   |  March 15, 2010  6:34 PM
RAM chip numbers, SQL Server, SQL Server memory, SQL Server performance

Memory overhead recommended for benchmarking SQL server 2005 on vSphere
For a ‘direct’ physical to VM comparison of SQL server 2005, would anyone recommend giving the VM extra (say, 1.5GB) RAM to compensate for any overhead the OS needs? So a direct comparison would then be 1vCPU, 2.5GB RAM VM & SQL set to use 1GB RAM) vs. SQL on physical host set to use [...]

Answer Question   |  July 31, 2009  8:09 PM
Physical hosts, SQL Server 2005, SQL Server memory, Virtual Machines, vSphere

sqldumper
is sqldumper caused by low memory in computer if not what is it caused by and how do i get rid of it

Answer Question   |  February 4, 2009  7:11 PM
SQL, sql dumper, SQL performance, SQL Server memory, SQL Server performance

Upgrading to a 64-bit SQL Server 2005 environment
We are replacing an existing SQL Server 2005 32-bit environment with a new SQL Server 2005 64-bit Enterprise Edition environment. The new solution will be a 2-node Microsoft Cluster with SQL Server Cluster Server, all 64-bit Enterprise additions. The only issue we are having is determining a good baseline for the base memory to install. [...]

Answer Question   |  March 5, 2009  6:28 PM
SQL Server 2005 (64-bit), SQL Server memory, SQL Server upgrades

SQL Server 64-bit Memory Requirement
We are replacing an existing SQL Server 2005 32-bit environment with a new SQL Server 2005 64-bit Enterprise High availability environment. The new solution will be a 2-node Microsoft Cluster with SQL Server Cluster Server, all 64-bit Enterprise additions. What I have a problem determining is what is a good baseline for the base memory [...]

Answer Question   |  January 29, 2009  9:54 PM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server 2005 (64-bit), SQL Server memory, SQL Server Upgrade

SQL Server 2005 Memory
SQL server 2005 running on windows XP, memory grows steadily then SQL(system) hangs when memory gets to 1.7 gb…Server must be re-started. What could cause this?

Answer Question   |  January 29, 2009  1:22 PM
SQL Server 2005, SQL Server memory, SQL Server performance, SQL Server performance tuning, Windows XP

Investigating SQL Server 2005 memory issues
We have a data warehouse server running SQL Server 2005 Enterprise Edition. Lately, after a restructure, we’re seeing some performance hits. If this is due to what was added during that rebuild, we have no problem with it. However, we are not sure. When a query is run, the disk queue fluctuates greatly, but a [...]

Answer Question   |  January 22, 2009  6:27 PM
SQL Server 2005, SQL Server memory

Memory allocations for SQL and other server processes
If I am correct, available bytes is the amount of memory available to the SQL Server at that point in time, working set is the amount SQL is actually using and total server memory is the total amount of all memory processes on that server. I have on a 4GB box with 3GB fixed and [...]

Answer Question   |  October 25, 2008  4:56 PM
SQL Server memory

How do I configure SQL 2005 to use 22GB RAM on a Server with 24 GB RAM running Windows 2003 EE ?
We have Windows 2003 Enterprise Edition (32bit) running on a IBM Quad Core Xeon Dual processor system with 24 GB RAM. The same server runs SQL 2005 with SP2. How do I configure SQL Server to use the maximum RAM say upto 22GB RAM ?

Answer Question   |  September 29, 2008  4:57 AM
SQL Server 2005, SQL Server configuration, SQL Server memory

Is it possible to increase the amount of memory used by SQL Server 2005 to speed up response time?
We have 1 server Proliant ML570T04 with 16GB di ram and 11 SAS Disk 70 gb. The software installed is SQL Server 2005, 32-bit and the application is Navision. With < 15 clients, the response time is slow because the SQL Server utilizes only 4 GB of ram. Is it possible to utilize the remaining [...]

Answer Question   |  April 25, 2008  2:27 PM
SQL Server 2005, SQL Server memory, SQL Server performance tuning