May 6, 2014 at 4:43 am
Dear All,
I have Created a maintenance plan for Rebuild Index on my database.
But after executing that Task it is throwing a message like following...
Failed:(-1073548784) Executing the query "ALTER INDEX [IX_PersonPhone_PhoneNumber] ON [Perso..."
failed with the following error: "Could not proceed with index DDL operation on table 'PersonPhone'
because it conflicts with another concurrent operation that is already in progress on the object.
The concurrent operation could be an online index operation on the same object or another concurrent
operation that moves index pages like DBCC SHRINKFILE.".
Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Pls Help me out..
Regards...
Regards
Chowdary...
May 6, 2014 at 5:10 am
It clearly mention about running multiple task like reindexing or shrinkfile. Try to find what exactly was running at that time for further investigation.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2014 at 5:26 am
Thank you for giving Reply me sir,
As i am very new to this Rebuild and reorganize Tasks.
Can you Please help me how to find "What Exactly Running at that time",
Here it is showing that "it conflicts with another concurrent operation that is already in progress on the object"
how to find the Concurrent Operation which are running and how can i manage this type of issues.
Regards...
Regards
Chowdary...
May 6, 2014 at 7:17 am
It sounds like you have to processes trying to do the same thing. You can't rebuild multiple indexes simultaneously on the same table.
To see other processes as they're running use sys.dm_exec_requests. You can combine this with sys.dm_exec_sql_text to see the commands. There are other dynamic management views you might want to combine in there for additional information. For a resource, see the free e-book by Tim Ford and Louis Davidson.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply