0 Replies Latest reply on Nov 18, 2009 2:30 PM by Andy McBride

    SQL Knowledge Base Entries

    Andy McBride

      Here is a list of KB's that can be helpful when working with SQL and SolarWinds products:

      How do I use a remote SQL Server as my database?

      http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=108

       

      Could not allocate new page for database 'Database_Name'

      http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=362

       

      Why is my database log file so large?

      http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=252

       

      Why does SQL Server use all the available memory on my Orion server?

      http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=342

       

      What ports need to be open to allow Orion NPM to communicate with the SQL Server? http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=379

       

      How do I enable CLR Integration for SQL Server 2005?

      http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=1153

       

      During an upgrade, I get the following error at the end of the Configuration Wizard:  Incorrect syntax near 'External'. You may need to set the compatibility level of the current database to a higher value to enable this feature.

      sp_dbcmptlevel

      http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=1154

       

      What does my DBA need to know about CLR Integration?

      http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=1159

       

      How do I connect Orion to a named instance of SQL Server 2005 on a non-standard port?

      http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=1100

       

      How do I improve the performance of my Orion NetFlow Traffic Analyzer (Orion NTA) installation?

      http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=1296

       

      Why has my performance started to degrade since I first installed NCM?

      http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=1109