0
votes
0answers
191 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 ...
0
votes
1answer
82 views

MS SQL Hardware Configuration

About to order a replacement mirrored database pair to drive our multi-user web applications and looking for some guidance on some aspects. I have read various feedback on other posts but finding it ...
0
votes
2answers
265 views

Allocating RAM limits per specific MSSQL database

I have two SQL2005 databases on the same (Win2003 64-bit) server. One of them is seldom used, but has a large data set. Every time I query from it, SQL decides to dedicate a few gigs of RAM to the ...
1
vote
3answers
733 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
3answers
139 views

How do I get SQL Server (2005) to use all ram?

How do I get SQL Server (2005) to use all ram? (when upgrading ram after SQL Server installation, 16->32gb). Total DB size are 50gb. ram usage grows and stops at 15.5gb. Thanks.
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 ...
4
votes
5answers
260 views

Justifying a memory upgrade

My employer has over a thousand servers (running SQL Server 2005 x64 and a couple of other apps) all across the country. And in my opinion they are all massively underpowered for what they need to ...
1
vote
2answers
138 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 ...
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 ...
2
votes
4answers
1k views

More than 4Gb memory on MS SQL

We have a Database running on MS SQL 2005. We have a bit of a memory problem on that server. We want to up the memory to 8GB but it is running on a Server 2003 R2 standard edition OS. Will it be ...
2
votes
3answers
496 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
1answer
2k views

SQL Server 2005 x64, configuring maximum server memory

I'm a bit of a newbie to configuring SQL server, and have just had to set up a new Server 2008 x64 machine with SQL 2005 x64. Everything seems to be running well, however I have a question regarding ...
2
votes
2answers
455 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 ...
2
votes
4answers
435 views

SQL Server 2005 on 64-bit, Memory > 3GB

Does AWE help on a 64-bit server? The option is still available. Does it do anything?
11
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 ...