Most RecentMost ViewedMost LikesNot every extended event is suited for all situationsFirst published on MSDN on Feb 24, 2016 SQL Server Extended Events (xevent) are great to troubleshoot many issues including performance issues or other targeted scenarios.Query performance and plan cache issues when parameter length not specified correctlyFirst published on MSDN on Oct 05, 2010 We recently worked with a customer who reported his update to a linked server table runs very slow.Case of using filtered statisticsFirst published on MSDN on Sep 28, 2010 Technorati Tags: PerformanceSQL Server 2008 introduces a new feature called filtered statistics.
