Re: SQL Server memory use grows

[eric . laney]

According to Microsoft's documentation (for what that's worth) SQL Server
will not dynamically allocate memory if that allocation would cause
swapping.  The OS might, but not SQL Server.
|--------------+----------------------------------------------------------|
|Eric A. Laney |"A beautiful woman is the hell of the soul, the purgatory |
|Systems       |of the purse, and the paradise of the eyes."              |
|Engineer      |                                                          |
|LAN           |                                                          |
|Optimization  |                                              - Fontenelle|
|Team          |                                                          |
|Voice:        |                                                          |
|813.978.4404  |                                                          |
|Pager:        |                                                          |
|888.985.8519  |                                                          |
|--------------+----------------------------------------------------------|





                                                                                       
                                           
                    "tom muck"                                                         
                                           
                    <tommuck@basic-dru        To:     CF-Talk 
<[EMAIL PROTECTED]>                                         
                    mbeat.com>                cc:                                      
                                           
                                              Subject:     Re: SQL Server memory use 
grows                                        
                    07/25/2001 01:22                                                   
                                           
                    PM                                                                 
                                           
                    Please respond to                                                  
                                           
                    cf-talk                                                            
                                           
                                                                                       
                                           
                                                                                       
                                           




You shouldn't have to "wait and see".  There is a specified amount used by
SQL Server which you can find out by right-clicking on the server in the
Enterprise Manager and then click the Memory tab.  I think it's set to 768
megs by default as the max and 0 as the min. You can also specify a fixed
amount of memory.  If you only have 512, you should set it to well below
this value so that it doesn't start using virtual memory.

tom
www.basic-ultradev.com

"John Fix 3rd" <[EMAIL PROTECTED]> wrote in message
000601c11527$39372e30$6a2f43ce@MONSTER">news:000601c11527$39372e30$6a2f43ce@MONSTER...
> There's 512mb installed right now.  OK, if that doesn't seem out of
> line, then I'll leave it for a longer period next time and see what
> happens.
>
> Thanks!
>
> John
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists