cancel
Showing results for 
Search instead for 
Did you mean: 

Defrag and Indexing of ePO Database (ePO 4.6)

Jump to solution

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 Solution

Accepted Solutions
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 24 of 27

Re: Defrag and Indexing of ePO Database (ePO 4.6)

Jump to solution

Okay, that's looking better. The errors now are down to the work queue indexes no longer having page locking enabled - see KB73170 which I mentioned in another thread for more details.

The RebuildReorganizeIndexes-V2.sql script that you mention is actually a preferable script to run - the previous script is SQL2000 syntax, and some of the commands like INDEXDEFRAG will be retired in future SQL versions. (Plus this script already handles databases with multiple schemas.) I'll get the old article retired as it's pretty much obsolete now.

I'm attaching a revised version of the RebuildReorganizeIndexes-V2.sql script, which skips indexes where page locking is disabled. Try this one when you get a moment - it should be able to complete without errors. Let me know how you get on

Regards -

Joe

26 Replies
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 27

Re: Defrag and Indexing of ePO Database (ePO 4.6)

Jump to solution

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

Thanks -

Joe

Re: Defrag and Indexing of ePO Database (ePO 4.6)

Jump to solution

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.

Re: Defrag and Indexing of ePO Database (ePO 4.6)

Jump to solution

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.

McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 5 of 27

Re: Defrag and Indexing of ePO Database (ePO 4.6)

Jump to solution

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

Re: Defrag and Indexing of ePO Database (ePO 4.6)

Jump to solution

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.


Re: Defrag and Indexing of ePO Database (ePO 4.6)

Jump to solution

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.

Re: Defrag and Indexing of ePO Database (ePO 4.6)

Jump to solution

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.


McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 9 of 27

Re: Defrag and Indexing of ePO Database (ePO 4.6)

Jump to solution

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

Re: Defrag and Indexing of ePO Database (ePO 4.6)

Jump to solution

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