MS SQL Server - SQL Server 2005 Express SP1 running out of memory on a VPS

Author

SQL Server 2005 Express SP1 running out of memory on a VPS

craigkenisston@hotmail.com

2006-10-24, 6:28 pm

Using SQL Server 2005 Express SP1 on x32, with 320MB of RAM.

Hi,

I have one of those VPS hosting accounts, with a small amount of disk
space and ram. Specifically 2gb of space and 320MB of free RAM for my
stuff.
I have SQL Server Express 2005 and everything was fine until my
database started to grow.
Now, I have a database with a few table, but the main table has 780,000
rows. The database total size is 550MB.

The problem comes with a very simple operation. I open the management
tool, and the performs:
Select Count(*) from MyMainTable.

Two things happens:
1.- If I already started other applications: This query will return an
error with a clear message that it ran out of memory.
2.- If I log in my account and open Management Studio Express: The
query will run and return me the amount of records, however, I can't do
nothing after that, if I open Internet Explorer I get memory errors,
same if I open Firefox, or the WordPad.

The question is very simple.
With this amount of memory, is it "normal" that I get this error ?
Or, should SQL Server Express 2005 SP1 had to have enough with this to
run ?

Warren Brunk

2006-10-24, 6:28 pm

Why not try reducing the memory needed by using indexes to alleviate table
scans.

Create and Index on important columns that are normally used as keys to
retreive data.

Then Include something on the where clause of your query

Select Count(*) from MyMainTable where IndexedColumn > 0

That should alleviate a lot of pressure if you arent using these methods
already....

thanks,

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/

< craigkenisston@hotma
il.com> wrote in message
news:1158271431.368502.46120@k70g2000cwa.googlegroups.com...
> Using SQL Server 2005 Express SP1 on x32, with 320MB of RAM.
>
> Hi,
>
> I have one of those VPS hosting accounts, with a small amount of disk
> space and ram. Specifically 2gb of space and 320MB of free RAM for my
> stuff.
> I have SQL Server Express 2005 and everything was fine until my
> database started to grow.
> Now, I have a database with a few table, but the main table has 780,000
> rows. The database total size is 550MB.
>
> The problem comes with a very simple operation. I open the management
> tool, and the performs:
> Select Count(*) from MyMainTable.
>
> Two things happens:
> 1.- If I already started other applications: This query will return an
> error with a clear message that it ran out of memory.
> 2.- If I log in my account and open Management Studio Express: The
> query will run and return me the amount of records, however, I can't do
> nothing after that, if I open Internet Explorer I get memory errors,
> same if I open Firefox, or the WordPad.
>
> The question is very simple.
> With this amount of memory, is it "normal" that I get this error ?
> Or, should SQL Server Express 2005 SP1 had to have enough with this to
> run ?
>

craigkenisston@hotmail.com

2006-10-24, 6:28 pm

Sounds good, thank for the hint !

Warren Brunk wrote:[color=darkred
]
> Why not try reducing the memory needed by using indexes to alleviate table
> scans.
>
> Create and Index on important columns that are normally used as keys to
> retreive data.
>
> Then Include something on the where clause of your query
>
> Select Count(*) from MyMainTable where IndexedColumn > 0
>
> That should alleviate a lot of pressure if you arent using these methods
> already....
>
> thanks,
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> */
>
>
> < craigkenisston@hotma
il.com> wrote in message
> news:1158271431.368502.46120@k70g2000cwa.googlegroups.com...

Sponsored Links