1
vote
4answers
153 views

Why is it so hard to get servers with Lot of Ram, but few cores?

SQL server has a very high per core license cost, but for a lot of workloads benefits more from lots of RAM. his is now even more of the case with in-memory tables. Even if a server with 4 cores ...
3
votes
1answer
939 views

Why does my SQL Server use AWE memory? and why is this not visible in RAMMap?

We have a Windows Server 2008 R2 (64-bit) 8GB server where, according to Sysinternals RAMMap, 2GB of memory is allocated using AWE. As far as I understood, this means that these pages stay in ...
0
votes
1answer
34 views

MS SQL 2005 Client excessive memory usage

Hi I inherited the support of an MS SQL 2005 server on a Windows 2003 server and its client XP workstations running MS SQL 2005 Native client. The database is appox. 1GB in size and some of the tables ...
1
vote
2answers
66 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: ...
-2
votes
4answers
319 views

will a 100GB database with large tables on MSSQL 2008 server run on a 3GB RAM system? [duplicate]

This will be only for testing and developing. I have a 100 GB DB I am working on and need a sanbox envorinment. The only hardware I have is a desktop with 3GB and 32bit. I am able to install SQL 2008 ...
-1
votes
1answer
51 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: ...
0
votes
1answer
235 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 ...
1
vote
1answer
116 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 ...
0
votes
0answers
204 views

Unique index failed?

Recently, we've been having some kind of memory leak in SQL Server. We do have a .NET assembly running to audit our tables, but this has ran for a few years without problems, so I doubt it's the ...
6
votes
1answer
5k 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 ...
-1
votes
1answer
132 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
516 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 ...
1
vote
2answers
845 views

Memory Usage of SQL Server

SQL Server instance on my server is using almost full memory available in my Physical Server. Say if i am having 8GB of RAM than SQL Server is using 7.8 GB of RAM from system. I also have read ...
1
vote
2answers
213 views

How do you control which portion of SQL Database gets loaded into Server Memory?

My SQL Server Machine has 6GB of RAM but the database size is 20GB. The Database is mainly an events log, clustered-indexed by time. The clients are mostly interested in the latest data. They want ...
1
vote
2answers
250 views

No “Using locked pages for buffer pool” in SQL Server log

As a trial run for a client I am trying to enable the "Lock Pages in Memory" setting on my development server, but no matter what I change, I cannot get the "Using locked pages for buffer pool" to ...
1
vote
2answers
380 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 ...
1
vote
3answers
735 views

Large script, many inserts and deletes: There is insufficient system memory to run this query

Once every 2 to 3 months the client sends us a giant SQL script to update their web database with changes. The script fails when you try to run it via SQL Server Management Studio due to insufficient ...
2
votes
1answer
1k views

SQL Server Bulk Insert Physical Memory Issue

I have a script that executes 15 bulk insert operations into a SQL Server Database sequentially, all based on the one below: BULK INSERT M_USERS FROM '\\spath\users.txt' WITH ( ...
1
vote
3answers
3k views

High Memory Utilisation by SQL 2008 R2

We have installed SQL 2008 R2 Enterprise on Window 2008 server.It has 24 GB of RAM.SQL server grabs all the memory during the optimization job and does not release it once the job has been ...
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
144 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
760 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 ...
0
votes
1answer
96 views

A Few Queries Reserve All RAM

I have a production SQL Server 2008 R2 database server that had 8GB of RAM allocated to it for the query engine (set by the minimum memory in the memory management screen for the database server). I ...
1
vote
5answers
249 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 ...
2
votes
2answers
480 views

How much memory to allocate to sql server

I have SQL Server inside an ESX VM... the server has 32GB Ram. Right now, I've given it 4GB of Ram because I had some to spare. How do I know how much memory I should throw at SQL Server (since it ...
1
vote
2answers
2k views

High Sqlservr.exe Memory Usage

I have a problem with sqlservr.exe (version 2008). It use a more memory. I checked on windows taskbar manager, sqlservr.exe usage ( Mem usage - 8GB Ram). I dont know how can I fix it.Got the following ...
2
votes
3answers
4k views

Recommendations for SSD for server and database use?

SSDs are a new technology and they are constantly improving. A lot of the posts here were posted in 2009 when SSDs where less mature and not as fast. What was recommend back then is probably out of ...
1
vote
3answers
356 views

On a VPS that runs DB and IIS, should I limit the RAM used by SQL Server?

I have a Windows 2008 R2 VPS with 1 GB of RAM. I'm using the VPS to run SQL Server 2008 Express and IIS 7.5. I've noticed that SQL Server tends to use as much memory as it can, to the detriment of ...
1
vote
3answers
2k views

Setting up SQL Server 2005 to use all available memory in 32bit Windows Server 2003 - and verifying it

There are a number of questions along this line - but they either sometimes contradict each other, or don't show how to properly verify that everything is actually working - hopefully this can be ...
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 ...
1
vote
2answers
139 views

SQL 2005 32-bit - Memory for Instances

We have a SQL Server 2K5 installation on a Windows 2003 R2 server with eight cores and 16GB of RAM. While it's in our plan to upgrade it to 64-bit, for now we are on the 32-bit version. Currently we ...
10
votes
5answers
28k views

How do I get SQL Server to release its memory?

I know SQL likes RAM, but releases it when Windows asks. I know this is how SQL is supposed to work. But I have a Windows Administrator who isn't convinced that SQL will actually return the RAM, and ...
1
vote
1answer
262 views

Reducing max memory settings in SQL 2005

We have a 2003 cluster with 32GB of memory. It hosts two SQL 2005 DB instances, one Reporting instance and runs SSIS packages throughout the day. The main instance is set to 22GB of memory, the ...
0
votes
1answer
320 views

Memory errors on SQL 2000 with SP4?

I have a SQL 2000 server with a DTS package that is crashing with insufficient memory errors, where we've never had an issue before. The DTS package is returning the error "There is insufficient ...
7
votes
5answers
6k views

Missing Memory on Windows Server 2008

I have a windows 2008 x64 server with 8GB of RAM installed. Task Manager and Resource Monitor both insist that 7.5GB of the RAM is in use. However, the memory list under Processes (Memory Private ...
1
vote
2answers
1k views

SQL 2008 Express Unload Due to Memory Pressure

I have an instance of SQL Express 2008 running as the backend for a small webapp on a server. The server specs: Windows 2003, 64bit quadcore, 4gb ram The SQL database is only 50mb on disk and I have ...
0
votes
4answers
1k views

SQL Server 2008 Max memory setting not taking affect

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 ...
1
vote
1answer
3k views

SQL Server 2005 and 2008 Memory Configuration Recommendations

We have a few SQL Servers with 32 GB or RAM. I've been told that Windows needs a considerable amount of free memory to manage all that RAM efficiently and that I should configure the memory usage on ...
2
votes
2answers
587 views

Can't run query on SQL Server, out of RAM?

How do I free up some RAM on our SQL Server (showing 77MB free). When I try to run a query I get an error saying cannot start thread out of RAM. It is using all but 77MB of like 5000+ MB.
2
votes
3answers
501 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 ...
2
votes
2answers
464 views

SBS Server 2003 (32 bit) - SQL + Exchange - is AWE useful?

We have an SBS server running SQL Server 2005 and Exchange, that is notoriously tight on memory. (It's a battle between the sql and exchange). It's not the time yet to replace it completely, but I ...
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 ...
12
votes
2answers
6k views

Find out which database in SQL Server 2005 uses how much RAM

A friend of mine asked me today (trying to calm down an agitated customer of his) how you could find out in SQL Server 2005 which database uses how much memory (in the server's RAM that is) at any ...
11
votes
4answers
10k views

SQL Server 2005: There is insufficient system memory to run this query

One of our SQL Servers, which has been running stable for quite some time (years), has recently been throwing insufficient memory errors. From the Application Event Log, we see: Event ID: 701 ...
12
votes
7answers
4k views

SQL Server - Force DB in memory?

We have a beefy Windows 2008 x64 server (4 x 4 core CPU, 32GB RAM) running SQL Server 2005 64-bit. We have a small (6GB) but very important database that is somewhat slow to access until the pages are ...
9
votes
6answers
10k views

Reclaiming memory from SQL Server

I have an SQL Server instance who's memory usage gradually grows until windows will give it no more. It seems logical that the occasional big query result would cause the instance to grow. Is there a ...