ALTER INDEX REBUILD Freezes

Question

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 399289 More actions · Answer 1

Are there waits associated with the process? It's likely that it's just taking a long time or that it's blocked.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Wait Types are mostly CXPACKET. Also getting SOS_SCHEDULER_YIELD.

There is definitely no blocking going on.

Thanks!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

One of the just worked. Started another and I'm getting a LOGBUFFER WAIT TYPE.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

It is moving very slowly on a 30 million record table.

Thanks. 🙂

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Grant Fritchey SSC Guru Points: 399289 More actions · Answer 5

With log buffer waits, it's hitting conflicts with other processes in and around the log. It might just be slow.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

Grant Fritchey (6/16/2014)
With log buffer waits, it's hitting conflicts with other processes in and around the log. It might just be slow.

Thanks for the insight.:-)

It's moving fast unlike this weekend and today.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/