Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogdatabase optimizationdatabase optimization
Previous
 
Next
New Post
3/19/2012 5:28 PM
 

We have a SQL Server management task that runs on Sundays failing with Blog 04.01.01 and DNN 6.1.4
Executing the query "ALTER INDEX [IX_Blog_Entry_Tags_EntryID] ON [dbo]...."
failed with the following error: "The index "IX_Blog_Entry_Tags_EntryID"
(partition 1) on table "Blog_Entry_Tags" 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.

Here is what we did to fix the index reorganization issue:

ALTER INDEX [IX_Blog_Categories_PortalID] ON Blog_Categories
SET (
ALLOW_PAGE_LOCKS = ON
)
GO

ALTER INDEX [IX_Blog_Entry_Categories_CatID] ON Blog_Entry_Categories
SET (
ALLOW_PAGE_LOCKS = ON
)
GO

ALTER INDEX [IX_Blog_Entry_Categories_EntryID] ON Blog_Entry_Categories
SET (
ALLOW_PAGE_LOCKS = ON
)
GO

ALTER INDEX [IX_Blog_Entry_Tags_EntryID] ON Blog_Entry_Tags
SET (
ALLOW_PAGE_LOCKS = ON
)
GO

ALTER INDEX [IX_Blog_Entry_Tags_TagID] ON Blog_Entry_Tags
SET (
ALLOW_PAGE_LOCKS = ON
)
GO

ALTER INDEX [IX_Blog_Tags_PortalID] ON Blog_Tags
SET (
ALLOW_PAGE_LOCKS = ON
)
GO

ALTER INDEX [IX_Blog_Tags_PortalID] ON Blog_Tags
SET (
ALLOW_PAGE_LOCKS = ON
)
GO

The module is not in use yet I will post back if there are any problems.
Regards, Fred

 
New Post
3/20/2012 5:55 AM
 
please note, the default value for ALLOW_PAGE_LOCKS is ON - in general I dont recommend turning them off as it can cause issues (i.e. failure to reorganise indexes - meaning you have to do a rebuild rather than a reorganisation). Typically this value is switched off as locks are escalating from row level to page or table level - however this is not a bug, but rather usually indicates a badly designed OLTP system e.g. one which updates large numbers of records or/and indexed columns at one time (one instance I saw was where someone had used a timestamp column that updated on each row as part of an index and was updating the table records based on a broad value, updating thousands of rows in a single operation)

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
3/30/2012 5:05 AM
 

This is logged as a bug here. Please vote for it to increase its chances of being fixed.

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogdatabase optimizationdatabase optimization


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out