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
goprasadAsked:
Who is Participating?
 
Daniel_PLConnect With a Mentor DB 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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.