Index Usage Queryhttp://blogs.msdn.com/microsoft_dynamics_nav_sustained_engineering/archive/2008/02/26/index-usage-query.aspxThis is a follow up from an earlier blog "Finding Index usage" . In that blog, I described a very simple way to list how indexes are being used. In this blog, the query is much extended so that it now shows your Navision keys, listed by either numberen-USCommunityServer 2.1 SP1 (Build: 61025.2)Simple query to check the recent blocking historyhttp://blogs.msdn.com/microsoft_dynamics_nav_sustained_engineering/archive/2008/02/26/index-usage-query.aspx#8341220Fri, 28 Mar 2008 11:21:08 GMT91d46819-8472-40ad-a661-2c78acb4018c:8341220Microsoft Dynamics NAV Sustained Engineering Team Blog<p>SQL Server 2005 keeps (some) history of the number and time that blocking occurred on indexes. This blog</p>Simple query to check the recent blocking historyhttp://blogs.msdn.com/microsoft_dynamics_nav_sustained_engineering/archive/2008/02/26/index-usage-query.aspx#8341367Fri, 28 Mar 2008 13:08:36 GMT91d46819-8472-40ad-a661-2c78acb4018c:8341367Microsoft Dynamics NAV Sustained Engineering Team Blog<p>SQL Server 2005 keeps (some) history of the number and time that blocking occurred on indexes. This blog</p>Modern NAV/SQL troubleshooting IIhttp://blogs.msdn.com/microsoft_dynamics_nav_sustained_engineering/archive/2008/02/26/index-usage-query.aspx#8593014Thu, 12 Jun 2008 14:51:14 GMT91d46819-8472-40ad-a661-2c78acb4018c:8593014Microsoft Dynamics NAV Sustained Engineering Team Blog<p>Please refer to this post about what I mean with &quot;modern troubleshooting&quot;. This post describes methods</p> Modern NAV/SQL troubleshooting IIhttp://blogs.msdn.com/microsoft_dynamics_nav_sustained_engineering/archive/2008/02/26/index-usage-query.aspx#8593684Fri, 13 Jun 2008 00:33:57 GMT91d46819-8472-40ad-a661-2c78acb4018c:8593684Microsoft Dynamics NAV Sustained Engineering Team Blog<p>Please refer to this post about what I mean with &amp;quot;modern troubleshooting&amp;quot;. This post describes</p>