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/
