September 18, 2008 at 3:55 am
hi,
OS- windows 2000 server with service pack 3.
database - sql server 2000
we have faced huge problem for sql server 2000 in memory utliazation sqlservr.exe, i was found in task manager sqlservr.exe has taking 800 MB at that time, we just rebooting server after that it shows 50 MB and keep on increasing memory size within one day it has been reached 800 MB, but we can not rebooting server frequently.
pls tell me any suggestion, thanks
September 18, 2008 at 4:00 am
It is good sing that sql server using required memory until unless there is a performance issue or there is no memory for another application.
If you want to find what is causing huge memory utilization.
You can find using the following tools
1. Windows performance monitor and use appropriate parameters related to memory.
2. select * from sysprocesses and find the SPID which is using more memory.
3. Find out any long running transactions or uncommited transactions or any transactions that are in a state of rollback.
Please let me know what is the problem you are facing while sqlserver.exe using 800 MB of memory.
Rajesh Kasturi
September 18, 2008 at 4:20 am
Actually this is secondary server with configured merge replication, so i have checked last day on replication jobs but its showing unsuccessfully, i think this is main problem of keep on increasing memory size.
September 18, 2008 at 4:22 am
RAM size is 1GB in secondary server
September 18, 2008 at 4:39 am
You can set the max memory for SQL under the server properties. If you don't set that, SQL will take as much memory as it can.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 18, 2008 at 6:49 am
also check if the server is VM server.
For me coz of VM server the sql memory usually goes that high!!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply