Tag: usage stats

Development, Przydatne skrypty, SQL Server

sys.dm_db_index_usage_stats

Z dokumentacji technet ( http://msdn.microsoft.com/en-us/library/ms188755%28v=sql.105%29.aspx ) „Every individual seek, scan, lookup, or update on the specified index by one query execution is counted as a use of that index and increments the corresponding counter in this view. Information is reported both for operations caused by user-submitted queries, and for operations causedCzytaj dalej / Read more