TrustRadius

Foglight vs. SQL Server Management Studio (SSMS)

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Foglight
Score 10.0 out of 10
N/A
Foglight is a database performance management suite from Quest, with modules to perform cloud analytics, network performance monitoring and virtualization management, scaling to a broad, cloud / virtualization focused IT infrastructure monitoring solution.N/A
SQL Server Management Studio (SSMS)
Score 8.1 out of 10
N/A
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. SSMS is used to deploy, monitor, and upgrade the data-tier components used by applications, and to build queries and scripts. SSMS can also be used to query, design, and manage databases and data warehouses on a local…
$0
Pricing
FoglightSQL Server Management Studio (SSMS)
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
FoglightSQL Server Management Studio (SSMS)
Free Trial
NoNo
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details——
More Pricing Information
Community Pulse
FoglightSQL Server Management Studio (SSMS)
Best Alternatives
FoglightSQL Server Management Studio (SSMS)
Small Businesses

No answers on this topic

PyCharm
PyCharm
Score 9.3 out of 10
Medium-sized Companies
LogicMonitor
LogicMonitor
Score 8.9 out of 10
PyCharm
PyCharm
Score 9.3 out of 10
Enterprises
LogicMonitor
LogicMonitor
Score 8.9 out of 10
PyCharm
PyCharm
Score 9.3 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
FoglightSQL Server Management Studio (SSMS)
Likelihood to Recommend
9.0
(5 ratings)
7.0
(1 ratings)
User Testimonials
FoglightSQL Server Management Studio (SSMS)
Likelihood to Recommend
Quest Software
Strengths [Foglight]
  • Monitoring, Alerting and Management of on-prem virtualization and physical servers
  • Historical trending and baselining are excellent and being able to compare a problem period against the same sets of data for a period when there was no issue is especially helpful as part of troubleshooting.
  • Ease of use for end users is appreciated
Weaknesses [of Foglight]
  • Creation and management of custom monitors is a developer level activity requiring Groovy skillset
  • Less useful for management of an environment where there is a large amount of custom implementations
  • Commitment to longevity of cartridges/packs for specific subsystems
  • Ability to create custom schedules/alerts/escalations is only available via a 3rd party product (from a former Quest developer) and is not particularly easy to manage/manipulate
  • Lack of API accessibility for external integrations to other analytics (splunk, etc.)
Verified User
Anonymous
Read full review
Microsoft
Very well easy to use and helps productivity of user drastically
Verified User
Anonymous
Read full review
Pros
Quest Software
  • Database monitoring
  • Database management suite
  • Customization (both monitors and dashboards)
Aletha Diaz | TrustRadius Reviewer
Aletha Diaz
Sr. UNIX Systems Engineer
Read full review
Microsoft
  • Export data
  • Generate scripts
  • connecting to SQL instances
Verified User
Anonymous
Read full review
Cons
Quest Software
  • There are not many problems with this product
  • Limited ability to use Foglight itself to solve problems it identifies
Jaime L. Regan | TrustRadius Reviewer
Jaime L. Regan
Associate Attorney
Read full review
Microsoft
  • it can still be made easier for connecting perspective
  • some bugs on versions of SQL can be avoided.
  • can be more user friendly
Verified User
Anonymous
Read full review
Alternatives Considered
Quest Software
Anderson Costa | TrustRadius Reviewer
Anderson Costa
Middleware Administrator
Read full review
Microsoft
SSMS is very efficient and aids to do multiple tabs easily
Verified User
Anonymous
Read full review
Return on Investment
Quest Software
  • Foglight has a positive impact on my company by being a complete monitoring platform that specializes in risk assessment, user diagnosis and management, and server monitoring ensuring a secure business infrastructure through predictive analytics, query analysis, anomaly detection, behavior tracking, troubleshooting, automated discovery, and more.
JW
Juana Wilson
Human Resources Assistant
Read full review
Microsoft
  • easy to use accessibility
  • durability, It has been durable
  • recovery of old tabs.
Verified User
Anonymous
Read full review
ScreenShots