MS SQL Server - SQL 2000 high virtual memory

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL 2000 high virtual memory

Dion Davis

2006-04-06, 11:24 am

Hi,

We've got a Win 2003 SE server running with 2GB RAM and SQL 2000 SE
installed. The virtual memory usage for sqlservr.exe seems to be rather high
though - the Mem Usage in task manager for this process is around 450MB
which seems fine but the VM Size is 1.7GB. Any ideas why it ight be so high?

Thanks - D.

John Bell

2006-04-07, 3:24 am

Hi

This may be an indication that you have a memory bottleneck, check the
perfmon counters and see the memory usage in more detail and to see if you
are paging to disc.

John

"Dion Davis" wrote:

> Hi,
>
> We've got a Win 2003 SE server running with 2GB RAM and SQL 2000 SE
> installed. The virtual memory usage for sqlservr.exe seems to be rather high
> though - the Mem Usage in task manager for this process is around 450MB
> which seems fine but the VM Size is 1.7GB. Any ideas why it ight be so high?
>
> Thanks - D.
>
>
>

Sponsored Links