Upgrade to Win x64 with SQL 2005 x64 to give you the best native memory access.
What's the server config (CPU, memory, IO)?
How many users before performance goes down?
Is your client machine's ODBC logging/trace turned on?
The application is not closing the SQL connection properly so it just keeps on increasing until SQL Server runs out of memory.
You should be able to...
How is the transaction wrapped for the batch job? per record? per hundred thousand records? per some set of records?
How's the primary key...
Have you tried disabling diskkeeper on the server?
How many records is the table you are selecting from?
Have you tried recompile the sp on prod?...
What was your SQL Server max. set to? With only 2GB you can probably do 1.5GB and reserve 500meg for OS. If the OS portion runs out of...
Isn't it fairly risky to allocate agressively to 2764meg on 3GB memory system?
Microsoft created TerraServer (Satellite imaging) that ran on SQL Server and I believe they kept the images in SQL Server (in pieces though, not like...
Try not to use /3GB switch or bump the memory up to 6GB. You are only leaving 1GB for OS and other processes which might not be enough, and did you...
Doesn't this kill the use of index? Do you have those space in the data?
Can you upgrade your server to 3GB memory? What's the speed of the processor (1 or more?)
Are you getting the Opteron CPUs on the quad? Use 8 GB memory or more. SQL 64 bit if you can.
In your case just 20-30 rows the performance difference is not going to matter much.
I agree that you probably need to enable AWE. The memory slider in SQL Server doesn't mean it uses all that much.
When we had 4 GB, it showed 4 GB,...
Windows Enterprise only gives you 8GB before you have to go to DataCenter right?
Do you need to enable AWE to see full 4gig instead of 2.7gig w/o AWE?
> If an application...
Did you run out of disk space?
Use dual CPU/core Opteron servers for best performance, gives your SQL Server 4 GB memory or more w/Enterprise...
Sun v40z dual core + RAID 0
Set DB to read only mode.
Win64 + SQL 2005 64
You should add up to 3 GB memory, 1 GB is too little.
Separate names with a comma.