The primary difference is that Spotlight on SQL Server Enterprise is a laser focused tool for SQL Server while Foglight for SQL Server allows an organization/customer to monitor more than SQL Server (including, but not limited to, Oracle, DB2, Sybase, MySQL, PostgreSQL, Cassandra and MongoDB.
If you look at primarily what each tool does for SQL Server, they are far more similar than they are different. If you want to provide a few requirements around what you are looking for in a product, we can take a look and provide a recommendation based on what requirements you have.
The primary difference is that Spotlight on SQL Server Enterprise is a laser focused tool for SQL Server while Foglight for SQL Server allows an organization/customer to monitor more than SQL Server (including, but not limited to, Oracle, DB2, Sybase, MySQL, PostgreSQL, Cassandra and MongoDB.
If you look at primarily what each tool does for SQL Server, they are far more similar than they are different. If you want to provide a few requirements around what you are looking for in a product, we can take a look and provide a recommendation based on what requirements you have.