WSUS and Memory CipherTeKST 6/19/2007 7:47:03 PM I have a WSUS setup on a Windows Server 2000 machine. Every 2 to 3 weeks or so the process that is running the MSSQL$WSUS service starts to use alot of memory. I am trying to find out why and if there is anthing to do to prevent this from happening. The machines has over 2GB of memory and this process/service is taking up almost 3/4 of it. Thanks! -- CipherTeKST MCSE: Security 2003, CCNA, Security+

Re: WSUS and Memory "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 6/21/2007 12:31:27 AM "CipherTeKST" <CipherTeKST[ at ]discussions.microsoft.com> wrote in message news:0A864E29-BEEA-4C03-817B-B2772262293A[ at ]microsoft.com... [Quoted Text] >I have a WSUS setup on a Windows Server 2000 machine. Every 2 to 3 weeks or > so the process that is running the MSSQL$WSUS service starts to use alot > of > memory. I am trying to find out why and if there is anthing to do to > prevent > this from happening. The machines has over 2GB of memory and this > process/service is taking up almost 3/4 of it. Doesn't really matter that the machine has over 2GB of RAM, since MSDE2000 won't use it anyway. What CPU is in this Win2000 server? What kind of disk drives/controllers are in this Win2000 server? How many clients do you have being serviced by this server? My educated guess is that the database server is executing an internal maintenance utility triggered by the rowcount size of the tbEventInstance table, and it's just dragging the machine down. -- Lawrence Garvin, M.S., MCTS, MCP Independent WSUS Evangelist MVP-Software Distribution (2005-2007) https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E Everything you need for WSUS is at http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx And, almost everything else is at http://wsusinfo.onsitechsolutions.com .....

Re: WSUS and Memory CipherTeKST 6/21/2007 6:43:02 PM Answers to your questions.... Intel Xeon CPU 2.4ghz RAID 5 95 computers Any help or suggestions will be appreciated. Thanks! -- CipherTeKST MCSE: Security 2003, CCNA, Security+ "Lawrence Garvin (MVP)" wrote: [Quoted Text] > > "CipherTeKST" <CipherTeKST[ at ]discussions.microsoft.com> wrote in message > news:0A864E29-BEEA-4C03-817B-B2772262293A[ at ]microsoft.com... > >I have a WSUS setup on a Windows Server 2000 machine. Every 2 to 3 weeks or > > so the process that is running the MSSQL$WSUS service starts to use alot > > of > > memory. I am trying to find out why and if there is anthing to do to > > prevent > > this from happening. The machines has over 2GB of memory and this > > process/service is taking up almost 3/4 of it. > > Doesn't really matter that the machine has over 2GB of RAM, since MSDE2000 > won't use it anyway. > > What CPU is in this Win2000 server? > > What kind of disk drives/controllers are in this Win2000 server? > > How many clients do you have being serviced by this server? > > My educated guess is that the database server is executing an internal > maintenance utility triggered by the rowcount size of the tbEventInstance > table, and it's just dragging the machine down. > > -- > Lawrence Garvin, M.S., MCTS, MCP > Independent WSUS Evangelist > MVP-Software Distribution (2005-2007) > https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E > > Everything you need for WSUS is at > http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx > > And, almost everything else is at > http://wsusinfo.onsitechsolutions.com > ..... > > >

Re: WSUS and Memory "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 6/22/2007 3:26:20 AM [Quoted Text] >> "CipherTeKST" <CipherTeKST[ at ]discussions.microsoft.com> wrote in message >> news:0A864E29-BEEA-4C03-817B-B2772262293A[ at ]microsoft.com... >> >I have a WSUS setup on a Windows Server 2000 machine. Every 2 to 3 weeks >> >or >> > so the process that is running the MSSQL$WSUS service starts to use >> > alot >> > of >> > memory. I am trying to find out why and if there is anthing to do to >> > prevent >> > this from happening. The machines has over 2GB of memory and this >> > process/service is taking up almost 3/4 of it. >> Doesn't really matter that the machine has over 2GB of RAM, since >> MSDE2000 >> won't use it anyway. >> >> What CPU is in this Win2000 server? > Intel Xeon CPU 2.4ghz >> What kind of disk drives/controllers are in this Win2000 server? > RAID 5 >> How many clients do you have being serviced by this server? > 95 computers >> My educated guess is that the database server is executing an internal >> maintenance utility triggered by the rowcount size of the tbEventInstance >> table, and it's just dragging the machine down. Okay, next set of questions: What is the configured detection interval for these client systems? What *else* is running on this Xeon 2.4Ghz/2GB RAM system. (And.. please.. forgive me for being curious about how hardware that new and high-end is still running Windows 2000 as the OS?) -- Lawrence Garvin, M.S., MCTS, MCP Independent WSUS Evangelist MVP-Software Distribution (2005-2007) https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E Everything you need for WSUS is at http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx And, almost everything else is at http://wsusinfo.onsitechsolutions.com .....

