1 2 Previous Next 10 Replies Latest reply on May 28, 2009 10:20 AM by DLarson

    Very slow database

      Hey All,

      I'm currently running MEE 5.1.6

      My admin console server is running on a vmware instance.

      Specs:
      W2K3SP2
      Dual 2.6GHz Dual-Core
      2Gb memory


      • Database consists of 1400 laptops and 1700 users.
      • Database has existed since 4.2b
      • sbhttp server is running on a different web server.



      Adding a new machine to the database can take anywhere from 1 minute to 5 minutes.
      Searching for a machine could take up to 5 minutes.
      Syncing a machine across the WAN takes 2-3 minutes.

      Can anyone offer any suggestions to speed up the database?
        • 1. Re: RE: Very slow database

          what storage are you using (DAS/NAS/SAN etc?) did you follow the steps in the performance tuning section of the admin guide (enable name cache etc?).

           

          there is a KB article in the knowledge base (mysupport.mcafee.com) detailing all the performance steps you can go through, but the name cache is the most significant.

           

          you might also want to move from virtual to physical hardware - that gives better performance typically - mainly because most VM's are using SAN TierII storage which is a LOT slower than DAS (or TierI).

           

           

          Message was edited by: Greg Sanders on 11/6/09 3:35 PM
          • 2. RE: Very slow database
            Name caching was previously enabled.

            I've asked our VMWare team to check settings.

            The VM storage is on a fibre connected NetApps SAN.
            • 3. RE: Very slow database
              Contents of dbcfg.ini


              [NameIndex]

              Enabled=Yes

              [Tracking]
              ObjectChanges=Yes

              SingleFile=No



              What is the Tracking section for? Do I need it? Could this be causing the database to be slow?
              • 4. RE: Very slow database
                you only need the tracking if you are using the database backup tool. Yes, it will slow things down.

                what tier is your SAN connection on? If they don't know then it won't be on high speed and moving to local storage will be faster.
                • 5. RE: Very slow database
                  I was told it was SATA

                  I will work toward migrating to a Physical server.

                  I have seen other threads on here regarding dbcfg and it's settings.. would any of those other options benefit me?

                  From post: http://community.mcafee.com/showthread.php?t=228608

                  [NameIndex]
                  Enabled=Yes
                  LockTimeout=3000
                  LockSleep=10
                  HashCount=100
                  MinEntrySize=16
                  LifeTime=86400

                  [Attribs]
                  SingleFile-No
                  AutoConvert=No


                  Thanks.
                  • 6. RE: Very slow database
                    not really - it sounds like you are just suffering from a really slow SAN. If the answer you got back is SATA that kind of indicates your SAN person does not appreciate what's going on here.

                    tell him you need tierI connection to a dedicated set of LUNs for your application - that may help him understand that this is not a trivial application. It needs some horsepower behind it.
                    • 7. RE: Very slow database
                      You should also check to see if you are running AV services on the server? I had bad problems with Symantec 8 (with services running) and horrible performance problems with Symantec 10 (even with SAV services stopped). Unless they fixed this in SEP 11, performance will always suck, even if you exclude the SBDATA folder. For McAfee AV, try just excluding the SBDATA folder from scans.
                      • 8. RE: Very slow database
                        Thanks,

                        We have McAfee and I asked our admins to exclude the SBDATA folder about a year ago and we saw an increase in performance.. I only have 1700 or so machines, I can't imagine how this runs with 5K or even 10K+ machines like I've read on these forums.
                        • 9. RE: Very slow database
                          Just for testing purposes, have AV disabled (or even temporarily removed). You could also have the AV team re-verify that the exclusion is still present. You may also want to have them exclude any DB backup/archive folders you have. You wouldn't want the AV service crawling 200,000+ files that it doesn't understand.
                          1 2 Previous Next