Being day 12 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC FREEPROCCACHE. Description: DBCC FREEPROCCACHE is used for purge all of the parsed query plans out of memory. This is commonly used in development environments, but not as common in a production environment. Use in a development environment is common, for instance when you are …
I often get asked “how do I find the contents of the SQL Server Plan Cache?” My first response is just use the Database Health Reports and you can get this through a nice user interface. But if you still want to get at the Plan Cache contents, I use the following query. Again, the Database Health Reportsgives you a …
Originally I implemented the Database Health Reports as a series of SQL Server Reporting Services reports, which was very handy and easy to create, but hard to distribute in a way that they could be shared and customized to the needs of a project like the Database Health Reports should be. Here is what I have so far, and I think …