search

trimble-oss / dba-dash

DBA Dash - SQL Server Monitoring Tool
MIT License
267 stars 63 forks source link

Exception on drivers tab on the main configuration report #1030

Closed vitorfavamastery closed 1 month ago

vitorfavamastery commented 1 month ago

I using DBA Dash to monitor 833 SQL Instances and when I try to open the Driver tab on the main configuration for all the SQL Server instances there is an Exception error:

"Sum of the columns FillWeight values cannot exceed 65535

image

DavidWiseman commented 1 month ago

Hi, thanks for reporting this. Can you copy/paste the full error text from the dialog? It will help narrow things down. Also, can you tell me how many SQL instances you are monitoring? Just wondering if this might be a factor with it creating a column per instance.

DavidWiseman commented 1 month ago

I can reproduce this issue in one of our environments that has a large number of SQL Instances. The issue is described here. It occurs when there are more than 655 auto-generated columns in the grid control (more than 653 SQL instances). The issue occurs due to the columns being assigned a FillWeight of 100 and the max total FillWeight for the grid is 65535.
The FillWeight is only used to determine the relative size of the columns when set to Fill. I should be able to add the columns manually and set the FillWeight to 1 to allow over 65K SQL instances.

DavidWiseman commented 1 month ago

This will be fixed in the next release (soon). The tab might be slow to load with over 653 SQL Instances but you will no longer get this error.
As a workaround you can use the grouping and filtering options to limit the number of SQL instances

vitorfavamastery commented 1 month ago

[celebrate] Vitor Fava (EXT) reacted to your message:

Vitor Fava (EXT) Senior Database Developer Mastery Logistics Systems, Inc. Email: @.*** www.mastery.net

From: David Wiseman @.> Sent: Tuesday, October 1, 2024 10:23:48 AM To: trimble-oss/dba-dash @.> Cc: Vitor Fava (EXT) @.>; Author @.> Subject: Re: [trimble-oss/dba-dash] Exception on drivers tab on the main configuration report (Issue #1030)

This will be fixed in the next release (soon). The tab might be slow to load with over 653 SQL Instances but you will no longer get this error. As a workaround you can use the grouping and filtering options to limit the number of SQL instances

— Reply to this email directly, view it on GitHubhttps://github.com/trimble-oss/dba-dash/issues/1030#issuecomment-2385405064, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BLKWZ4OCQMRXS7IAD2SQCKLZZJZ3JAVCNFSM6AAAAABPAVAKXCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGOBVGQYDKMBWGQ. You are receiving this because you authored the thread.Message ID: @.***>

DavidWiseman commented 1 month ago

Fixed in 3.11 🚀