2 Replies Latest reply on Oct 2, 2009 12:06 PM by slbrodbeck

    NetPerfMon_log.LDF grows too big and too quick

    tao_lao

      Hi all,

      We are currrently running to an issue that  NetPerfMon_log.LDF grows 150G in a couple of hours. That causes the system out of disk space.

      Could someone help please?

      I have run database maintenance/netflowdatabasemaintenace thousand times.
      I have turn off DNS resolving feature.
      I have run re-configuration thousand times.

        • Re: NetPerfMon_log.LDF grows too big and too quick
          bshopp

          Please open a support case on this item.

          • Re: NetPerfMon_log.LDF grows too big and too quick

            Without some more information it will be hard to help identify what the problem exactly is. Questions like how many nodes do you monitor? Do you have the netflow module installed? If you do how many flows/devices do you monitor?

            Our small implementation with 1400 monitored elements can easily generate 100GB+ LDF file in day. This while our main MDF file never goes past 20GB. We do know exactly though why it happens. We have the Netflow module running and capture all that data.

            To combat the ever increasing LDF file, every morning at 6am we run backup on the database. Only on Monday do we do a full backup, otherwise it is an incremental.

            We have to do this because this is a generic SQL server limitation (not specifically a Microsoft SQL Server issue). All SQL databases normally log everything. Even if transactions are committed, they still exist in the log usually until a backup is done. Our production servers for in house developed applications create so many transactions that the logs have to be rolled when full which is normally between every 30 minutes to an 2 hours