General discussion

Locked

sqlservr.exe suddenly consuming more memory

By shireenreddy ·
hi all...

environment:
Windows server 2003 sp2
RAM 4GB
Sql Server 2000 sp4
single instance
only one database
four jobs are running there.
installed 2yrs back and running cool,suddenly the sqlservr.exe consuming nearly 3gb. previously it was below 1gb.
i'm not able to get what exatly the problem.
please some one help me.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Well something has changed.

by Tony Hopkinson In reply to sqlservr.exe suddenly con ...

By default sql server will suck up every byte it can get hold of, you can tell it not to like so
http://msdn.microsoft.com/en-us/library/ms178067.aspx

Collapse -

I guess he didn't

by cmiller5400 In reply to Well something has change ...

I guess he didn't like my answer and decided to post under another name

http://techrepublic.com.com/5208-6230-0.html?forumID=101&threadID=318519

Collapse -

I dunno

by Tony Hopkinson In reply to I guess he didn't

I just assumed it was the same fella, may be the first one to 'get' the right answer gets the job....

Back to Networks Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums