I have 3 default databases after installing ssms and sql server I did not create them and what are the following 3 databases can I delete them

Question

Answer 1

The databases you are referring to—DWConfiguration, DWDiagnostics, and DWQueueare not part of the default system databases that come with SQL Server installation. The default system databases installed with SQL Server are:

• master
• model
• msdb
• tempdb

The databases you've mentioned are likely associated with SQL Server Data Warehouse workloads or other management tools installed alongside SQL Server.

Here's what they are generally used for:

1. DWConfiguration
   • Used for storing configuration data related to Data Warehouse activities or tools.
   • Typically used by SQL Server Integration Services (SSIS) or related management components.
2. DWDiagnostics
   • Used for collecting diagnostic and performance data.
   • Helps monitor and diagnose issues in a data warehouse environment.
3. DWQueue
   • Acts as a queue for certain operations, likely related to data processing or integration tasks.
   • May support workflows, job tracking, or queue-based tasks in the Data Warehouse system.

Regarding whether you should delete them - no, unless you are sure they are not being used. These databases are likely part of a feature or tool that was installed alongside SQL Server, such as SQL Server Management Data Warehouse or Integration Services.

• If you are confident you don’t need these features and databases:
  1. Check for any dependent jobs, configurations, or tools using these databases.
  2. Back them up before deletion.
  3. Verify that their removal does not disrupt other SQL Server functionalities.

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Answer 2

These are databases to support the Polybase feature. Polybase is a feature that permits you talk to heterogeneous data sources as if they were tables in SQL Server.

It is not your every-day feature, and if you have just installed SQL Server to learn, you should probably not have selected all features, but you should have left Polybase out. It may be too late to change it. When I tried to uninstall Polybase from my SQL 2019 instance, that failed.

Now that you have installed Polybase, I recommend that you keep these databases. Who knows, maybe one day you will be interested in playing with that feature.

By the way, which version of SQL Server did you install?