1 Reply Latest reply on Feb 1, 2010 10:02 AM by MarieB

    NTA 3.6 Upgrade

    JTL

      We have a rather large NTA roll out (about 1590 flows per NPM) and upgraded to 3.6 yesterday morning with NPM 9.5.1.  The upgrade went rather well but we did run into one problem with NTA.  Originally with NTA 3.5 we worked very close with SW because we were running into problems with our Netflow information not displaying on the web.  Turns out we were getting up to 50+ dbo's per node in our database which was causing locking conditions and other problems in the DB.  Old dbo's weren't getting cleaned up and that just hosed everything up.   Long story short we worked with SW and they gave us this query (below).  We needed to run this query on the DB after our upgrade to 3.6 NTA because the dbo's were around 30+ per node id (and growing) in the database. Even thought NTA was saying netflow data was being received we weren't able to see it via the web or in the database.

      If you happen to run into this problem you might want to try the following.  Shut down all services within NPM.  log into the database and run the following SQL. This will delete those dbo's.  This SQL ran for about 20 minutes on 2 of our NPM that each have about 1500+ flows reporting to them.  After the SQL is completed restart the services.  Hopefully that will correct the problem it did ours.  We have now been running about 18 hours on 3.6 and things seem to be stable.

       

      DECLARE @script nvarchar(max), @doBreak int
      SELECT @script = '', @doBreak = 0

      WHILE (@doBreak<>1)
      BEGIN
      SELECT TOP 1000 @script = @script + (CASE TABLE_TYPE WHEN 'BASE TABLE' THEN ' DROP TABLE ' WHEN 'VIEW' THEN ' DROP VIEW ' END) + TABLE_NAME + ' '
      FROM INFORMATION_SCHEMA.TABLES WITH(NOLOCK) WHERE TABLE_NAME LIKE 'NetFlowDetail[_][0-9]%'
      EXEC sp_executesql @script

      SELECT @doBreak = (CASE WHEN LEN(@script)>0 THEN 0 ELSE 1 END)
      SELECT @script = ''
      END

       

      Hope this works for you as well

          

          

        • Re: NTA 3.6 Upgrade

          Hi JTL--

          Thanks for posting this for the benefit of the community.

          Community, please be advised that the SQL solution that JTL showed is specific for his configuration and was given to him by SW support. It may not work for your configuration and could cause data loss. If you are having a similar issue and are on active maintenance, we highly recommend that you contact support here.

          Complete the form. You will not be able to upload your Orion diagnostics, but you will receive an email back that allows you to upload diagnostics.

          Thx,

          M