Re: WSUS and Memory CipherTeKST 6/22/2007 4:13:01 AM The configured detection level i'm not sure, i assume whatever the default is at installation. Now for the OS.... lets just say... i wasn't the one to make that decision and also not the one who makes the "in the budget" decisions either... haha Any help will be greatly appreciated! Thanks in advance. -- CipherTeKST MCSE: Security 2003, CCNA, Security+ "Lawrence Garvin (MVP)" wrote: [Quoted Text] > >> "CipherTeKST" <CipherTeKST[ at ]discussions.microsoft.com> wrote in message > >> news:0A864E29-BEEA-4C03-817B-B2772262293A[ at ]microsoft.com... > >> >I have a WSUS setup on a Windows Server 2000 machine. Every 2 to 3 weeks > >> >or > >> > so the process that is running the MSSQL$WSUS service starts to use > >> > alot > >> > of > >> > memory. I am trying to find out why and if there is anthing to do to > >> > prevent > >> > this from happening. The machines has over 2GB of memory and this > >> > process/service is taking up almost 3/4 of it. > > > >> Doesn't really matter that the machine has over 2GB of RAM, since > >> MSDE2000 > >> won't use it anyway. > >> > >> What CPU is in this Win2000 server? > > > Intel Xeon CPU 2.4ghz > > >> What kind of disk drives/controllers are in this Win2000 server? > > > RAID 5 > > >> How many clients do you have being serviced by this server? > > > 95 computers > > >> My educated guess is that the database server is executing an internal > >> maintenance utility triggered by the rowcount size of the tbEventInstance > >> table, and it's just dragging the machine down. > > Okay, next set of questions: > > What is the configured detection interval for these client systems? > > What *else* is running on this Xeon 2.4Ghz/2GB RAM system. > (And.. please.. forgive me for being curious about how hardware that new > and high-end is still running Windows 2000 as the OS?) > > -- > Lawrence Garvin, M.S., MCTS, MCP > Independent WSUS Evangelist > MVP-Software Distribution (2005-2007) > https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E > > Everything you need for WSUS is at > http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx > > And, almost everything else is at > http://wsusinfo.onsitechsolutions.com > ..... > > >

Re: WSUS and Memory "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 6/22/2007 5:08:43 AM "CipherTeKST" <CipherTeKST[ at ]discussions.microsoft.com> wrote in message news:E4EAC668-8D40-4D1C-B65E-DCA4071D7BB8[ at ]microsoft.com... [Quoted Text] >> >> My educated guess is that the database server is executing an internal >> >> maintenance utility triggered by the rowcount size of the >> >> tbEventInstance >> >> table, and it's just dragging the machine down. >> Okay, next set of questions: >> >> What is the configured detection interval for these client systems? > The configured detection level i'm not sure, i assume whatever the default > is > at installation. This really is a critical question at this point of the diagnostics. Can you please export and post the registry subkeys and values from the key at HKLM\Software\Policies\Microsoft\Windows\WindowsUpdate from one of the /client/ systems. >> What *else* is running on this Xeon 2.4Ghz/2GB RAM system. You didn't answer this one. >> (And.. please.. forgive me for being curious about how hardware that >> new >> and high-end is still running Windows 2000 as the OS?) > Now for the OS.... lets just say... i wasn't the one to make > that decision and also not the one who makes the "in the budget" decisions > either... haha I hear ya! ;-) -- Lawrence Garvin, M.S., MCTS, MCP Independent WSUS Evangelist MVP-Software Distribution (2005-2007) https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E Everything you need for WSUS is at http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx And, almost everything else is at http://wsusinfo.onsitechsolutions.com .....