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? RegardsJohan
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx &<a target="_blank" href=http://sqlserver-qa.net/blogs/perftune/default.aspx>http://sqlserver-qa.net/blogs/perftune/default.aspx</a> (fresh from oven[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]) and<a target="_blank" href=http://sqlserver-qa.net/blogs/perftune/search.aspx?q=index&p=1>http://sqlserver-qa.net/blogs/perftune/search.aspx?q=index&p=1</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>
]]>