Hello, Does anyone have a loaded 8.1 CMDB that can advise me on an indexing question? Our current production CMDB is 2.1 and we are moving to 8.1. In 2.1, I had to add an index on the Name field on base element to make searches tolerable for users. I see that 8.1 does not have an index on the name field either, and figure I'm going to have to add it. We haven't loaded all of our CIs yet, so I can't test that aspect myself.
Before I add the index, I wanted to make sure I'm not missing some new feature or something else that BMC might have done to improve performance when searching by CI name. Have you indexed the Name field, and if not, how's performance when searching by name (and how many rows/CIs do you have)? We have about 750,000 CIs. The database is SQL Server and the AR Servers are Windows. The full ITSM suite is installed. Thanks, Thad _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
