WiredUK
3/20/2007 2:32:00 PM
Are you running other services on the server?
Is it SQL Server that is becoming slow or the other services?
If it is the other services, then you need to restrict the amount of memory
that SQL Server uses by using the aforementioned MAX memory.
"sudhir" <sudhir@discussions.microsoft.com> wrote in message
news:5B39F37A-2751-4DCD-BE8D-D49ED7E36295@microsoft.com...
> Hi,
> But why this is taking > 1 GB memory? Yes the max server memory is set to
> 2147483647 MB. But once it crosses the 1 GB memory the system becomes too
> slow. Can you please let me know how we can improve the performance? Or
> how
> to release the memory?
>
> Regards
> Sudhir
>
>
> "Uri Dimant" wrote:
>
>> sudir
>> It is by design.SQL Server allocates as much memory as it needs and
>> realeses
>> it ifOS or another application needs the memory
>>
>> Do you have MAX memory set up?
>>
>>
>>
>> "sudhir" <sudhir@discussions.microsoft.com> wrote in message
>> news:6C4F2148-0D0A-45B0-B835-2FECB55809B9@microsoft.com...
>> > Hi,
>> > Can anyone please tell me why sqlservr.exe uses very high memory usage?
>> > In one of our application, we found that the system becoming too slow
>> > because of this SQLSERVR.exe. The momory usage sometimes crossing>1 GB.
>> > Can
>> > you please tell me
>> > What is the function of SQLSERVR?
>> > How to release the momory used by SQLSERVR?
>> > Why the memory usage of SQLSERVR keep on increasing?
>> >
>> > Thanks and Regards
>> > Sudhir
>> >
>> >
>>
>>
>>