Title: Message

SQL will by default use all available system memory.

 

SQL servers should be dedicated machines doing nothing more than SQL

OR you should have a ton of memory and set SQL to use only 800 megs or so depending on your needs

 

The more memory you let it use the better it will perform, but it will consume all memory if you let it.

 

John

 

PS, service packs are a must J

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Herrera
Sent: Wednesday, November 12, 2003 2:26 PM
To: [EMAIL PROTECTED]
Subject: [Modus] error log size due to rbl's

 

 

Not having any service packs on SQL is begging, pleading for trouble.  It would be a good idea to do get those done before you do anything else.

 

MikeH

 


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mako Internet
Sent: Wednesday, November 12, 2003 1:15 PM
To: [EMAIL PROTECTED]
Subject: [Modus] error log size due to rbl's

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