Home Dashboard Directory Help
Search

Query hangs with clustered column store indexes by Tom Lucas - 0411


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 803984
Opened: 9/30/2013 1:40:36 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

After switching to use clustered column store indexes on my fact tables, a query is now hanging. I am swtching over to clustered column store because it helps many other queries in the workload. These two queries are exceptions which are now slower. Previously, they would return within a few seconds. Now they both hang for over an hour after switching over to use clustered column store indexes.
Details
Sign in to post a comment.
Posted by Microsoft on 4/21/2014 at 11:12 AM
Tom,

I am closing this for now. Please feel free to re-activate if you hit the issue. Suggest you try the repro with SQL Server 2014

thanks
Sunil
Posted by Microsoft on 4/1/2014 at 5:56 PM
Tom, now that SQL Serljver 2014 has been released, I would like to request you to see if you can repro the scenario with the latest bits. If yes, please send us the repro and we will look into it. If I don;t hear from you in next 30 days, I will close the defect but feel free to re-activate it after that

thanks
Sunil
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
Query hang new ce #4.sql 9/30/2013 3 KB
query hang new ce #3.sql 9/30/2013 10 KB