Advanced Search

Return to Snippet

Revision: 25358
at March 29, 2010 02:51 by tvanzele
Updated Code 
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;

Revision: 25357
at March 29, 2010 02:49 by tvanzele
Updated Code 
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;

Revision: 25356
at March 29, 2010 02:38 by tvanzele
Initial Code 
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;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Buffer pool usage per database

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL