Microsoft Regional Director & MVP Azure
1/ Manager at VISEO Technologies
2/ Coach / Consuting : Microsoft Azure, DevOps, ALM TFS
3/ Looking for a challenging job with great conditions ? or need training ? Contact me via https://www.linkedin.com/in/thavo/ or https://twitter.com/vThavo
Saturday, May 15, 2010
SQL optimisation : How to find out the most used T-SQL queries ?
Provided you have the required autorisations to run those SCRIPTS, here are handfull T-SQL query to find out the most used queries within the SQL Server's cache (since the last reboot).