cheenamalhotra
commented
1 year ago Hi @JFitzMan
This issue is now resolved in the latest insiders build with PR https://github.com/microsoft/sqltoolsservice/pull/2175 and will be included in the next stable release (v1.46)
I will proceed to close the issue as resolved.
Issue Type: Bug
Every couple of minutes I'm unable to run queries or copy results out of the grid. This is due to this query running in the background, on average it completely takes over my SQL connection for about a minute at a time. This query runs often, about once every 5 minutes or so
Here's the query that's run by Azure Data Studio:
` (@_msparam_0 nvarchar(4000),@_msparam_1 nvarchar(4000),@_msparam_2 nvarchar(4000),@_msparam_3 nvarchar(4000),@_msparam_4 nvarchar(4000))SELECT CAST( serverproperty(N'Servername') AS sysname) AS [Server_Name], db_name() AS [Database_Name], SCHEMA_NAME(v.schema_id) AS [View_Schema], v.name AS [View_Name], i.name AS [Name], CAST(ISNULL(si.bounding_box_xmax,0) AS float(53)) AS [BoundingBoxXMax], CAST(ISNULL(si.bounding_box_xmin,0) AS float(53)) AS [BoundingBoxXMin], CAST(ISNULL(si.bounding_box_ymax,0) AS float(53)) AS [BoundingBoxYMax], CAST(ISNULL(si.bounding_box_ymin,0) AS float(53)) AS [BoundingBoxYMin], CAST(case when (i.type=7) then hi.bucket_count else 0 end AS int) AS [BucketCount], CAST(ISNULL(si.cells_per_object,0) AS int) AS [CellsPerObject], CAST(i.compression_delay AS int) AS [CompressionDelay], ~i.allow_page_locks AS [DisallowPageLocks], ~i.allow_row_locks AS [DisallowRowLocks],
CASE WHEN ((SELECT tbli.is_memory_optimized FROM sys.tables tbli WHERE tbli.object_id = i.object_id)=1 or (SELECT tti.is_memory_optimized FROM sys.table_types tti WHERE tti.type_table_object_id = i.object_id)=1) THEN ISNULL((SELECT ds.name FROM sys.data_spaces AS ds WHERE ds.type='FX'), N'') ELSE CASE WHEN 'FG'=dsi.type THEN dsi.name ELSE N'' END END AS [FileGroup], CASE WHEN 'FD'=dstbl.type THEN dstbl.name ELSE N'' END AS [FileStreamFileGroup], CASE WHEN 'PS'=dstbl.type THEN dstbl.name ELSE N'' END AS [FileStreamPartitionScheme], i.fill_factor AS [FillFactor], ISNULL(i.filter_definition, N'') AS [FilterDefinition], i.ignore_dup_key AS [IgnoreDuplicateKeys],
ISNULL(indexedpaths.name, N'') AS [IndexedXmlPathName], i.is_primary_key + 2*i.is_unique_constraint AS [IndexKeyType], CAST( CASE i.type WHEN 1 THEN 0 WHEN 4 THEN 4 WHEN 3 THEN CASE xi.xml_index_type WHEN 0 THEN 2 WHEN 1 THEN 3 WHEN 2 THEN 7 WHEN 3 THEN 8 END WHEN 4 THEN 4 WHEN 6 THEN 5 WHEN 7 THEN 6 WHEN 5 THEN 9 ELSE 1 END AS tinyint) AS [IndexType], CAST(CASE i.index_id WHEN 1 THEN 1 ELSE 0 END AS bit) AS [IsClustered], i.is_disabled AS [IsDisabled], CAST(CASE WHEN filetableobj.object_id IS NULL THEN 0 ELSE 1 END AS bit) AS [IsFileTableDefined], CAST(ISNULL(k.is_system_named, 0) AS bit) AS [IsSystemNamed], CAST(OBJECTPROPERTY(i.object_id,N'IsMSShipped') AS bit) AS [IsSystemObject], i.is_unique AS [IsUnique], CAST(ISNULL(si.level_1_grid,0) AS smallint) AS [Level1Grid], CAST(ISNULL(si.level_2_grid,0) AS smallint) AS [Level2Grid], CAST(ISNULL(si.level_3_grid,0) AS smallint) AS [Level3Grid], CAST(ISNULL(si.level_4_grid,0) AS smallint) AS [Level4Grid], ISNULL(s.no_recompute,0) AS [NoAutomaticRecomputation], CAST(ISNULL(INDEXPROPERTY(i.object_id, i.name, N'IsPadIndex'), 0) AS bit) AS [PadIndex], ISNULL(xi2.name, N'') AS [ParentXmlIndex], CASE WHEN 'PS'=dsi.type THEN dsi.name ELSE N'' END AS [PartitionScheme], case UPPER(ISNULL(xi.secondary_type,'')) when 'P' then 1 when 'V' then 2 when 'R' then 3 else 0 end AS [SecondaryXmlIndexType], CAST(ISNULL(spi.spatial_index_type,0) AS tinyint) AS [SpatialIndexType] FROM sys.all_views AS v INNER JOIN sys.indexes AS i ON (i.index_id > @_msparam_0 and i.is_hypothetical = @_msparam_1) AND (i.object_id=v.object_id) LEFT OUTER JOIN sys.spatial_index_tessellations as si ON i.object_id = si.object_id and i.index_id = si.index_id LEFT OUTER JOIN sys.hash_indexes AS hi ON i.object_id = hi.object_id AND i.index_id = hi.index_id LEFT OUTER JOIN sys.data_spaces AS dsi ON dsi.data_space_id = i.data_space_id LEFT OUTER JOIN sys.tables AS t ON t.object_id = i.object_id LEFT OUTER JOIN sys.data_spaces AS dstbl ON dstbl.data_space_id = t.Filestream_data_space_id and (i.index_id < 2 or (i.type = 7 and i.index_id < 3)) LEFT OUTER JOIN sys.xml_indexes AS xi ON xi.object_id = i.object_id AND xi.index_id = i.index_id LEFT OUTER JOIN sys.selective_xml_index_paths AS indexedpaths ON xi.object_id = indexedpaths.object_id AND xi.using_xml_index_id = indexedpaths.index_id AND xi.path_id = indexedpaths.path_id LEFT OUTER JOIN sys.filetable_system_defined_objects AS filetableobj ON i.object_id = filetableobj.object_id LEFT OUTER JOIN sys.key_constraints AS k ON k.parent_object_id = i.object_id AND k.unique_index_id = i.index_id LEFT OUTER JOIN sys.stats AS s ON s.stats_id = i.index_id AND s.object_id = i.object_id LEFT OUTER JOIN sys.xml_indexes AS xi2 ON xi2.object_id = xi.object_id AND xi2.index_id = xi.using_xml_index_id LEFT OUTER JOIN sys.spatial_indexes AS spi ON i.object_id = spi.object_id and i.index_id = spi.index_id WHERE (v.type = @_msparam_2)and(v.name=@_msparam_3 and SCHEMA_NAME(v.schema_id)=@_msparam_4) ORDER BY [Database_Name] ASC,[View_Schema] ASC,[View_Name] ASC,[Name] ASC `
Azure Data Studio version: azuredatastudio 1.18.1 (5b3b97f4a34018f3b37b0fce30e32f2af7ad78fa, 2020-05-26T21:14:29.147Z) OS version: Windows_NT x64 10.0.18362
System Info
|Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz (4 x 3193)| |GPU Status|2d_canvas: enabledflash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
oop_rasterization: disabled_off
protected_video_decode: unavailable_off
rasterization: enabled
skia_renderer: disabled_off_ok
video_decode: enabled
viz_display_compositor: enabled_on
viz_hit_test_surface_layer: disabled_off_ok
webgl: enabled
webgl2: enabled| |Load (avg)|undefined| |Memory (System)|11.91GB (1.49GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (17)
Extension|Author (truncated)|Version ---|---|--- bracket-pair-colorizer|Coe|1.0.60 gitlens|eam|9.8.1 ssmskeymap|kev|1.1.0 query-history|Mic|0.1.0 server-report|Mic|0.2.2 whoisactive|Mic|0.1.4 azure-account|ms-|0.8.4 powershell|ms-|2019.5.0 vsliveshare|ms-|1.0.337 team|ms-|1.149.2 azdata-sanddance|msr|3.0.0 sql-search|Red|0.3.3 simple-data-scripter|sea|0.1.0 vscodeintellicode|Vis|1.2.1 vscode-icons|vsc|8.8.0 snippet-creator|nik|0.0.4 poor-sql-formatter|WSR|0.1.0 (3 theme extensions excluded)