Something is eating up ALL RAM.. suggestions?

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hello,

I'm running Windows 2000 Server with all updates and servicepacks,
plus MS SQL 2000. Something is eating up all my memory, and I'm not
sure how to find-out what. Below is what I've got in Task Manager
under Performance:

Totals:
Handles - 16874
Threads - 876
Processes - 75

Physical Memory:
Total - 2096660
Available - 526024
System Cache - 132560

Commit Charge:
Total - 3699220
Limit - 4469524
Peak - 3730940

Kernel Memory:
Total - 57464
Paged - 38696
Nonpaged - 18778

And it shows current Memory Usage as 3699220. This machine only has 2
gigs of Memory, so what would eat-up almost 1.6 Gigs over? This is
only a database server, so only MS SQL 2000 is running. Is there
someplace I can see what EACH process is taking up so I can track-down
whether SQL is the app taking up all memory?

Thanks for any insight... I'm having to reboot this server evero 3-4
weeks because of this. Thanks,

Alex.
 
Alex said:
Hello,

I'm running Windows 2000 Server with all updates and servicepacks,
plus MS SQL 2000. Something is eating up all my memory, and I'm not
sure how to find-out what. Below is what I've got in Task Manager
under Performance:

Totals:
Handles - 16874
Threads - 876
Processes - 75

Physical Memory:
Total - 2096660
Available - 526024
System Cache - 132560

Commit Charge:
Total - 3699220
Limit - 4469524
Peak - 3730940

Kernel Memory:
Total - 57464
Paged - 38696
Nonpaged - 18778

And it shows current Memory Usage as 3699220. This machine only has 2
gigs of Memory, so what would eat-up almost 1.6 Gigs over? This is
only a database server, so only MS SQL 2000 is running. Is there
someplace I can see what EACH process is taking up so I can track-down
whether SQL is the app taking up all memory?

Thanks for any insight... I'm having to reboot this server evero 3-4
weeks because of this. Thanks,

Alex.
Click to expand...

Dude, did you look in the Processes tab of Task Manager??

BTW, SQL 2000 Standard Edition can and will easily use up to 2GB
physical memory.

hth
 
Alex said:
Hello,

I'm running Windows 2000 Server with all updates and servicepacks,
plus MS SQL 2000 <--- That's it! That's what's eating up all available
Click to expand...
memory.
 
Ricardo M. Urbano - W2K/NT4 MVP said:
Dude, did you look in the Processes tab of Task Manager??

BTW, SQL 2000 Standard Edition can and will easily use up to 2GB
physical memory.

hth
Click to expand...

Ahh.. I didn't have the 'Show process from All Users' selected. Yup..
SQL is taking up 1.1 Gigs, but this still doesn't account for the 3.7
Gigs that's being used. When I add-up all process memory usage, it's
only about 2 Gigs... so any ideas where to find what's using the other
1.7 Gigs? Is there any program that'll show where every bit of memory
usage is going?

Thanks,

Alex.
 
Alex said:
Ahh.. I didn't have the 'Show process from All Users' selected. Yup..
SQL is taking up 1.1 Gigs, but this still doesn't account for the 3.7
Gigs that's being used. When I add-up all process memory usage, it's
only about 2 Gigs... so any ideas where to find what's using the other
1.7 Gigs? Is there any program that'll show where every bit of memory
usage is going?

Thanks,

Alex.
Click to expand...

Actually, no I don't know where the rest of it is.

I use RemotelyAnywhere to monitor my servers and it shows me memory
usage in gory detail.
 
Back
Top