• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

SQL 2005 memory utilisation

Hello experts,

Is there any T-SQL query I can run to measure current memory utilisation in SQL server.
SQL Server spec: SQL 2005 SP3 W2K3 Ent SP2, 32 Bit

Please advise.

Thanks and Regards
0
goprasad
Asked:
goprasad
  • 2
  • 2
1 Solution
 
Darran BrownDBACommented:
hi
Are you looking for memory being used by SQL or t-sql to find what various programs  are using on the server?
For the memory that SQL is using, use Task Managaer on the server. Log onto the server, right click the task bar at the bottoom and choose 'Task Manager'.

Thanks
0
 
Darran BrownDBACommented:
You can also use perfomance monitor on the server to collect SQL memory useage over a period of time at set intervals. e.g Check SQL memory usegae every 10 mins for the next 48hrs.
0
 
Daniel_PLDB Expert/ArchitectCommented:
Dynamic views and performance counters is what you should start of.
I recommend good article:
http://www.mssqltips.com/tip.asp?tip=2304
0
 
goprasadAuthor Commented:
When I executed DBCC Memorystatus, the results under buffer counts is as follow (attached image):
Committed is equal to target . Please explain what does this mean?
 Screenshot
0
 
Daniel_PLDB Expert/ArchitectCommented:
This is normal, common situation. It means your memory is stable. Commited being larger than target indicate memory problem - not in your case ;)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now