Sample Header Ad - 728x90

How can I monitor a production database to see if there are table scans happening?

3 votes
1 answer
188 views
How can I monitor a production database to see if there are table scans happening? And what indexes might fix them... I'm told that we have adequate indexes but I can't see every code path, and we have too many people touching the codebase (hey, lots of developers can sometimes be a good thing) so what's the most comprehensive way to see how if we've missed indexes based on our production load? SQL Server 2008 R2, C#/ASP.NET code, NHibernate are the key factors in use.
Asked by jcolebrand (6376 rep)
Sep 12, 2013, 07:44 PM
Last activity: Sep 12, 2013, 09:20 PM