March 6, 2012 at 9:19 pm
How to allocate memory for a particular DB in a server.
March 6, 2012 at 10:29 pm
Actual my doubt is ,
Can we allocate resources to particular dB’s, if not what is the best part to take care of imp dB’s .
March 6, 2012 at 10:42 pm
Look up resource governor
http://msdn.microsoft.com/en-us/library/bb933944%28v=sql.100%29.aspx
March 7, 2012 at 4:18 pm
Create a separate instance of SQL on the same server and allocate the memory to that.
😀
March 7, 2012 at 10:43 pm
charipg (3/6/2012)
...Can we allocate resources to particular dB’s, if not what is the best part to take care of imp dB’s .
No, it is not possible to reserve memory for a particular database. SQL Server manages memory dynamically.
Your database would remain in the memory in the form of pages if the pages are used by queries frequently.
Run the following query to see memory consumed by the DBs:
select count(*)*8/1024 AS 'Cached Size (MB)'
,case database_id
when 32767 then 'ResourceDB'
else db_name(database_id)
end as 'Database'
from sys.dm_os_buffer_descriptors
group by db_name(database_id), database_id
order by 'Cached Size (MB)' desc
(I don't remember the source of this query)
Are you facing any performance issue?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply