Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Daily Maintenance Plan - Reorganize Index Task

I am looking for some advice on our Daily Maintenance Plan.

The task is failing every day with the same error message 'Executing the query "ALTER INDEX [CI_HostName] ON [dbo].[OrionServers] ..." failed with the following error: "The index "CI_HostName" (partition 1) on table "OrionServers" cannot be reorganized because page level locking is disabled.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.'

I have looked into this and it would appear the table OrionServers has a clustered index called CI_HostName this index does not have the 'Use page locks when accessing the index'. I believe changing this setting would remove the error above but would like to confirm it is OK to do this?

Please advise

Regards

Daniel

Find more posts tagged with

sql index

Accepted answers

All comments

There are no accepted answers yet