SQL Server Memory

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 1CPU and 1GB...

sqldumper

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

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...

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...

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?

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...

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 set aside for SQL: ...

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 ?

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...