Re: CMDB 8.1 Index on Name Field
Okay, thanks everyone. I went ahead and added the index. Thad On Tue, Apr 23, 2013 at 2:53 PM, Jason Miller wrote: > ** > I am pretty sure I have seen an answer from a BMC person (Doug maybe?) > why the Name field isn't indexed out of the box. If I remember correctly > it was something along the line that they are leaving it up to us to > decided if we need indexing or not. Each organization may have different > indexing needs based on how the CMDB is used and the attributes an > organization chooses to use. > > Jason > > > On Tue, Apr 23, 2013 at 11:32 AM, itsm.support > wrote: > >> ** >> >> Hi, >> >> There is nothing mention about indexing in CMDB 8.1 to improve >> performance. >> >> We can add index for better performance as per doc provided by BMC. >> >> - >> Indexing classes can reduce database query time. >> >> >> >> Index attributes that: >> *You expect users to query frequently. >> *Are used by discovery applications to identify CIs. >> *Are used in reconciliation identification rules. >> >> ** ** >> >> For more information about identification rules, see the BMC Atrium CMDB >> 8.1 Normalization and Reconciliation Guide. >> >> >> If you create an index for a Character attribute, you can save query time >> by setting the QBE Match characteristic of that field to Leading or Equal >> instead of Anywhere. >> >> >> Use the Indexes section on the General tab of the CI Class and >> Relationship Class dialog boxes to specify the indexes for a class. You can >> specify indexes on noninherited attributes only. If an attribute is >> inherited form a superclass, you must specify the index for that attribute >> on the superclass. Display-only attributes cannot be indexed, because no >> values are stored for them. >> >> >> >> To combine multiple attributes into a composite index, specify as many as >> 16 attributes per composite index. The sum of all attribute lengths in a >> single index must be fewer than or equal to 255 bytes, so Diary attributes >> and Character attributes larger than 255 bytes cannot be indexed >> >> ** ** >> >> -- >> >> Regards, >> >> Pawan >> >> >> >> Vyom Labs Pvt. Ltd. >> >> BSM Solutions & Services || ITIL Consulting & Training >> >> Email: [hidden >> email]<http://ars-action-request-system.1093659.n2.nabble.com/user/SendEmail.jtp?type=node&node=7583733&i=0> >> || Web Site: www.vyomlabs.com Follow Vyom Labs >> http://twitter.com/#!/vyomlabs || >> http://www.linkedin.com/company/vyom-labs >> >> ** ** >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Thad Esser >> *Sent:* Thursday, April 18, 2013 7:03 AM >> >> *To:* arslist@ARSLIST.ORG >> *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_ >> > > _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"
Re: CMDB 8.1 Index on Name Field
I am pretty sure I have seen an answer from a BMC person (Doug maybe?) why the Name field isn't indexed out of the box. If I remember correctly it was something along the line that they are leaving it up to us to decided if we need indexing or not. Each organization may have different indexing needs based on how the CMDB is used and the attributes an organization chooses to use. Jason On Tue, Apr 23, 2013 at 11:32 AM, itsm.support wrote: > ** > > Hi, > > There is nothing mention about indexing in CMDB 8.1 to improve performance. > > We can add index for better performance as per doc provided by BMC. > > - > Indexing classes can reduce database query time. > > > > Index attributes that: > *You expect users to query frequently. > *Are used by discovery applications to identify CIs. > *Are used in reconciliation identification rules. > > ** ** > > For more information about identification rules, see the BMC Atrium CMDB > 8.1 Normalization and Reconciliation Guide. > > > If you create an index for a Character attribute, you can save query time > by setting the QBE Match characteristic of that field to Leading or Equal > instead of Anywhere. > > > Use the Indexes section on the General tab of the CI Class and > Relationship Class dialog boxes to specify the indexes for a class. You can > specify indexes on noninherited attributes only. If an attribute is > inherited form a superclass, you must specify the index for that attribute > on the superclass. Display-only attributes cannot be indexed, because no > values are stored for them. > > > > To combine multiple attributes into a composite index, specify as many as > 16 attributes per composite index. The sum of all attribute lengths in a > single index must be fewer than or equal to 255 bytes, so Diary attributes > and Character attributes larger than 255 bytes cannot be indexed > > ** ** > > -- > > Regards, > > Pawan > > > > Vyom Labs Pvt. Ltd. > > BSM Solutions & Services || ITIL Consulting & Training > > Email: [hidden > email]<http://ars-action-request-system.1093659.n2.nabble.com/user/SendEmail.jtp?type=node&node=7583733&i=0> > || Web Site: www.vyomlabs.com Follow Vyom Labs > http://twitter.com/#!/vyomlabs || > http://www.linkedin.com/company/vyom-labs > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Thad Esser > *Sent:* Thursday, April 18, 2013 7:03 AM > > *To:* arslist@ARSLIST.ORG > *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"
Re: CMDB 8.1 Index on Name Field
Hi, There is nothing mention about indexing in CMDB 8.1 to improve performance. We can add index for better performance as per doc provided by BMC. - Indexing classes can reduce database query time. Index attributes that: *You expect users to query frequently. *Are used by discovery applications to identify CIs. *Are used in reconciliation identification rules. For more information about identification rules, see the BMC Atrium CMDB 8.1 Normalization and Reconciliation Guide. If you create an index for a Character attribute, you can save query time by setting the QBE Match characteristic of that field to Leading or Equal instead of Anywhere. Use the Indexes section on the General tab of the CI Class and Relationship Class dialog boxes to specify the indexes for a class. You can specify indexes on noninherited attributes only. If an attribute is inherited form a superclass, you must specify the index for that attribute on the superclass. Display-only attributes cannot be indexed, because no values are stored for them. To combine multiple attributes into a composite index, specify as many as 16 attributes per composite index. The sum of all attribute lengths in a single index must be fewer than or equal to 255 bytes, so Diary attributes and Character attributes larger than 255 bytes cannot be indexed -- Regards, Pawan Vyom Labs Pvt. Ltd. BSM Solutions & Services || ITIL Consulting & Training Email: <http://ars-action-request-system.1093659.n2.nabble.com/user/SendEmail.jtp?t ype=node&node=7583733&i=0> [hidden email] || Web Site: <http://www.vyomlabs.com> www.vyomlabs.com Follow Vyom Labs <http://twitter.com/#%21/vyomlabs> http://twitter.com/#!/vyomlabs || <http://www.linkedin.com/company/vyom-labs> http://www.linkedin.com/company/vyom-labs From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Thursday, April 18, 2013 7:03 AM To: arslist@ARSLIST.ORG 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"
Re: CMDB 8.1 Index on Name Field
Better treat everything from low level, start by one Class, ensure the legacy index in regular form, then upgrade to 8.1 and check the class-index in the new regular form or join. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Thursday, April 18, 2013 4:33 AM To: arslist@ARSLIST.ORG 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_ The information in this email may contain confidential material and it is intended solely for the addresses. Access to this email by anyone else is unauthorized. If you are not the intended recipient, please delete the email and destroy any copies of it, any disclosure, copying, distribution is prohibited and may be considered unlawful. Contents of this email and any attachments may be altered, Statement and opinions expressed in this email are those of the sender, and do not necessarily reflect those of Saudi Telecommunications Company (STC). ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: CMDB 8.1 Index on Name Field
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 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: > arslist@ARSLIST.ORG] *On Behalf Of *Thad Esser > *Sent:* 18 April 2013 02:33 > *To:* arslist@ARSLIST.ORG > *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"
Re: CMDB 8.1 Index on Name Field
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:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: 18 April 2013 02:33 To: arslist@ARSLIST.ORG 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"
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"