1 2 3 Previous Next 26 Replies Latest reply on Oct 24, 2011 3:41 AM by JoeBidgood

    Defrag and Indexing of ePO Database (ePO 4.6)

    Brendon Elliott

      Referring to the subject line and attached pdf,

       

      Does anyone know where to find a new (updated) procedure for ePO 4.6 DB on SQL 2008

       

      Message was edited by: BlackDiamond on 2011/09/29 9:41:55 AM
        • 1. Re: Defrag and Indexing of ePO Database (ePO 4.6)
          JoeBidgood

          As far as I know this process is still applicable - is there a problem with it?

           

          Thanks -

           

          Joe

          • 2. Re: Defrag and Indexing of ePO Database (ePO 4.6)
            Brendon Elliott

            Hi Joe,

             

            This seems not to work on 4.6 DB, when I modify to point to 4.6 DB and execute, I receive the following

             

            Msg 2812, Level 16, State 62, Line 1

            Could not find stored procedure 'ePO4_<DBNAME>'.

             

            This seems to work on 4.5 DB, when I modify to point to 4.5 DB and execute, I receive the following

             

            Command(s) completed successfully.

            • 3. Re: Defrag and Indexing of ePO Database (ePO 4.6)
              Brendon Elliott

              However,

               

              On the 4.5 DB, i just started the job and got the following error

               

              Date                    2011/09/29 11:04:00

              Log                    Job History (Defrag and Indexing of ePO Database (<DB_NAME>))

               

               

              Step ID                    1

              Server                    <SERVER_NAME>

              Job Name                    Defrag and Indexing of ePO Database (<DB_NAME>)

              Step Name                    Defrag&Index ePODatabase

              Duration                    00:00:01

              Sql Severity                    16

              Sql Message ID                    2501

              Operator Emailed

              Operator Net sent

              Operator Paged

              Retries Attempted                    0

               

               

              Message

              Executed as user: NT AUTHORITY\SYSTEM. Cannot find a table or object with the name "ApplicableRuleState". Check the system catalog. [SQLSTATE 42S02] (Error 2501).  The step failed.

              • 4. Re: Defrag and Indexing of ePO Database (ePO 4.6)
                JoeBidgood

                It certainly appears to work OK here. The errors would seem to indicate a syntax problem in the scheduled job... what happens if you manually run the script against a DB via Management Studio?

                 

                Thanks -

                 

                Joe

                • 5. Re: Defrag and Indexing of ePO Database (ePO 4.6)
                  Brendon Elliott

                  Hi Joe,

                   

                  Sorry for the delay, i am back on site and just recreated the jobs, these are the fingings,

                   

                  For ePO 4.5.0 Database:

                   

                  Date                    2011/10/06 07:49:28

                  Log                    Job History (Defragment Indexes for ePO Database (DB_NAME))

                   

                   

                  Step ID                    1

                  Server                    PINFOSECSQL1

                  Job Name                    Defragment Indexes for ePO Database (DB_NAME)

                  Step Name                    Defragment Indexes for ePO Database (DB_NAME)

                  Duration                    00:00:02

                  Sql Severity                    16

                  Sql Message ID                    2501

                  Operator Emailed

                  Operator Net sent

                  Operator Paged

                  Retries Attempted                    0

                   

                   

                  Message

                  Executed as user: NT AUTHORITY\SYSTEM. Cannot find a table or object with the name "ApplicableRuleState". Check the system catalog. [SQLSTATE 42S02] (Error 2501).  The step failed

                   

                  For ePO 4.6.0 Database:

                   

                  Date                    2011/10/06 07:52:35

                  Log                    Job History (Defragment Indexes for ePO Database (DB_NAME))

                   

                   

                  Step ID                    1

                  Server                    PINFOSECSQL1

                  Job Name                    Defragment Indexes for ePO Database (DB_NAME)

                  Step Name                    Defragment Indexes for ePO Database (DB_NAME)

                  Duration                    00:00:03

                  Sql Severity                    16

                  Sql Message ID                    2501

                  Operator Emailed

                  Operator Net sent

                  Operator Paged

                  Retries Attempted                    0

                   

                   

                  Message

                  Executed as user: NT AUTHORITY\SYSTEM. Cannot find a table or object with the name "ThreatSoftwareOperatingSystem". Check the system catalog. [SQLSTATE 42S02] (Error 2501).  The step failed.


                  • 6. Re: Defrag and Indexing of ePO Database (ePO 4.6)
                    Brendon Elliott

                    For ePO 4.5.0 Batabase:

                     

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ApplicableRuleState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "SummaryState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ReportingGroup". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatRelationship". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "OverallCoverageState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ReportingGroupRules". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Disclosure". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "OverallPatchPriorityState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ReportingGroupAttribute". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Exploit". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ReportingGroupAttributeMap". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "OverallCoverageStateMap". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ComplianceSection". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ReportingGroupResult". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ComplianceDocument". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ComplianceTechnology". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ReportingGroupResultValue". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatComplianceTechnology". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ErrorLog". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatComplianceTechnologyDocument". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ErrorLogData". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ProductAttributeHash". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ErrorMessage". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ProductAttributeValue". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatComplianceDocumentSection". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "DataSource". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ProductAttributeValueMap". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Property". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "MitigationType". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "AssetCountermeasure". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "MitigationClass". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Product". Check the system catalog.

                     

                    For ePO 4.6.0 Database

                     

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatSoftwareOperatingSystem". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "AssetReconTemp". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatMitigationHashDescriptor". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatDictionaryReference". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatMitigationAnalyzedCoverageStatus". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "MitigationProductDescriptorVersion". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Categories". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "AttackVector". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Locale". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Attack". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "MitigationProductDescriptorVersionAttribute". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "AttackResult". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "DocumentationLocale". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Policy". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "CVSSOwner". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Result_Set". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "CVSS". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Sensor". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "UserRead". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatAssetCoverageAggregateByThreat". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Sensor_Port". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Category". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Vids". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatAssetCoverageAggregateByAsset". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Port". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Criticality". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Vids_Nid". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatTag". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Asset". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatAttackVector". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Network_Link". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Host_Event". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatTagMap". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "CountermeasureState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatAttackResult". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Filtered_Attack_List". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Alert". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "VulnerabilityState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "QueueGeneric". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Response". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "RiskCategoryType". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatCategory". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ApplicableState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "RiskCategory". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Iv_Envpref". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "CountermeasureRuleState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "RiskScoreAttributeMap". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatPort". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "AlertAsset". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "EnterpriseRiskScore". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "VidAsset". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "NSMAsset". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "RiskScoreAggregateByThreat". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "VulnerabilityRuleState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatSoftware". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "RiskScoreAggregateByAsset". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ApplicableRuleState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "SummaryState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ReportingGroup". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatRelationship". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "OverallCoverageState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ReportingGroupRules". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Disclosure". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "OverallPatchPriorityState". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ReportingGroupAttribute". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "Exploit". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ReportingGroupAttributeMap". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "OverallCoverageStateMap". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ComplianceSection". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ReportingGroupResult". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ComplianceDocument". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ComplianceTechnology". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ReportingGroupResultValue". Check the system catalog.

                    Msg 2501, Level 16, State 45, Line 1

                    Cannot find a table or object with the name "ThreatComplianceTechnology". Check the system catalog.

                    • 7. Re: Defrag and Indexing of ePO Database (ePO 4.6)
                      Brendon Elliott

                      For ePO 4.5.0

                      Job execution Complete: Completed with errors

                       

                      Executing DBCC INDEXDEFRAG (0, EPOBranchNode,

                      1) - fragmentation currently 75%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, RSDDetectedSource,

                      2) - fragmentation currently 96%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOBranchNodeEnum,

                      1) - fragmentation currently 75%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOBranchNodeEnum,

                      2) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOBranchNodeEnum,

                      3) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOBranchNodeEnum,

                      4) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionAuditLog,

                      1) - fragmentation currently 42%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionAuditLog,

                      2) - fragmentation currently 85%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionAuditLog,

                      3) - fragmentation currently 98%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionAuditLog,

                      4) - fragmentation currently 80%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, RSDSubnetProperties,

                      1) - fragmentation currently 83%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, RSDSubnetProperties,

                      6) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, RSDSubnetProperties,

                      7) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, RSDSubnetProperties,

                      8) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyAssignment,

                      1) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, HIP7_LongTextXlate,

                      1) - fragmentation currently 67%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOComplianceHistoryProperties,

                      1) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOComplianceHistoryProperties,

                      2) - fragmentation currently 92%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOComplianceHistoryProperties,

                      3) - fragmentation currently 85%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOComplianceHistoryProperties,

                      4) - fragmentation currently 67%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOComplianceHistoryProperties,

                      6) - fragmentation currently 92%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, RSDInterfaceProperties,

                      1) - fragmentation currently 64%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, RSDInterfaceProperties,

                      2) - fragmentation currently 96%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, RSDInterfaceProperties,

                      3) - fragmentation currently 94%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, RSDInterfaceProperties,

                      4) - fragmentation currently 98%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, HIP7_ShortTextXlate,

                      1) - fragmentation currently 79%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, HIP7_SigNameXlate,

                      1) - fragmentation currently 71%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOSoftware,

                      1) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionQuery,

                      2) - fragmentation currently 71%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionQuery,

                      4) - fragmentation currently 89%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      3) - fragmentation currently 99%

                      DBCC: Compaction phase of index 'IX_EPOEvents_AutoGUID' is 54% complete.

                      DBCC: Defrag phase of index 'IX_EPOEvents_AutoGUID' is 58% complete.

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      4) - fragmentation currently 36%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      5) - fragmentation currently 48%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      6) - fragmentation currently 53%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      7) - fragmentation currently 58%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      8) - fragmentation currently 43%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      9) - fragmentation currently 53%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      10) - fragmentation currently 38%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      11) - fragmentation currently 34%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      12) - fragmentation currently 32%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      21) - fragmentation currently 92%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      22) - fragmentation currently 91%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      23) - fragmentation currently 94%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      24) - fragmentation currently 98%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      25) - fragmentation currently 95%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      26) - fragmentation currently 97%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      27) - fragmentation currently 35%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEvents,

                      28) - fragmentation currently 93%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, HIP7_Signature,

                      1) - fragmentation currently 57%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPORepository,

                      1) - fragmentation currently 67%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPORepositoryLogMessage,

                      1) - fragmentation currently 31%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOTask,

                      1) - fragmentation currently 86%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOTaskSettings,

                      1) - fragmentation currently 85%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, SAEEvent,

                      1) - fragmentation currently 76%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, SAEEvent,

                      2) - fragmentation currently 73%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPODirSortRules,

                      1) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyLocaleXlate,

                      1) - fragmentation currently 70%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyLocaleXlate,

                      2) - fragmentation currently 57%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyLocaleXlate,

                      3) - fragmentation currently 81%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyLocaleXlate,

                      4) - fragmentation currently 94%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyObjectToSettings,

                      1) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyObjectUserRoles,

                      1) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyObjects,

                      1) - fragmentation currently 83%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyObjects,

                      3) - fragmentation currently 92%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyObjects,

                      5) - fragmentation currently 67%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyObjects,

                      6) - fragmentation currently 83%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyObjects,

                      7) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, RSDSensorProperties,

                      1) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEventFilterDesc,

                      1) - fragmentation currently 63%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEventFilterDesc,

                      2) - fragmentation currently 41%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOEventFilterDesc,

                      3) - fragmentation currently 94%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicySettingValues,

                      2) - fragmentation currently 68%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicySettingValues,

                      3) - fragmentation currently 45%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicySettingValues,

                      4) - fragmentation currently 100%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicySettingValues,

                      5) - fragmentation currently 95%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicySettingValues,

                      6) - fragmentation currently 43%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicySettings,

                      1) - fragmentation currently 48%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicySettings,

                      2) - fragmentation currently 80%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicySettings,

                      3) - fragmentation currently 90%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicySettings,

                      4) - fragmentation currently 53%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicySettings,

                      5) - fragmentation currently 67%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOPolicyTypes,

                      2) - fragmentation currently 50%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionSchedulerTaskLog,

                      1) - fragmentation currently 38%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionSchedulerTaskLog,

                      2) - fragmentation currently 58%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionSchedulerTaskLog,

                      3) - fragmentation currently 98%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionSchedulerTaskLog,

                      4) - fragmentation currently 56%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionSchedulerTaskLog,

                      5) - fragmentation currently 59%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionSchedulerTaskLog,

                      6) - fragmentation currently 74%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionSchedulerTaskLog,

                      7) - fragmentation currently 72%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionSchedulerTaskLog,

                      8) - fragmentation currently 75%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionSchedulerTaskLogDetail,

                      1) - fragmentation currently 73%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, OrionSchedulerTaskLogDetail,

                      3) - fragmentation currently 87%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOLeafNodeUser_TreeAssignmentIDs,

                      1) - fragmentation currently 89%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, EPOLeafNodeUser_TreeAssignments,

                      1) - fragmentation currently 88%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, RSDDetectedSystemProperties,

                      1) - fragmentation currently 84%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

                      Executing DBCC INDEXDEFRAG (0, RSDDetectedSystemProperties,

                      2) - fragmentation currently 80%

                      DBCC execution completed. If DBCC printed error messages, contact your system administrator.


                      • 8. Re: Defrag and Indexing of ePO Database (ePO 4.6)
                        JoeBidgood

                        Hi...  I was asking what happens if you manually run the script against the DB, as opposed to recreating the job? Are any errors produced?

                         

                        Thanks -

                         

                        Joe

                        • 9. Re: Defrag and Indexing of ePO Database (ePO 4.6)
                          DarrenFord

                          Hey Bud, we used that process recently and it went through

                          1 2 3 Previous Next