Posted by Mike Epprecht \(SQL MVP\) on 06/18/05 01:12

Hi

What do you term high memory usage?

http://support.microsoft.com/default.aspx?scid=kb;en-us;321363

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

<w2jin@hotmail.com> wrote in message
news:1119044172.140263.205990@o13g2000cwo.googlegroups.com...
> Hi All
>
> Some my SQL Server are experience high memory usage.
>
> 1. How can I detect which process which process cause the big memory
> usage and not released?
>
> 2. Which sql server components in this memory, and what are their usage
> distribution?
>
> Any help will be appreciated.
>
> Thanks
> Willie
>

• Next in forum: Re: CHECKSUM_AGG and BINARY_CHECKSUM performance problems
• Prev in forum: Re: Deadlock in View with Select Union - Creating A/S Dimension
• Thread view: Re: SQL Server Process and Memory Usage

[Reply to this message]