January 1, 2008 at 6:09 am
I am running an application which is having sql server 2000(enterprise)
as a back end.
When I start my application the memory usage of sqlservr.exe starts increasing rapidly(When viewed in Windows Task Manager)
Is it so because My database is growing?
Also when this(sqlservr.exe memory usage) reaches to around 800MB,my application slows down.
Can anybody tell me why this is happening and is there anyway to increase the performance?
January 1, 2008 at 1:14 pm
Sql server,most other databases and recently Vista keep data in cache (empty memory=wasted memory) to operate faster by avoiding disk access. Thats why its memory usage continues to grow (in dynamic memory management mode) till it decides that more memory wouldn't benefit its operations (or hitting the memory limit)
You could configure the sql server to have a maximum limit (although 800mb isn't really much). Is total memory used on your system close to the physical (installed) memory? If it is greater, the OS has to swap pieces of data out of memory and to disk (and vice versa)
Can the application be moved to another system? Sql server 2000 enterprise works best when there is no constant strugggle over resources (cpu,io,...) with other apps (like IIS).
January 3, 2008 at 11:06 pm
thanks a lot.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply