November 30, 2004 at 2:33 pm
Is there a way to get the amount of free memory from within SQL Server? sysperfinfo contains the total amount of physical memory and the total being used by SQL Server. I need a way to get the free memory from within the database. Is it available?
December 1, 2004 at 2:26 am
In a word, no. It's an OS perf counter
December 1, 2004 at 7:37 am
Use the shrink database in the all task menu of the database menu in enterprise manager or look for DBCC SHRINKDATABASE in transact SQL.
December 2, 2004 at 4:23 pm
Dave
are you referring to the amount of free RAM memory ? or are you asking about the amount free disk space in a database file ?
Julian Kuiters
juliankuiters.id.au
December 3, 2004 at 1:32 am
dave,
If you want to know what and how inside SQLserver search BOL (2004) for "Monitoring Memory Usage".
if you want to know about system behaviour I can recommend SPOTLIGHT on SQLserver from Quest ( free to try for 30 days).
Hope this pushes you into the right direction.
Guus.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply