|
|
You're in the
sql server msde
group:msde - uses too much memory and is getting very slow!
sql server msde:
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 [quoted text, click to view] "Jürgen 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 >
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
hi Jürgen,
[quoted text, click to view] Jürgen Strutzenberger wrote: > 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? > Loosely speaking, SQL Server organize it's memory allocation in two distinct regions, the "buffer pool" (BPool) and the "memory to leave" (MemToLeave) regions. (I'm excluding use of AWE in order to provide easy understanding and because MSDE does not admit it).. so... the BPool is the primary region SQL Server uses for it's internal matter, while MemToLeave consists of the virtual memory space within the 1gb user mode address space and the memory not used by the BPool. when SQL Server starts, it begins calculating the upper limit the BPool can reach... if no MaxMemory is set, this value will be set to the amount of the physical memory or the size of the user mode address space (1gb) , minus the size of the MemToLeave, whichever is less.. by default, MemToLeave is set to 384mb, 128mb of them are for worker thread stacks and 256mb for allocation outside the BPool, such as memory for OLE-DB providers, linked server drivers, NetLib dlls, in process COM objects space and memory requirements and so on.. when MaxMemory value is explicitally set, this upper limit will only address BPool region needs... so only the address space of BPool pages is limited by this configuration value, while SQL Server memory requirememts outside BPool allocation are not limited this way... more, each connection, live or sleeping, will eat about 24kb of memory, calculated as 12 KB + 3 times the Network Packet Size (default setting that can be partially customized via sp_configure system stored procedure modifying the 'user connections' setting), used to store the data structures holding the connection 's context, as long as for buffer used to send and receive the relative associated network streams (default to 4KB network packet setting), that can be stolen from the buffer pool memory region and/or the MemToLeave memory area... not limiting the resources, SQL Server can reclaim that memory (up to 1 gb, in our example) for it's uses, and it will perhaps release it only under pressure by the OS claiming for additional memory, if it's the case, else it will maintain that memory in order to cache pages and execution plans... under OS pressure, SQL Server will try having the Lazy Writer releasing resources, but you are not granted that this will occur, even if SQL Server will always try to leave some memory for other OS needs, usually between 4 and 10mb of RAM... so, on SQL Server dedicated servers, you usually see memory usage climbing to the top and staying there for long time, becouse of SQL Server tends to keep pages read from disk in memory to increase further and successive access to those pages, as long as query plans and so on... on a heavy loaded server, if you add web server duty, you will have resources contentions for sure... so, it's quite a normal behaviour... remember that memory usage is database and application dependent, but usage and workloads dependent too... an interesting reading can be found at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_03252004.asp -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz http://italy.mvps.org DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools --------- remove DMO to reply
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 [quoted text, click to view] "Jürgen 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... >> 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 >> >> >> "Jürgen 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 [quoted text, click to view] "Jürgen 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... >> 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 >> >> >> "Jürgen 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 [quoted text, click to view] "Jürgen 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... >> 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 >> >> >> "Jürgen 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 >>> >> >> > >
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... [quoted text, click to view] > 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 > > > "Jürgen 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 >> > >
hi Jürgen,
[quoted text, click to view] Jürgen Strutzenberger wrote: > 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! as regards AV protection, I'm not sure it's a good idea to remove it if the running box is exposed to viruses risk... what you can do is defining exlusions for .MDF and .LDF files, so that SQL Server database's files get not inspected by the AV as this usually results in conflicts and problems with IO operations.. regards -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz http://italy.mvps.org DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools --------- remove DMO to reply
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |