Skip to main content
Database Administrators

Return to Question

improved formatting
Source Link
Musakkhir Sayyed
Musakkhir Sayyed
  • 490
  • 1
  • 5
  • 18

I am creating Clustered Column Store Index in SQL Server 2014. enter image description here

I am getting error as "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)".

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)".

I set

EXEC sp_configure 'remote query timeout', 60000;EXEC sp_configure 'remote query timeout', 60000; reconfigurereconfigure EXEC sp_configureEXEC sp_configure

Row Count = 304969603 Data space = 88,812.266 MB

I am creating Clustered Column Store Index in SQL Server 2014. enter image description here

I am getting error as "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)".

I set

EXEC sp_configure 'remote query timeout', 60000; reconfigure EXEC sp_configure

Row Count = 304969603 Data space = 88,812.266 MB

I am creating Clustered Column Store Index in SQL Server 2014. enter image description here

I am getting error as

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)".

I set

EXEC sp_configure 'remote query timeout', 60000; reconfigure EXEC sp_configure

Row Count = 304969603 Data space = 88,812.266 MB

edited tags
Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663
added 155 characters in body; edited title
Source Link
Musakkhir Sayyed
Musakkhir Sayyed
  • 490
  • 1
  • 5
  • 18

Create failed for Index 'ClusteredColumnStoreIndex'. Timeout expired.

I am creating Clustered Column Store Index in SQL Server 2014. enter image description here I

I am getting error as "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)".

I set

EXEC sp_configure 'remote query timeout', 60000; reconfigure EXEC sp_configure

Row Count = 304969603 Data space = 88,812.266 MB

Create failed for Index 'ClusteredColumnStoreIndex'. Timeout expired.

I am creating Clustered Column Store Index in SQL Server 2014. enter image description here I am getting error as "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)".

Create failed for Index 'ClusteredColumnStoreIndex'. Timeout expired

I am creating Clustered Column Store Index in SQL Server 2014. enter image description here

I am getting error as "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)".

I set

EXEC sp_configure 'remote query timeout', 60000; reconfigure EXEC sp_configure

Row Count = 304969603 Data space = 88,812.266 MB

Source Link
Musakkhir Sayyed
Musakkhir Sayyed
  • 490
  • 1
  • 5
  • 18