sqlserver 2005 using more memory than usual

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ravinder panchal - 14 Mar 2008 14:10 GMT

we are using sqlserver 2005 on windows server 2003 sp1 with 4 gb of ram.
sqlservr .exe normally shows 70 aor 80 mb memory utilization.but from last
few days it is showing 700 mb to 800mb due to which our processing become too
slow.
Please give solution to solve this problem. and why it is using so much
memory.

Reply to this Message

Tom Moreau - 14 Mar 2008 14:41 GMT

That's no much memory at all. You may want to run a profiler trace and
determine which specific queries are running slower. Then, analyze them for
appropriate indexing.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

we are using sqlserver 2005 on windows server 2003 sp1 with 4 gb of ram.
sqlservr .exe normally shows 70 aor 80 mb memory utilization.but from last
few days it is showing 700 mb to 800mb due to which our processing become
too
slow.
Please give solution to solve this problem. and why it is using so much
memory.

Reply to this Message

Linchi Shea - 15 Mar 2008 04:52 GMT

How did you determine the amount of memory used by SQL Server?

Linchi

> we are using sqlserver 2005 on windows server 2003 sp1 with 4 gb of ram.
> sqlservr .exe normally shows 70 aor 80 mb memory utilization.but from last
> few days it is showing 700 mb to 800mb due to which our processing become too
> slow.
> Please give solution to solve this problem. and why it is using so much
> memory.

Reply to this Message

ravinder panchal - 15 Mar 2008 05:43 GMT

by taskmanager (sqlservr.exe)

> How did you determine the amount of memory used by SQL Server?
>
[quoted text clipped - 6 lines]
> > Please give solution to solve this problem. and why it is using so much
> > memory.

Reply to this Message