Showing posts with label memory. Show all posts
Showing posts with label memory. Show all posts

Monday, March 12, 2012

MSDE & Memory

Hello
Win2000, 1Gb RAM
One database, 1-5 concurrent connections
and MSDE takes all memory, free is only 50-60MB RAM
Where it goes and why it takes so much memory ?
Meelis
hi,
Meelis Lilbok wrote:
> Hello
> Win2000, 1Gb RAM
> One database, 1-5 concurrent connections
> and MSDE takes all memory, free is only 50-60MB RAM
> Where it goes and why it takes so much memory ?
>
please have a look at http://tinyurl.com/c38uf
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

msde - uses too much memory and is getting very slow!

Juergen,
What else is this computer used for?
If only MSDE, then the system page file can be reduced to a minimum (or even
eliminated) -thereby reducing the memory 'pressure' on SQL Server (MSDE).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eOxWF3zAHHA.996@.TK2MSFTNGP02.phx.gbl...
> hi newsgroup!
> we have already some msde databases installed and we didn't had any
> troubles until now!
> the OS is a Windows XP prof. SP2 with MSDE Version; msde desktop engine
> 8.00.7630SP3
> now our trouble is that the sqlserver.exe process is using more and more
> ram and the pagefile grows and grows!
> The PC (server) HP DL385 has 2 GB RAM so this shuldn't be the problem! So
> when the sqlserver.exe process is running about 2-3 days the amout of
> memory usages grows to 1,3GB and about this size the PC is realy getting
> slow, so you can't work anymore!
> The problem is solved when i start and stop the sqlserver, but this isn't
> how i will solve the problem!
> So does anyone have the some troubles, and does anybody now how to solve
> this problem?
> kind regards
> Juergen Strutzenberger
>
What has changed in the past short period of time? New VB.NET program?
Does the VB.NET program properly dispose of all connection objects created?
You may want to run performance monitor to discover what is using the cpu
cycles and the memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eaVNo1BBHHA.3396@.TK2MSFTNGP02.phx.gbl...
> we also run a selfe made programm, witch is programmed with VB.net!
> we already uninstalled some programs we didn't need!
> we also removed the Norton AV because we thought that this is using to
> much ressources and the pc is getting slow!
> bye
> juergen
> "Arnie Rowland" <arnie@.1568.com> schrieb im Newsbeitrag
> news:eSaidM1AHHA.4808@.TK2MSFTNGP03.phx.gbl...
>
|||What has changed in the past short period of time? New VB.NET program?
Does the VB.NET program properly dispose of all connection objects created?
You may want to run performance monitor to discover what is using the cpu
cycles and the memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eaVNo1BBHHA.3396@.TK2MSFTNGP02.phx.gbl...
> we also run a selfe made programm, witch is programmed with VB.net!
> we already uninstalled some programs we didn't need!
> we also removed the Norton AV because we thought that this is using to
> much ressources and the pc is getting slow!
> bye
> juergen
> "Arnie Rowland" <arnie@.1568.com> schrieb im Newsbeitrag
> news:eSaidM1AHHA.4808@.TK2MSFTNGP03.phx.gbl...
>
|||What has changed in the past short period of time? New VB.NET program?
Does the VB.NET program properly dispose of all connection objects created?
You may want to run performance monitor to discover what is using the cpu
cycles and the memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eaVNo1BBHHA.3396@.TK2MSFTNGP02.phx.gbl...
> we also run a selfe made programm, witch is programmed with VB.net!
> we already uninstalled some programs we didn't need!
> we also removed the Norton AV because we thought that this is using to
> much ressources and the pc is getting slow!
> bye
> juergen
> "Arnie Rowland" <arnie@.1568.com> schrieb im Newsbeitrag
> news:eSaidM1AHHA.4808@.TK2MSFTNGP03.phx.gbl...
>