Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

index  - last use and update

Posted on 2016-08-17
8
Medium Priority
?
78 Views
Last Modified: 2016-08-22
Hi experts

Please, give me T-SQL
1. Get the last index update date (insert, update, delete)
2. Get the last date of use of the index

What I wish is to determine which indexes are not used to remove
0
Comment
Question by:enrique_aeo
  • 3
  • 2
8 Comments
 
LVL 13

Accepted Solution

by:
Máté Farkas earned 2000 total points
ID: 41760692
There is a built-in report in SQL Server Management Studio for this purpose:
Right click on your database >>> Report >>> Standard reports >>> Index Usage Statistics

In this report you can all the information you requested.

You can access these data with the following DMVs:
SELECT * FROM sys.dm_index_usage_stats
SELECT * FROM sys.dm_db_index_operational_stats (NULL, NULL, NULL, NULL)    

Open in new window

0
 

Author Comment

by:enrique_aeo
ID: 41761884
the day yesterday was reviewing the url that an expert put it, because they have erased? it could re-post?
0
 

Author Comment

by:enrique_aeo
ID: 41763976
The links provided were interesting, I need them.

I think if the expert does not put comments, should not eliminate, the expert should add any comments by the link.

Based on your experience, you definitely have the best articles I could find.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41764899
Another blind link comment deleted.
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41764901
Enrique, the links provided refers to the two DMV in Máté's comment.
I guess you know how to use a search engine to get more information about those DMV :)
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question