How much memory does an open database consume
-
Hi Scanners,
I have a WIN2K Server running sqlserver V7. It has 49 databases on it many of which are in an open state but not actually used, Is there any rule of thumb as to how much memory these databases are consuming or anyway of finding out ? also is there anyway I can identify which databases are not actually used no one in my organisation seems to know! I've only got 640Mb memory to play with and am continually getting memory bottlenecks and need to find ways of reduceing the overhead.
Thanks in advance
-
Why not do an SP_WHO2 and see who is connected to what. You could monitor that for awhile and you should get an idea as to which of the 49 databases are being used, and then simply take those that are not off line.
Hope this helps...
Ford Fairlane
Rock and Roll Detective
-
If the database is not used it will not require a lot of memory. BOL states that each open database uses 2,880 bytes. Unless any tables in it are pinned in memory there will not be any pages buffered from it so there should not be much to worry about. But you should of course remove databases that are really not used at all unless you have a reason to keep them.
-
Got this in your private message. Please keep the discussion here, that way all members can participate and help out.
How will I know if a table is 'pinned' in memory
Use the OBJECTPROPERTY 'TableIsPinned':
SELECT OBJECTPROPERTY( OBJECT_ID( 'tablename' ) , 'TableIsPinned' )But this is not someting that is normally done. If you do find any pinned tables you should find out why they are pinned, since that is a very drastic decision. In general SQL Server handles the meory very well by itself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply