Datawarehouse for sys.dm_exec_query_stats | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Datawarehouse for sys.dm_exec_query_stats

I#%92m wondering if there is anyone out there that has link or samples of how snapshots over the time from sys.dm_exec_query_stats and then make data warehouse or function that make trends analyes over time. Something like the “Analyzing operational index statistics” from “Troubleshooting Performance Problems in SQL Server 2005” whitepaper? Regards
Johan &<a target="_blank" href=></a> (fresh from oven[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]) and<a target="_blank" href=></a> fyi in relation to what you are looking.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>