0
votes
1answer
64 views

High memory usage windows 2008

I have a Windows server with 32 GB RAM, which is running sqlserver and tomcat. In resource monitor it show more than 95% memory usage, but when I searched in processes all process, each process is ...
0
votes
1answer
288 views

How to know which application is consuming the ram?

I have the following process list and memory consumption (reported thru process explorer) on a 2008 R2 server with SQL, TFS and some other tools: As you can see the system is consuming 3.6 Gb but ...
3
votes
1answer
2k views

Windows Server 2008 Memory Usage with SQL Server 2008?

I have the following kit: windows server 2008r2 Microsoft SQL Server 2008r2 Dual Quad Core Xeons 52GB Ram The Ram usage on the server is currently at 98% which is fine, SQL server is happily ...
5
votes
2answers
1k views

How quickly will SQL Server release RAM when the OS signals a low memory condition?

From the SQL Server 2008 R2 Books Online: Server Memory Options When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free physical ...
2
votes
1answer
1k views

Monitoring SQL Server 2008

I understand SQL Server doesn't release the memory unless the OS needs it. Then, monitoring Available Bytes (free memory) is not the best way to monitor the service. What other variables can give me a ...
1
vote
2answers
393 views

What can cause SQL Server's maximum memory setting to appear to change over time?

I started analyzing our SQL Server PerfMon logs in Excel, and discovered this. Legend: Red - SQL Server - Target Server Memory Green - SQL Server - Total Server Memory Blue - Available System Memory ...
3
votes
3answers
6k views

What's using all my memory?

SOLUTION: There's a lot of stuff to read in this thread, so i'll just summarize here to help. The problem is the VMWare ESX balloon driver which "inflates" the amount of memory "in use" that ...
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 ...
3
votes
2answers
300 views

Why is SQL Server 2005 consuming so much memory (and it is not even running)

Lately, I have noticed that SQL Server is consuming too much memory even though the Management Studio is not running. It consumes as much as 500,000K of memory. I understand that the SQL Server ...
1
vote
2answers
1k views

Viewing SQL's cache RAM usage?

I hope this has a really simple solution, but I have a feeling it won't. I've not been able to find any information on this anywhere else, which isn't a good start! Basically we're running SQL Server ...
2
votes
0answers
703 views

SQL Server Max memory setting not taking effect

I am having trouble with restricting SQL Server 2008's memory usage on our Windows Server 2008 server. The system has 11GB of RAM, I have tried restricting SQL's memory usage to 8.5GB by setting ...