Skip to main content
Database Administrators

Return to Question

Incorporated comments
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663

I am trying to optimize the database by creating missing indexes, but the dm_db_missing_index_details table does not have any data.

I have the same database on different server and there are many records in that table. So it looks there may be a configuration problem causing the missing index requests to not be saved.

Why are there missing index requests on one server, but there aren't any on the other server (for the same database)?

We have not restarted the database server for the last four days. I am sure there should be index issues, because the same db is running at a different location and that one has many missing index warnings (and we fixed those).

I am trying to optimize the database by creating missing indexes, but the dm_db_missing_index_details table does not have any data.

I have the same database on different server and there are many records in that table. So it looks there may be a configuration problem causing the missing index requests to not be saved.

Why are there missing index requests on one server, but there aren't any on the other server (for the same database)?

I am trying to optimize the database by creating missing indexes, but the dm_db_missing_index_details table does not have any data.

I have the same database on different server and there are many records in that table. So it looks there may be a configuration problem causing the missing index requests to not be saved.

Why are there missing index requests on one server, but there aren't any on the other server (for the same database)?

We have not restarted the database server for the last four days. I am sure there should be index issues, because the same db is running at a different location and that one has many missing index warnings (and we fixed those).

added 120 characters in body
Source Link
Josh Darnell
Josh Darnell
  • 29.8k
  • 5
  • 67
  • 124

No missing index requests on SQL Server 2012 Missing Index

I am trying to optimize the database by creating missing indexes, but dm_db_missing_index_detailsthe dm_db_missing_index_details table havedoes not have any data. 

I am havinghave the same data basedatabase on different server and there are many records in that table.. soSo it looks thatthere may be there is anya configuration missing that's whyproblem causing the missing indexes areindex requests to not savingbe saved.

ThanksWhy are there missing index requests on one server, but there aren't any on the other server (for the same database)?

SQL Server 2012 Missing Index

I am trying to optimize the database by creating missing indexes, but dm_db_missing_index_details table have not any data. I am having same data base on different server and there are many records in that table.. so it looks that may be there is any configuration missing that's why missing indexes are not saving.

Thanks

No missing index requests on SQL Server 2012

I am trying to optimize the database by creating missing indexes, but the dm_db_missing_index_details table does not have any data. 

I have the same database on different server and there are many records in that table. So it looks there may be a configuration problem causing the missing index requests to not be saved.

Why are there missing index requests on one server, but there aren't any on the other server (for the same database)?

Bumped by Community user
Source Link
Atul Yadav
Atul Yadav
  • 119
  • 2

SQL Server 2012 Missing Index

I am trying to optimize the database by creating missing indexes, but dm_db_missing_index_details table have not any data. I am having same data base on different server and there are many records in that table.. so it looks that may be there is any configuration missing that's why missing indexes are not saving.

Thanks