Wednesday, February 27, 2013

find information on missing indexes

hi,

i use the below DMV to find where i need to add indexes to get performance gain..
Please consult DBA or any senior person before creating any indexes , too many indexes take more space and inserts, updates, deletes take more time and may lead to poor performance 

SELECT * FROM sys.dm_db_missing_index_details

find the Database name and object name
SELECT DB_NAME(11)
SELECT OBJECT_NAME(58483287)

Thanks

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...