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 ? Email me : Mem-VIZ(AT)Thavo(DOT)com or via LinkedIn below
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).