471,896 Members | 1,925 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,896 software developers and data experts.

SQL Server Process and Memory Usage

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

Jul 23 '05 #1
2 8554
Hi

What do you term high memory usage?

http://support.microsoft.com/default...b;en-us;321363

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

IM: mi**@epprecht.net

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

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

<w2***@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.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

Jul 23 '05 #2
(w2***@hotmail.com) writes:
Some my SQL Server are experience high memory usage.
That's perfectly normal.
1. How can I detect which process which process cause the big memory
usage and not released?
You can't. The question is not even relevant, as it is the result of
a collective effort.
2. Which sql server components in this memory, and what are their usage
distribution?


When SQL Server reads data from disk, it saves the data in the cache,
because memory access is much less expensive than disk access. Thus,
the strategy is keep as much as possible in cache.

You can constraint how much memory SQL Server can use, but only do this
on machines where SQL Server really competes with other applications.
(A developer workstation is such an example.)

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Justin Lazanowski | last post: by
reply views Thread by Dirk Reske | last post: by
22 posts views Thread by Zen | last post: by
25 posts views Thread by abhinav | last post: by
2 posts views Thread by sql_server_user | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.