Something is eating up ALL RAM.. suggestions?

[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.

 

[Ricardo M. Urbano - W2K/NT4 MVP]

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.

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

 

[Colon Terminus]

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

memory.

 

[Alex]

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

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.

 

[Ricardo M. Urbano - W2K/NT4 MVP]

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.

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.