1
vote
2answers
2k views

How do I find the root cause of Memory pressure failure on an SQL server 2008?

One of the servers I have been performance monitoring started throwing the following warnings from the Resource-Exhaustion-Detector: Windows successfully diagnosed a low virtual memory condition. ...
1
vote
2answers
69 views

How to see what is cached in memory in SQL server 2008?

Is there a way how to find out what is cached in SQL Server 2008 R2? I have found the following nice article here: ...
-1
votes
1answer
52 views

MS SQL Express - Memory limitation vs. web application [duplicate]

I have web application that will be similar to forums. I plan to have few thousands+ users on this application, and i wonder if i can use MS SQL Express - here is the list of it's limitations: ...
1
vote
1answer
118 views

Will more memory help my CPU-peaking SQL Server 2008 R2

I'm supporting a system running against a SQL Server 2008 R2. The server is a single-CPU box with 8 GB of memory. As traffic has increased, the server has started saturating, peaking to 100% CPU ever ...
1
vote
1answer
1k views

Ram recommendations vs SQL DB size

we have a medium sized SQL db of around 40GB, and are about to move it to a new box with server 2008 r2 x64 some expensive contractor blokey has just come in and said we need 72gb of ram so that the ...
0
votes
0answers
134 views

How to speed up SQL Sever - More RAM didn't work

We have a server with 48 GB RAM on it. We're running some pretty heavy processes on SQL Server 2008 64 bit, but it tops out at 3 GB and won't use any more. It only uses about 15% of the CPU. The ...
0
votes
2answers
1k views

High memory usage, where is it coming from?

I have a virtual machine (Windows 2008 Server R2 64 bit running on vmware esxi 4) with 6 GB of installed RAM. It's reporting 95% memory usage and close to 0% CPU. This server hosts some WCF services ...
-1
votes
1answer
133 views

Page Fault of 1,000,000 in 64 GB RAM Server [closed]

I have a 64 bit Machine that runs SQL Server. It has 64 GB RAM. It is giving around 1,000,000 Page Faults per second. Is it OK or it is giving too many Page Faults? if the number is hign the what ...
0
votes
5answers
591 views

How much memory should I put in our SQL server 2008 server? [duplicate]

Possible Duplicate: Can you help me with my capacity planning? Currently our SQL server 2008 machine has 24 gb of memory. After analyzing some reports (PAL) and performance counters, I ...
4
votes
3answers
720 views

Max and Min Memory Setting

One failover cluster has 2 nodes with 64GB RAM each: - Node A and Node B. Node A run 2 SQL instances (SQL1 and SQL2). Node B runs 1 SQL instance (SQL3). SQL1 has a max server setting of 30,720MB ...
0
votes
1answer
596 views

FAIL_VIRTUAL_RESERVE on SQL 2008 SP2

My environment is SQL 2008 Standard x86 with SP2 running on Server 2008 Standard, with 4Gb ram and AWE enabled. I also have -g1024 set as a startup parameter. I am getting the following error in the ...
3
votes
3answers
4k views

Does SQL Server 2008 R2 lock memory pages by default?

Does anyone know if the locked pages of SQL 2008 ENT R2 x64 operates as ON as default (I assume it does as my SQL memory usage does not show up in task manager) on Server 2008 R2 x64. And if so, ...
6
votes
2answers
1k views

SQL Server memory constantly going up, from 1GB RAM used to 7GB in a week

I have a ~45GB database that increases rapidly (~1GB every week). So it's doing a lot of inserts; the web app doesn't have many users so reads are low right now. But I'm noticing that the RAM sql ...
1
vote
3answers
147 views

is it possible to influence memory usage for sql server (and: is 1GB usage a lot?)

i'm a developer and when i deploy our site to the prod server (with 3GB of ram) i always see the mssql proces using 1 GB of ram. We're at startup, so the database doesn't realy do a lot (sometimes no ...
1
vote
3answers
778 views

SQL Server Enterprise Edition: Use more than 4GB of RAM on a 32 bit Machine?

I would like to install SQL Server 2008 on a 32 bit machine. I have read that it is possible with the SQL Server Enterprise edition to increase the memory over the 4GB? Is this true? Any ...
1
vote
5answers
252 views

Effect of 8 shutdown SQL Server instances on memory?

I've inherited a server that has 8 previously installed instances of SQL Server 2005 Developer Edition. The instance I am working with is SQL Server 2008 Express. All of the Developer Edition ...
1
vote
0answers
381 views

sql server using all the memory on the box and throwing timeouts on pedestrian queries

I have max memory set. But at least 1 time a day the Sql Server hits over 95% of the ram in the box, and page faults for more. In the meantime the website is throwing very obscure timeouts on simple ...
0
votes
1answer
1k views

SharePoint / SQL Server “out of memory” error

After months of preparation, we launched a new SharePoint intranet portal today. Immediately, some users began getting a "server out of memory" error when they tried to log in. The SharePoint server ...
1
vote
2answers
2k views

SQL Server Memory Usage doesn't tally

EDIT Sorry forgot details, I'm running SQL Server 2008 R2 16GB of RAM My min/max memory allocation is set to 13 GB. Running perfmon - SQL Server:Memory Manager. Target Server Memory and Total Server ...
0
votes
1answer
5k views

windows 2008 and sql 2008 AWE memory

We have a development server running windows server 2008 enterprise (x86) with SQL Server 2008 Developer (x86) installed. The box has 8GB of ram installed, which windows sees. In order to get SQL ...
3
votes
2answers
2k views

Is 1GB RAM enough for a Windows Server 2008 web server with SQL Express 2008?

So I'm pricing out virtual dedicated servers. I'm looking to support about 500 to 1,000 (peak) visits a day spread across 5 different web sites. And 2 of those sites will have SQL databases with a ...
2
votes
3answers
502 views

Performance of Locked Pages v Native memory on 64 bit SQL2005/2008

I understand that setting the lock pages in memory privilege to the service account housing SQL2005/2008 services on a 64 bit system uses the AWE API and effectively stops SQL's buffer pool from being ...
0
votes
3answers
2k views

Memory settings for multi-instance failover clustering

When using multi-instance failover clustering (used to be called active-active) in SQL Server 2005 and 2008, I'd like to know what you configure the min and max server memory to. For a two-node ...