-
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?
Last updated: -
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?
Last updated: -
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 fear...
Last updated: -
SQL server 2005 running on Windows XP. The memory grows steadily then SQL (system) hangs when memory gets to 1.7 GB and then the server must be re-started. What could cause this?
Last updated: -
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 true?
Last updated: -
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 29GB. Our database is...
Last updated: -
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...
Last updated: -
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...
-
is sqldumper caused by low memory in computer if not what is it caused by and how do i get rid of it
Last updated: -
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...
-
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...
Last updated: -
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:...
Last updated: -
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 ?
Last updated: -
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...
Last updated: