February 23, 2007 at 6:47 am
Is there a way to find out how much memory a specific database is taking within a SQL Server instance?
February 23, 2007 at 7:11 am
not sure if this can be done. try with fnvirtualstats table.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 23, 2007 at 9:32 am
with regard to what? The main pools of memory used are the proc cache and the data cache. You can view the proc cache and could probably figure out what %age the db is using, as for data cache - no idea, most server I work with have lots of memory so i wouldn't want to sit and look through 30gb of data cache.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 27, 2007 at 4:31 pm
Check out this article:
http://www.sql-server-performance.com/tp_analyzing_sql_server_2000_data_caching.asp
February 27, 2007 at 11:17 pm
In general you can't because memory is instance specific not the database specific...
You can try alternate routes using sysprocesses table and syscacheobjects tables but you don't get accurate value...
MohammedU
Microsoft SQL Server MVP
February 28, 2007 at 3:43 am
using the various dbcc commands can help but to be honest listing the top 20 objects for a number of 600+ table databases isn't truthfully going to be too much use.
I did suggest to microsoft that some extra granularity with regard to many of the perfmon counters would be useful, for instance page splits.
monitoring physical io ( reads ) may help, it depends exactly what it is you want to establish ?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply