Sp_BlitzIndex - A transport-level error has occurred when receiving results from the server
0
votes
0
answers
70
views
I am running v8.13 - February 15, 2023 of the Brent Ozar sp_BlitzIndex function against SQL Server 2017 Web Edition.
Whenever I run on a specific database as below , I get the "A transport-level...." type error after about a minute.
EXEC master.dbo.sp_BlitzIndex @DatabaseName='XXXX', @SchemaName='dbo', @TableName='yyyyy';
If I run the same with a different DatabaseName, but the same table, it runs OK. We have several customers all with the same database structure.
The message tab is as below :
Inserting data into #IndexColumns for clustered indexes and heaps Inserting data into #IndexColumns for nonclustered indexes Inserting data into #IndexSanity Checking partition count Preferring non-2012 syntax with LEFT JOIN to sys.dm_db_index_operational_stats Inserting data into #IndexPartitionSanity Inserting data into #MissingIndexes Inserting data into #ForeignKeys Inserting data into #ForeignKeys Gathering Computed Column Info. Gathering Trace Flag Information Gathering Temporal Table Info Updating #IndexSanity.key_column_names Updating #IndexSanity.partition_key_column_name Updating #IndexSanity.key_column_names_with_sort_order Updating #IndexSanity.key_column_names_with_sort_order_no_types (for create tsql) Updating #IndexSanity.include_column_names Updating #IndexSanity.include_column_names_no_types (for create tsql) Updating #IndexSanity.count_key_columns and count_include_columns Updating index_sanity_id on #IndexPartitionSanity Inserting data into #IndexSanitySize Determining index usefulness Updating #IndexSanity.referenced_by_foreign_key Update index_secret on #IndexSanity for NC indexes. Update index_secret on #IndexSanity for heaps and non-unique clustered. Populate #IndexCreateTsql. Populate #PartitionCompressionInfo. Update #PartitionCompressionInfo. Update #IndexSanity for filtered indexes with columns not in the index definition. @TableName specified, giving detail only on that table. Msg 121, Level 20, State 0, Line 1 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)Any ideas on what I can try and check/change to get it to complete ?
Asked by PabloInNZ
(101 rep)
Jun 19, 2023, 04:23 AM