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
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