1
vote
1answer
114 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 ...
6
votes
1answer
4k views

How do you get the minimum and maximum memory allocation of a SQL instance using T-SQL?

I'm managing about 90 SQL Server instances and need a query to determine how much memory has been allocated to each instance. Please note, I'm not asking how to set it, just to see what it's currently ...
2
votes
1answer
174 views

Windows 2008 R2 Enterprise SQL Server Enterprise 2008 R2 only using half the memory

We have built a new 2 CPU, 6 core server, with 96GB of RAM. SQL server Enterprise Edition was configured with a maximum memory setting of 92GB. A few days after adding into the load balancer I have ...
2
votes
1answer
528 views

How can I assign more than 2GB memory to my SQL Server 2008 R2 Web Instance?

I have a Windows 2008R2 Web server running SQL 2008R2 Web 64-bit. The server has 8GB of memory installed. See this from SSMS: In the SSMS management interface, I am unable to configure the server ...
1
vote
2answers
356 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
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, ...