Advanced Search

Return to Snippet

Revision: 25360
at March 29, 2010 02:48 by tvanzele
Updated Code 
Select count(*) as �Number of plans�, sum(cast(size_in_bytes as bigint))/1024/1024 as �Plan Cache Size (MB)�
From sys.dm_exec_cached_plans

Revision: 25359
at March 29, 2010 02:39 by tvanzele
Initial Code 
Select count(*) as ‘Number of plans’, sum(cast(size_in_bytes as bigint))/1024/1024 as ‘Plan Cache Size (MB)’
From sys.dm_exec_cached_plans
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Cached Query Plans

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL