Carl, Thanks for the links. I had seen them awhile ago so it was good to review them. I didn't see anything regarding the name field being indexed though. I'm hoping to hear from someone with a similar environment, without an index on the name field, that can say searching is fantastic. Or to give an explanation as to why searching by name might be the wrong thing for my users to be doing (after all, wouldn't BMC have included an index on that field if it was meant to be a common search criteria?)
On a side note... In 8.1, they moved a lot of attributes out of the CMDB and into Asset Management (on the AST:Attributes form). One of them was the "Floor" attribute. Oddly, they didn't move the "Room" attribute or the other location info. That seems strange as well. Thanks again, Thad On Thu, Apr 18, 2013 at 2:36 AM, Carl Wilson <[email protected]> wrote: > ** > > 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+CMDB+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_ **** > _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"
