Just FYI, what this is doing is setting two SQL Server configuration options called "min server memory" and "max server memory" to the same value. Here's a link for more info: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/archite c/8_ar_sa_40vt.asp . From that page, "If the same value is specified for both min server memory and max server memory, then once the memory allocated to the database engine reaches that value, the database engine stops dynamically freeing and acquiring memory."
Larry Ipswitch, Inc. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Donnelly Sent: Friday, September 16, 2005 1:30 PM To: [email protected] Subject: RE: [WhatsUp Forum] WUP Performance (was: WhatsUp with this forum?) Well, I won't claim to know everything about performance, but I have information from one user who changed the SQL settings so that can use more memory and he indicated his went "from almost unusable to perfect" (yes, his words!). Here is his "tip": "...for users that don't like to pay for a MSSQL when the MSDE can do the job, it greatly improves performance in WUP." 1. Install MSSQL Enterprise manager on the machine running Whats UP Pro. 2. Connect to the WhatsUP MSDE database server from Enterprise Manager. Use LOCALHOST\WhatsUP or something like that, look in the ODBC settings if it doesn't work. 3. Choose Properties for the MSDE database WhatsUP 4. Choose Memory. Change from dynamic, allowing the DB to use from 0 to 4 MB's of memory, to static (locked) at minimum 256 MB. I would recommend 512 MB on your configuration (make sure u don't run out of memory). 5. After changing, press ok and restart the MSDE server (reboot might be needed). Now Whats Up Pro should perform a bit better ---------------------------- How much memory is sqlservr.exe using? How big are the whatsup.ldf and whatsup.mdf files? If either of these is pushing 2 gb, then your database is at or near the limits. There are KB articles that talk about WU settings and methods of reducing the stored data. Or you could switch to a full SQL server rather than the MSDE that comes with WU (if above is not enough). Oh, if you wanted to really try an 'automatic reboot', a scheduled task running a few simple DOS commands ('net stop' and 'net start'), could stop then restart the WhatsUp Pro related services on a regular basis. Not that I would recommended this...but as a last resort, maybe. Not so sure about any existing memory leaks. I was under the impression those were fixed. It is unlikely that Ipswitch would want to let them exist! However, if you have one that cannot be duplicated by Ipswitch testing, there is a possibility it might still exist. And the problem might not be WUP code, but something else in your system. Have you checked your event logs and fixed any problems or warnings you find there? If not, then only when you system is solid, can you determine if those problems were or were not the cause of the WUP problem. And you should perform testing of the HD system and platters. CHKDSK /F and a reboot still work well! Don't forget to defrag the drives, too (especially if used for other tasks that frequently update files). HTH, Daniel Donnelly -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Sean McAnally Sent: Friday, September 16, 2005 11:03 AM To: [email protected] Subject: RE: [WhatsUp Forum] WhatsUp with this forum? My server has to be rebooted weekly because of a memory leak in their code. I have all the latest patches and it still has the leak. Performance is really good....for the first day. After that it's all downhill until the next reboot. Maybe they will add an automatic reboot to the system. Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
