SQL memory usage question 
Author Message
 SQL memory usage question

Hi there.  I wonder if some more experienced people
can offer suggestions on how to tame SQL's memory
usage when dealing with large DBs.

We have multiple databases and tables, but one of them
in particular is large compared to the others.  It is a table
with 100,000 records and 10 columns.  Most of the data
is varchar because there are a lot of address and name
fields.  The whole DB file that contains this table is only
40MB, yet when I open the table in Enterprise Manager
system RAM used goes from 120MB to 240MB, and
the CPU goes to 100% utilization.  Is SQL configured
improperly, or is it natural for a 100,000 record table
to use over 100MB RAM just to open?

Francesco Sanfilippo


Internet Developer,
NT/SQL Administrator,
http://www.***.com/



Sun, 05 May 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. ADO Causes 100% Memory Usage/Increases in VM Usage

2. Memory Usage question

3. Memory usage question

4. memory usage questions

5. Memory Usage Question

6. Sybase V5.0 Memory Usage Question

7. Memory usage of dataserver question

8. A question on shared memory usage

9. Shared Virtual Memory Usage Question

10. Abnormal memory usage of SQL-server

11. SQL SERVER MEMORY USAGE

12. SQL Server hogging up CPU usage / memory leaks


 
Powered by phpBB® Forum Software