Hi, The changes for the 8.x series to improve performance are listed here:
https://docs.bmc.com/docs/display/public/itsm81/Changes+to+the+BMC+Atrium+CM DB+for+BMC+Remedy+ITSM https://docs.bmc.com/docs/display/public/itsm80/Data+structure+change Not too sure on if this will be of help when searching on the Name field though. _____ Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Thad Esser Sent: 18 April 2013 02:33 To: [email protected] Subject: CMDB 8.1 Index on Name Field ** 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 _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
