What is the smiley? The smiley on the “Overview 1” dashboard tells, that there are no high or critical errors on any of the production servers.

I have added a server but no information is collected? When adding servers in the Performance Store Control Center, information about the servers are only collected in the given time interval set in the Settings menu: If the collection interval is set to 30 seconds (default value), there might be a delay of 30 seconds […]

SQL Server version support Performance Store supports SQL Server versions from 2008 to 2022. All SQL Server editions are supported including Express editions. Although all versions are supported, not all features are available on all versions. If a feature is available depends on if the feature is natively supported by the SQL Server version, e.g. […]

Is SQL Server on Linux supported? Yes, SQL Server on Linux and in containers are supported with the following limitations: No capacity handling (and thereby no forecasting) No server-level CPU usage information No failover information It is not possible to determine if the Linux host running the SQL Server is physical or virtual. This has […]

Why can’t I see schema changes or errors in the logs? Schema changes and errors are collected locally on each individual SQL Server in an in-memory ring buffer. When the buffer is full (or 30 seconds have passed), the ring buffer is flushed to disk. If very few schema changes or errors are occuring, the […]

Are SQL Server snapshots supported? Yes, SQL Server snapshots are fully supported.

Is MARS supported? Yes, Multiple Active Result Sets (MARS) are fully supported.

Are mount points supported? Yes, mount points are fully supported.

Are servers still monitored if the Performance Server is down? Most information is still monitored even if the central Performance Store server is down, e.g. for maintenance. When the Performance Store server is up running again, information will be collected. Some data is collected by Performance Store by sampling various DMVs on the monitored SQL […]

Performance Store requirements Performance Store is build to be lightweight. The size of the Performance Store service is less than 3 MB, and depending on the number of monitored servers, only requires minimal resources. The SQL Server hosting the Performance Store database must be SQL Server 2016 SP1 or newer. See Security requirements for information […]