Can anyone help me to know The difference between foglight for SQL server and spotlight for SQL server?
I appologize for the delay on providing an answer.
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, VM’s, Storage, Applications, etc…).
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.