search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 898 forks source link

Object Explorer incorrectly shows servers online in some cases #2930

Open kburtram opened 5 years ago

kburtram commented 5 years ago
  1. Connect to a server
  2. Take the server offline

Expected: Server shows as offline in OE Actual: Server incorrectly shows as online

Notes: Azure Data Studio does not have a "Service Status Watcher" component that detects when a SQL Server goes offline. That means that Object Explorer can incorrectly indicate a server is online and queries and node expansion will unexpectedly fail.

In SSMS this is handled by running WMI queries in a polling loop. We can considering porting over this code for Windows users, but we still need to investigate how to handle this problem on non-Windows platforms.

cheenamalhotra commented 2 years ago

Related to recent issue: #20385 We can choose to keep any one of them IMO.