Memory Usage

[osuman]

I'm trying to simulate a problem when SQL Server is using a lot of RAM. I know I can limit how much it uses but I'm trying to determine if it using too much memory is even the problem.

What types of actions against SQL Server cause it to use a lot of memory? Connections, Update statements, etc?

We've tried writing a sample program that opens a lot of connections but it didn't seem to have much effect.

Any ideas are appreciated.

Thanks.

 

[mrdenny]

Each connection uses a very small amount of ram (in the k per connection range).

As data is queried and processed it is cached into RAM for faster access times the next time it is accessed. As the cache fills SQL will automatically move data out of the cache to make room for more recently accessed data.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief