Title: Message
Maybe it has a limit.  Our 2003 SQL sever has 1.57 Gig of memory, and hasn't exceed 1.28 gig total memory usage in at least 30 days.
 
Interesting message in the security log found as I was inspecting "things".
 
"An anonymous session connected from 80.13.219.21 has attempted to open an LSA policy handle on this machine. The attempt was rejected with STATUS_ACCESS_DENIED to prevent leaking security sensitive information to the anonymous caller.
 The application that made this attempt needs to be fixed.  Please contact the application vendor. As a temporary workaround, this security measure can be disabled by setting the \HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\TurnOffAnonymousBlock DWORD value to 1.
 This message will be logged at most once a day."
 
Some evil doer seems to have been trying to connect to our SQL server.
 
route:        80.13.0.0/16
descr:        France Telecom
descr:        Wanadoo Interactive
remarks:      -------------------------------------------
remarks:      For Hacking, Spamming or Security problems
remarks:      SEND A EMAIL TO [EMAIL PROTECTED]
remarks:      -------------------------------------------
origin:       AS3215
mnt-by:       RAIN-TRANSPAC
mnt-by:       FT-BRX
changed:      [EMAIL PROTECTED] 20011016
source:       RIPE
role:         Wanadoo Interactive Technical Role
address:      WANADOO INTERACTIVE
address:      48 rue Camille Desmoulins
address:      92791 ISSY LES MOULINEAUX CEDEX 9
address:      FR
phone:        +33 1 58 88 50 00
e-mail:       [EMAIL PROTECTED]
e-mail:       [EMAIL PROTECTED]
admin-c:      WITR1-RIPE
tech-c:       WITR1-RIPE
nic-hdl:      WITR1-RIPE
mnt-by:       FT-BRX
Cary
 
 
 
 
----- Original Message -----
Sent: Thursday, November 13, 2003 6:49 AM
Subject: [Modus] error log size due to rbl's

Yup, that sounds normal. I would presume that the server was rebooted after the service packs were installed, and hence SQL started by using only the memory necessary. Over time you will find that the SQL Server uses more and more RAM as it will use all the available RAM in the machine. You can adjust this so that it has an upper limit, but if it�s on its own server I wouldn�t bother.

 

-----

If the only thing to survive a plane crash is the black box, why don't they make the whole plane out of the black box?

 
(--------------------------------)         {((((((
(     Suneel Jhangiani           )        /_  _  )
(    Technical Director          )       ( .  .   )
( Inter-Computer Technology Ltd. )        ( /   )
(----------------------------------oOOo------------oOOo----)
( 40 James Street                Tel: +44 (0) 20 7486 9601 ) 
( London W1U 1EU                 Fax: +44 (0) 7050 678 978 )
( United Kingdom               Email: [EMAIL PROTECTED]     )
(             Website: http://www.inctech.com              ) 
(----------------------------------------------------------)

From: Mako Internet [mailto:[EMAIL PROTECTED]
Sent: 12 November 2003 19:15
To: [EMAIL PROTECTED]

 

was fast DNS something that was used in modus 2.x?  I just checked it and it was already enabled.  No wonder I wasn't having problems with microsofts DNS server it wasn't even using it in the first place.  I must have enabled it way back when. 

 

Question on SQL.  I am new to it and was just wondering how much memory does it take when you open up the task manager.  I didn't have any service packs installed on it and it was up to 600,000k now that I have the service pack installed its about 100,000k.  Is that normal?

Reply via email to