2.0.52 Release date: 31. October 2026. New: Real time activity. Use s_activity locally on each monitored server to see realtime activity data. https://sosequel.com/knowledge-base/realtime-activity-data/ 2.0.51 Release date: 15. October 2026. New: New views: v_local_admins and v_local_admins_expanded. New dashboard: "Local administrators". New column in v_servers and the Servers dashboard: sql_server_browser_service_running 2.0.50 Release date: 2. October 2026. New: Log flushed per second and log flush wait time added to the "Overview 2" dashboard. New view: v_database_performance_counters. A database specific view of the existing v_performance_counters view. Session encryption information added to activity views and dashboards. 2.0.49 Release date: 18. September 2026. New: It is now possible to enable and disable teams in the Performance Store Control Center. 2.0.48 Release date: 15. September 2026. New: New column in v_indexes and on the Indexes dashboard: compression_level. This column states if any compression and what type of compression is used on the table or index. If the index is spanning multiple partitions, and different compression types are used, compression_level will be MIXED. 2.0.47 Release date: 3. September 2026. Bug fixes: Fixed a bug where blockings with wait resources spanning multiple database files did not get registered. Grafana has a bug where some dashboard elements can sometimes be empty. Performance Store now mitigates this bug. 2.0.46 Release date: 19. August 2026. New: Added support for Docker containers on different domains. PowerShell and WebHook alerts will now include the alert category and the alert type (FAILED or SOLVED). Upgraded to Grafana 11.6.16. Changes: Added additional help information in the Performance Store Control Center, to solve when a server is monitored in the "limited" state. Bug fixes: Fixed a bug where checking for Windows Defender exclusions on a Windows Servver 2012 produced an error. 2.0.45 Release date: 11. August 2026. Changes: Optimized internal license handling functionality, including detailed error reporting. 2.0.44 Release date: 15. July 2026. Bug fixes: Fixed a bug where the Performance Store installer could throw an out of memory exception when using a remote desktop connection using the RFB protocol. 2.0.43 Release date: 7. July 2026. New: The script for revoked user accounts now contains the revoke statement. 2.0.42 Release date: 16. June 2026. New: New functionality: See which department uses a database the most. New feature: See if all Microsoft Defender exclusions are in place, and if not, where they are missing. Optimized WMI query performance on servers with more than 64 CPUs. Database responsible is now exported when exporting the Performance Store configuration. Bug fixes: Fixed a bug where user activity could show data for people that has left the organization. 2.0.41 Release date: 12. May 2026. New: Individual index sizes added to Indexes dashboard and v_indexes. Performance Store now detects if the Virtualization-Based Security with Credential Guard is enabled, so this does not conflict with the virtual machine detection logic. Event storm protection: Servers can now be quarantined if the number of events crosses a certain threshold. Can be configured in the Performance Store Control Center. New alert "Event storm": https://sosequel.com/knowledge-base/event-storm/ New functionality "Database manager": https://sosequel.com/knowledge-base/database-manager/ Upgraded to Grafana 11.6.15. 2.0.40 Release date: 13. April 2026. New: Support for new fixed server-level roles in SQL Server 2022 and 2025. Added functionality to automatically synchronize nodes in an Availability Group (disabled by default). For more informaton see: https://sosequel.com/knowledge-base/synchronize-availability-group-objects/ If a SQL Agent job fails, Performance Store can now send a mail to the last person who modified the job. This can be enabled in the Performance Store Control Center. Full support for Lock Escalations: Now possible to view on the Blockings dashboard if the blockings are due to lock escalations including the exact table and index, what type of escalation and the cause etc. New view: v_lock_escalations. New table, allow_as_not_clean, where added databases will not affect the AG_ALLPRIMARY_NOTCLEAN, AG_ALLSECONDARY_NOTCLEAN and AG_MIXED_NOTCLEAN availability group info values for servers. New alert "Database in non-operational state": https://sosequel.com/knowledge-base/database-in-non-operational-state/ 2.0.39 Release date: 2. February 2026. New: Full vCenter integration. Host info, virtual machines etc. can now be fetched automatically from vCenter. Supports all versions of vCenter. On the Hosts dashboard it now shows how much CPU each virtual machine is using on each host. Easily spot if the combined CPU usage of all virtual machines on a host is using more CPU capacity than available on the host. Redesigned Agent job audit functionality. Agent job audit will now be enabled by default. Individual event types for Agentjob audit (ADD_JOB, DELETE_JOB, UPDATE_JOB, ADD_JOBSCHEDULE, ATTACH_SCHEDULE, ...). Agent job name added to audit. Added modified_by to Agent job views, dashboards and Database Finder. This column shows who made the latest modification to the agent job. HOBT blockings will now be translated to schema-, object- and index names. The SQL Server Patch Manager now supports hybrid scenarios where Availability Groups are installed on Failover Cluster Instances. Upgraded to Grafana 11.6.14. Changes: Optimized performance on the Agent job executions dashboard. Important: After upgrade, monitoring on all servers will be disabled. Enable monitoring on servers again in the Performance Store Control Center. 2.0.38 Release date: 22. January 2026. New: New columns in Indexes dashboard and v_indexes view: index_length_in_bytes, exceeds_max_length and number_of_columns. New stored procedure, s_set_maintenance_mode, where users without access to the Performance Store Control Center can set servers in- and out of maintenance mode. New view, v_maintenance_mode_history, that shows what was set in maintenance mode when and by whom. Added "server_changes_in_period" and "host_changes_in_period" to Hosts dashboard. "Top completed queries" dashboard and view v_top_completed now translates Agent job names automatically from the job_id. Changes: "Memory drop" alert will now not be invoked within one hour after a SQL Server service restart. Bug fixes: Fixed a bug where the Xml report for blocked processes was not shown for Intra-query parallelism blockings. 2.0.37 Release date: 8. January 2026. New: Changelog will now include release date. License information will now be displayed in Grafana. Added "schema_name" column in table usage views and dashboard. Customer ID is displayed in the About section of the Performance Store Control Center. OPTIMIZED_SP_EXECUTESQL and ASYNC_STATS_UPDATE_WAIT_AT_LOW_PRIORITY is now enabled by default for the Performance Store database on SQL Server 2025 instances. Added OPTIMIZED_SP_EXECUTESQL and ASYNC_STATS_UPDATE_WAIT_AT_LOW_PRIORITY to database views, dashboards and Database Finder. Added "type" column to "Top completed queries" dashboard. New dashboard "Hosts" and views, v_host_history and v_hosts, contains info on hosts as well as historical information of what host VMs resided on. New dashboard "Drive usage". See historical drive usage patterns. Changes: A new format for the Performance Store changelog will be used from now on. This means, older versions than 2.0.37 will show changes up till version 2.0.37 in the changelog. To see changes for versions newer than 2.0.37, update to Performance Store 2.0.37 or newer. Improved performance when translating deadlocks. When comparing server configurations, a difference in processor speed of less than 500 Mhz will now be ignored. The AG sync script now handles roles differently than users and groups. 'Deadlocks' and 'Errors' alerts will now be thrown by default for new teams when above a certain threshold. "Memory drop" alert changed from High to Medium criticality. Optimized performance when collecting user activity information. An error will now not be shown in the Performance Store error log if the default trace is disabled. MSDB database roles will now be included by default in the database security views and dashboards (can be excluded in dbo.database_security_whitelist). For table usage information, rows are now not included if both read- and write operations are 0. Due to a bug in SQL Server 2025, aborted executions are not collected by the SQL Engine. Performance Store will still show aborted executions with "Result = 'Error'" in "Top completed queries" view and dashboard for SQL Server 2025. Capacity information is now kept for 400 days (default) instead of 30 days. Bug fixes: Fixed a bug where alerts where not displayed correctly in some scenarios. Fixed a bug where failover history markers where not displayed. 2.0.36 New: Drive preditions now includes bus type and aggregated information. It is now possible to see execution stats for each individual procedure and function in a statement. New alert: "Disk drives with less than 5 % free space". Upgraded to Grafana 11.6.9. Changes: Redesigned Top Completed Queries and Errors functionality. 2.0.35 New: Time ranges will now persist when clicking on links on dashboards. The view v_stored_procedures is now also including schema_name and object_id columns. Column last_end_time added to procedure- and query statistics views and dashboards. Upgraded to Grafana 11.6.8. Added SSMS 2022 support to the Database Finder. Changes: Natively compiled procedures will now have its worker time reported in the same unit as non-natively compiled procedures. Bug fixes: Fixed a race condition bug, where long running procedures and queries were not always having their statistics picked up. 2.0.34 New: Added "start_time" column to activity views and dashboards. Performance Store will now determine if too many events of the same type is creating bottlenecks in the data collection, and take relevant measures. New column on Indexes dashboard and v_indexes view: fill_factor Optimized procedure- and query collection time. Changes: When changing settings in the Performance Store Control Center that requires a service restart, only the Performance Store service is now restartet and not the individual helper services. Improved prediction time for table- and index sizes. Bug fixes: Fixed bug, where the Dyna Trace API key was not decoded correctly. 2.0.33 New: We are happy to announce, that "Agent job executions", "Database files", "Table sizes" and "Failover history" from the full version of Performance Store is now available in the light version of Performance Store as well. Native Dyna Trace support for Virtual Machine host information. Host information can now be automatically integrated in Performance Store. It is now possible to see Agent job definition history. Every single change to Agent jobs are now preserved, so Agent jobs can quickly be rolled back to a previous version. Available on the "Agent jobs" dashboard and the new view v_agent_job_definitions. Support for custom dashboards when synchronizing dashboards to different teams. "R squared" values added to all prediction dashboards and views. "R squared" indicated how precise the predictions are. See Wikipedia for more info: https://en.wikipedia.org/wiki/Coefficient_of_determination Added memory_overcommitted to "Memory usage" section on the "Memory" dashboard and new v_memory_usage view. New procedure, dbo.s_database_authorizations_diff, and new alert: Database authorizations differences. New view, v_plan_changes. Use this view to see plan regression. New alerts: "Instance memory can be reduced" and "Server memory can be reduced". Upgraded to Grafana 11.6.6. Changes: In "Top 100 queries with multiple plans for the same statement" the "creation_time" column now reflects the creation time for the first of the identical plans. For Query Statistics and Procedure Statistics, data is now also retrieved for system databases. Alert for "Failed SQL Agent job" will now disappear after 1 day. Bug fixes: Fixed a bug where the number of blocked sessions were not reported correctly in "Activity aggregated". Fixed a bug where bus type was not always filled on "Database files" dashboard and view. 2.0.32 New: New stored procedure, s_get_ag_sync_script, that can be used to synchronize logins, users, roles, authorizations, securables and agent jobs between replicas. More information: https://sosequel.com/knowledge-base/synchronize-availability-group-objects/ Individual timers can now be enabled/disabled in the Performance Store Control Center. It is now possible to see when an agent job definition has been updated. Column steps_with_non_existing_databases added to Agent job views and dashboard. New alert "Agent job step with non-existing database". New section on the Memory dashboard, "Memory usage" and corresponding view, v_memory_usage. Shows actually used memory on server- and instancelevel based on data from the last 3 months. New stored procedures: s_database_security_diff and s_database_securables diff. Shows differences in e.g. system databases between replicas. Changes: Changed the way server security differences is compared between replicas. Previously security was only compared if logins were mapped on databases on the replicas. Now all logins are compared, but only for replicas without readable secondaries. When comparing securables, the service endpoints are now not included. Service endoints usually have different names, so it does not make sense to compare them. When removing a job schedule from an agent job, the job modification date is updated correctly. When editing or adding a schedule, the agent job modify_date is not changed. Performance Store now mitigates this default SQL Server behavior, so the correct modify_date is shown. Agent job executions are now shown visually even if they have an execution time less than 1 second. The create statement for server security objects now includes the creation of securables no matter if the login exist or not. When automatically offlining databases, it will offline the secondary database at the same as the primary. Optimized performance when getting deadlocks and blockings to translate. Optimized performance when predicting table size usage. Bug fixes: Fixed a bug where database owner name was not compared when comparing databases in an Availability Group. Fixed a bug where authorizations where collected multiple times if the user with the authorizations were having server level securables. Fixed a bug in the "Memory dump" alert, where it was not always triggered. Server role creation scripts contained "create role ...". This has been changed to "create server role ...". Mitigated a bug in SQL Server, where it reports wrong time for memory dumps. 2.0.31 New: Blockings will now have their actual objects and indexes translated (similar to the way it is done for deadlocks). Timeouts dashboard now includes a "Location" selector. Table size forecasting will now also include forecasting based on data from the last 6 months. Added support for 43 new wait types. Upgraded to Grafana 11.6.5. Changes: "Top 100 queries with multiple plans for the same statement" on the Memory dashboard now conforms to the chosen date- and interval. An (intercepted) error will not be thrown any more when XML with more than 128 nested levels will be converted to the XML data type. "Memory drop" alert will now not be triggered if a database on the server has been set offline or deleted within the last hour. The Performance Store database and the local management databases will now run with full optimized locking and optimized Halloween protection in SQL Server 2025. Bug fixes: Fixed a bug where the Timeouts dashboard showed an incorrect duration length if not using UTC time zone. 2.0.30 New: New dashboard, Database files, and view, v_database_files. Contains information about database files and file groups. Here you can see e.g. if a dababase file is placed on NVMe or SAN storage etc. New column on the Deadlocks dashboard and the v_deadlocks view: xml_report_size. This column can give an indication of how many sessions are affected by the deadlock. Member initials and Team id added to the Teams section in the Performance Store Control Center. Upgraded to Grafana 11.6.4. New alert "Unequal filegrowth". Changes: For the alert "SQL Server with databases not in availability group", it will no longer be thrown for readable secondaries, as in this scenario, servers are usually not expected to be identical. When deleting a team, corresponding custom alerts will be deleted for that team. Alerts for servers in timeout will not be held for the duration of the timeout anymore. Bug fixes: Fixed a bug where SQL statements above 2 TB could not be handled when retrieving plan cache content. Fixed a bug where values in dbo.team_alert_exclude_from_stats was not respected in dbo.v_latest_stats. Fixed a bug where on some dashboards, some datetime values where of an incorrect character length. 2.0.29 New: New columns index_partition_scheme_name, table_partition_scheme_name and using_table_partition_scheme added to v_indexes and Indexes dashboard. This information can be used for determining if indexes are aligned. Changes: The domain name for AD group members are now translated from the SID instead of fetched from the distinguished name. AGs with readable secondaries are now not included when comparing AG configurations, Agent jobs, databases, drives and security differences. When WMI is not enabled, socket information can not be retrieved. Instead of listing a socket count of 0, the socket count is now null. 2.0.28 Bug fixes: Fixed datasouce error on the Memory dashboard. 2.0.27 Changes: Optimized collection performance when collecting multiple plans from the plan cache. Optimized dashboard load time for multiple plans on the Memory dashboard. Bug fixes: Fixed a bug where teams without members did not show up in the Performance Store Control Center. Fixed a bug where AD group members would be listed multiple times for AD groups with circular references. 2.0.26 New: New section on the Memory dashboard: "Queries with multiple plans for the same statement". This will show queries that can benefit from parameterization. Same information is available in the new view v_multiple_plans. "Memory UI" implemented in the Performance Store Control Center. All columns can be rearranged, and column position, sort order and length as well as window sizes will be remembered across sessions. Number of members in each team is now shown on the Manage teams form in the Performance Store Control Center. Total number of team members now shown on the main screen in the Performance Store Control Center. Bug fixes: Fixed af bug where "Cached statements" was not shown in the detailed view as a category on the Memory dashboard. 2.0.25 New: Upgraded to Grafana 11.6.3. Changes: Changed code signing to use an Extended Code Signing Certificate. Bug fixes: Fixed bug where the aggregated Memory graph did not report the correct values. 2.0.24 New: Added support for SQL Server authentication when doing an unattended installation of Performance Store. Changes: Changed procedure- and query stats retrieval to use parameters instead to reduce plan cache bloating. Bug fixes: Temp files was not fully cleaned up during installation process. Fixed bug where unattended install did not work correctly. 2.0.23 New: Full support for Azure SQL Managed Instance. User sessions blocking Performance Store operations for more than 5 minutes (default) will now be automatically killed. For more information see: https://sosequel.com/knowledge-base/kill-blocking-sessions/ Added support for Software Assurance in unattended install. All available Mail profiles are now shown in the Performance Store Control Center. Mail info added to views containing AD user information. Reinitializing monitoring on servers in the Performance Store Control Center can now be chosen for selected servers only. Full support for SQL logins in the Performance Store Control Center when setting up monitoring on servers. New column, is_disabled, on index dashboard and view. Index- and table usage statistics is now also collected for readable secondary replicas. Team members can now be seen in the Teams section in the Performance Store Control Center. New view (v_authorizations) and Dashboard (Authorizations) where server- and database authorizations can be seen. Upgraded to Grafana 11.6.2. Changes: Changed minimum supported SQL Server version to 2017 for hosting the Performance Store database. "Database" dropdown on dashboards will now only display discovered databases. Renamed view v_hist_index_usage to v_hist_table_usage. 2.0.22 New: Full support for using CNAMEs when connecting to the Performance Store SQL Server. CNAMEs will automatically be set to the correct server name in various whitelist tables. Errors can now be filtered based on if they are intercepted (included in a try/catch) or not. All the many errors from SSMS is now excluded by default. All the many errors from Red Gate products are now excluded by default. Could be multiple hundred thousands a day. Table- an index usage stats are now also available for user tables in the master database. SQL Server license usage can now be calculated based on whether Software Assurance is used or not. Bug fixes: Mitigated a bug in the .NET Framework where FileVersionInfo did not return the correct file version. 2.0.21 New: Performance Store now reports, if the SQL Server service account or SQL Server Agent service account is a member of the local administrators group. Upgraded to Grafana 11.6.1. Bug fixes: On the blockings and Size changes dashboards, it could show baseline graphs without having chosen to do so. 2.0.20 New: Upgraded to Grafana 11.6.0. is_virtual added to Database capacity predictions dashboard and view. Redo queue-, log size- and database size information is now faster to load on the dashboards. Bus type is now also collected for MBR partitions and not only for Guid partitions. Changes: All columns with time information will now present the time in the chosen time zone. Changed "Memory drop" alert, so the default threshold is 50% deviation instead of 10% deviation. Current table size information now also contains info for secondary resplicas. Changed the way custom stats are handled when servers are non-reachable. Bug fixes: Fixed a bug where collecting procedure statistics for a database in single_user mode would generate an error message. Mitigates when SQL Server throws an error 8181. This is a bug in SQL Server. Mitigates when SQL Server thinks a non-readable replica as a readable-replica. This is a bug in SQL Server. 2.0.19 New: Table usage operations now include aggregated statistics. Servers views and dashboard now displays if CEIP is enabled. Upgraded to Grafana 11.5.2. Optimized deadlock translation performance. When collecting table size- and index information, a schema lock on objects will not longer prevent collection of information from other tables. Changes: If timing out when retrieving securables information, database security information will now still be collected. v_table_sizes_current now includes last fetched data, so data for e.g. servers in timeout will still be present. Bug fixes: Fixed a bug where Performance Store would try to translate deadlock info for deleted databases. There is a bug in Grafana where it does not url encode Danish characters correctly. Performance Store now mitigates this. 2.0.18 New: Deadlocks will now have their actual objects and indexes translated. "waitresource" column added to v_deadlocks and Deadlocks dashboard. "log_reuse_wait_desc" column added to v_databases and Databases dashboard. Agent job definitions are now saved for deleted SQL Agent jobs. Created support for internal database snapshots (like the ones used by e.g. CheckDB). Full CHECKDB information added, including support for running CHECKDB on secondary replicas. New view: v_table_sizes_current. Redo queue size and redo rate information is now shown per database. Changes: Securables now utilizes streaming from the source to the target, minimizing memory usage. Table size information is now also collected for empty tables. Bug fixes: Fixed a bug where a deadlock could occur when updating dbo.databases. Fixed bug where query plan was not always collected. 2.0.17 New: Full support for SQL Server 2025, including full support for new Standard Developer Edition and optimized locking. 2.0.16 New: Added create_date, modify_date, is_role_owner, schema_owner_name and role_owner_name to security dashboards and views. Added create_date, modify_date and description to Agent Jobs dashboard and views. It is now possible to see Agent Job definitions in Agent Jobs dashboard and views. Upgraded to Grafana 11.4.0. It is now possible to show only read- or write operations (or both) in the "Table usage" dashboard. 2.0.15 New: New table, dbo.team_alert_exclude_from_stats. In this table it is possible to filter out specific alerts, so they will not be shown in dashboards and views. Changes: CXSYNC_CONSUMER and CXSYNC_PORT wait types are now included in the "Parallelism" wait stats instead of "Other". Bug fixes: Fixed a bug where importing configuration data was not correct for dbo.table_access. Fixed a bug where mount points were not correctly displayed in the following alerts: "Disk drives with less than 20 % free space", "Data drive with incorrect cluster size", "Disk drives running below 20 % free space within a week", "Disk drives running empty within a week" and "Log drive with incorrect cluster size". 2.0.14 New: There is a bug in CHECKDB where it can report a negative CPU usage percentage in sys.dm_exec_requests. Performance Store will automatically correct this so data is shown correctly on CPU graphs. New tables, procedure_stats_whitelist and query_stats_whitelist, to filter out specific query- or procedure stats. Upgraded to Grafana 11.3.1. Bug fixes: Fixed a bug in the new table usage functionality, where the reported data was not correct. 2.0.13 New: New dashboard "Table usage" and corresponding view v_hist_index_usage. It is now possible to see usage statistics for each table. See how many read- and write operations are on each table, and if any tables are not used at all. Upgraded to Grafana 11.3.0+security-01. 2.0.12 New: New dashboard and view: Indexes and v_indexes. Contains relevant information about index activity and if indexes are unused or not. It is now possible to only show quarantined on the Timeouts dashboard. Error 22803 (Change Data Capture information message) has been excluded from the error log. Added "USE" statement for database objects in securables- and database security create statements. Added "dbcc checkdb" to user activity whitelist. Upgraded to Grafana 11.3.0. New view: v_unused_databases_info. Will show info about when databases are about to be automatically set offline (if enabled). Virtual databases excluded from database backup check alert. New alert, "Memory drop", that will trigger if a sudden drop occurs in the buffer pool memory. New alert, "SQL Server restart" that will trigger if a production SQL Server is restarted or the SQL Server service is restarted. When saving the Performance Store configuration from the Control Center, settings for specific team alerts will now be saved. Optimized procedure- and query stats collection. Bug fixes: Fixed a bug where redo queue size was not always calculated correctly. Fixed a bug where Availability Group id's could change if all databases were removed from an AG and added again. Fixed a bug where indirect_user and is_mapped_in_any_database was not always transferred correctly to securables_expanded. Changes: Procedure- and query stats will now be saved for 2 days. 2.0.11 New: Activity views and dashboards now translates Agent job queries to the actual Agent job name and Job category. Upgraded to Grafana 11.2.2. "Alter any availability group" permissions will now be set for the Performance Store user when adding a new server. Existing servers will have the new permission set after doing a reinitialization of servers. Optimized activity-, index- and table size fetch times. Timestamps on "Top completed" and "Size changes" dashboards and views now adapts to the chosen UTC configuration. New views: v_ad_users and v_ad_groups. AD group descriptions are now available in v_securables, v_server_security and v_database_security. Information about group- and user manager added to security views and dashboards. Added info to the Database Finder if a database is unused or not. Bug fixes: Fixed a bug where a "Server unreachable" alert could be thrown in a rare scenario when disabling maintenance mode for a server. Fixed a bug where it was not possible to see create statements in a separate window for server level objects on the Securables dashboard. 2.0.10 New: History is now preserved for all security objects - both inherited and non-inherited. Bug fixes: Fixed a bug, where used log space percentage was not calculated if it was null. 2.0.9 New: It is now possible to send individual alerts to individual team members. Bug fixes: Some alerts could be thrown with a delay of up to 30 seconds. This delay is now gone, Changes: set_offline_date in v_offline_databases is now reflecting the precise offline date and time. Before there was a margin of up to 30 seconds. Optimized "HandleDatabases" sampling performance. 2.0.8 New: Better error messages hwne trying to use SQL Server Patch Manager, Database Finder and Control Center for non-approved users. Changes: Team operations in the Control Center now will only take effect after a Grafana service restart. This is due to internal changes in Grafana. Microsoft has disabled using icons from networks shares for shortcuts. Shortcuts are now using local icons. 2.0.7 New: Added "notes" to database views, dashboard and Database Finder. Added new procedures to control database notes: s_database_note_item_upsert, s_database_note_item_select, s_database_note_item_delete. Added "sample_id" to database- and server dashboards. Changes: Rewritten functionality to retrieve canonical names for servers, as the previous method used could lead to a memory leak due to a bug in a Microsoft assembly. When removing a server from monitoring, permissions for the server will be removed from Performance Store. Collection of database capacity information will now be at fixed times (can be set in the Control Panel) instead of at a given interval. 2.0.6 New: Upgraded to Grafana 11.2.0. Changes: Optimized performance in alert "Primary and secondary placed on same host". Department info will not be shown in the tooltip on the Capacity dashboard. Bug fixes: Fixed a bug, where "Used log space percentage" and "Used log space since last backup" did not show. 2.0.5 New: Virtual databases, e.g. Delphix databases, will now be marked with is_virtual = 1 in database views and dashboards. "replica_count" added to server views and dashboards. Changes: "availability_group_info" now reports info for asynchronous replicas. "Database sizes" on the Capacity dashboard will now only show current sizes. Views still contains historical data. 2.0.4 New: On the Capacity dashboard, it is now possible to see data usage and trends by department. New alerts: "Wrong default schema name" and "memory dump". Added last_memory_dump information to server views, dashboard and Database Finder. Bug fixes: External links on the Latest Stats dashboard did not work correctly. Fixed a bug where alerts were not triggered for: "Server role member added", "Database role member added" and "High row count change". 2.0.3 New: Upgraded to Grafana 11.1.4. Bug fixes: Fixed a bug where if a timeout occured during transferring of security data to historical tables, data could occur multiple times. 2.0.2 New: Added "Response time" to Overview 2 dashboard. Optimized performance in security views. Changes: last_execution_time for query- and procedure stats will now respect UTC time zone setting. Removed encryption from s_activity. TempDb graph on "Overview 2" dashboard now shows both internally allocated and task allocated tempdb usage. Bug fixes: Fixes a bug where the high CPU usage alert was not reported correctly. Changed some WMI queries to not use Linq, as there is a memory leak bug in the Linq assembly. 2.0.1 New: Upgraded to Grafana 11.1.0. Changes: Extended events handle duration is now included when determining if a server should get a timeout for "TotalCollectDuration". Timeout for extended events handle duration has been set to 60 seconds. Alerts for log-, diff- and full backups that are older than expected now excludes servers in timeout. Deadlock count will now include non-victims as well. When removing a database from and Availability Group and adding it again, the db_id will now be reused. last_execution_time for query- and procedure stats will now respect UTC time zone setting. Removed encryption from s_activity. TempDb graph on "Overview 2" dashboard now shows both internally allocated and task allocated tempdb usage. Bug fixes: Fixed a bug where data could be retrieved twice for sysadmins when querying views that could contain masked data. Fixed a bug where blocking information was not fetched for graphs for servers in timeout. Fixed a bug where historical data for security related changes could appear multiple times. 2.0.0 New: Major release. Performance Store is using its own time series functionality now, meaning Prometheus is no longer used. The Performance Store time series functionality is blazingly fast compared to Prometheus, while using far less memory and storage. Graphs are now 100 % accurate, whereas Prometheus, due to its pull nature, did have imprecise timestamps. Performance Store time series functionality contains Dynamic Resolution Scaling for graphs, so graphs will dynamically scale based on the shown time span. To upgrade: 1. Uninstall current version (no data will be lost) 2. Install new version 3. (Optional) Delete C:\Program Files\Performance Store\Prometheus* directories All graph data can now be queried from v_hist_* views. Teams will now have access to full graph history back in time, and not only from the time they got the access. User activity data can now be whitelisted on SQL Agent job name and/or job category. Filters on all columns on all Dashboards. Canonical name added to Server views and dashboards. Added request_status to Activity views and dashboards. Size change information will now be stored for 400 days (default). Added information about SAN, iSCSI, NVMe, SSD etc. to Capacity views and dashboards. Added information about who manually started and stopped SQL Agent jobs. Upgraded to Grafana 11.0.0. 1.0.38 New: Alert "Primary and secondary placed on same host" now supports a mix of physical- and virtual hosts. Increased general query performance. Upgraded to Grafana 10.3.5. Upgraded to Prometheus 2.51.1. Changes: Optimized performance when collecting unused index information. Teams will now have the default "Viewer" role in Grafana. Changed timeout for activity collection from 60 to 30 seconds. Bug fixes: When collecting unused index information, the number of user updates was not always correct. On the "Activity (current)" dashboard, clicking on a SQL Handle was not working. Fixed error where if the number of reads and writes exceeded the bigint datatype, an error would be thrown. Reported number of blocked processes was not always correct. When handling Agent job execution info, an internal error could occur on the first execution after a service restart. Corrected a bug where report for drive differences did not return anything. Corrected a bug where procedure- and query stats where not correct for a server after it came out of timeout. Corrected a bug where file latency stats where not correct for a server after it came out of timeout. 1.0.37 New: Performance optimizations when retrieving query plans and activity information. Upgraded to Prometheus 2.50.1. Changes: v_databases_all will no longer have discovered = 0 for databases where the server is in timeout. data_size_mb in dbo.databases has been changed to not nullable. 1.0.36 New: When adding access to servers for a team, non-production servers will now be added with access to sensistive data by default. Production servers will still have sensitive data masked by default. Increased query performance. Individual agent jobs can now be chosen on the "Agent jobs executions" dashboard. 1.0.35 New: Optimized audit fetch performance. Added is_cdc_enabled and is_read_only to database views and dashboards. Improved error messages in installer. New table, database_backup_time_whitelist, to exclude servers and/or databases from alerts related to if backups are older than expected. Changes: When calculating predictions for a table, the calculation date will now be the last date the table was seen. When a server is in quarantine, the visual graphs for the server will now not be shown. 1.0.34 New: New view: v_latest_agent_job_executions Changes: Agent job executions will now only be stored for 31 days (default). 1.0.33 New: Upgraded to Grafana 10.2.3. Upgraded to Prometheus 2.49.1. Optimized Agent job execution processing speed. New dashboard: Timeouts Changes: Changed default bulk operation batch size from 1000 to 100000. 1.0.32 New: user_activity_whitelist added to make it possible to filter out unwanted activity when calculating last_user_activity. Upgraded to Prometheus 2.48.1. Table access security implemented on capacity- and patch log dashboards and views. Will now handle AD-groups with circular references. Changes: db_id will now have support for multiple databases in the same AG. Removed information about default data- and log-drive from views and dashboards. 1.0.31 New: Added is_read_committed_snapshot_on, snapshot_isolation_state_desc and db_id to database views and dashboards. 1.0.30 New: Added new field base36_ag_id. base36_ag_id contains identical id numbers for database replicas. Added log_drive_letters and data_drive_letters to database views and dashboards. Upgraded to Prometheus 2.48.0. Upgraded to Grafana 10.2.2. New option to chose to only show production or non-production in the SQL Server Patch Manager. Bug fixes: Corrected bug where v_fileio_stats and v_performance_counters sometimes returned an empty result set. 1.0.29 New: Deadlock data is now stored for 400 days (default) instead of 30 days. 1.0.28 New: Server security views and dashboards now contains information about if the user's default database exists or not. 1.0.27 New: Optimized performance for all server-wide operations. 1.0.26 New: New column, audit_level, added to servers views and dashboard. Made support for empty monitor loops in blocking information. Bug fixes: Corrected bug where the SQL Server Patch Manager could not write log information for legacy cluster nodes. 1.0.25 New: New main dash board. Category added to alerts. Added is_trustworthy_on to database views and dashboards. Added is_auto_create_stats_incremental_on, has_backup_checksums, is_parameterization_forced and is_trustworthy_on to database differences calculations. Support for multiple secondary replicas in comparison engines. Upgraded to Grafana 10.2.0. Upgraded to Prometheus 2.47.2. Bug fixes: Corrected bug in SPN statement generation, where port numbers and instance names where a part of the server name. Corrected a bug in deadlock collection where in rare cases, a process can deadlock without a session_id. 1.0.24 New: New option to mask/unmask password hashes. Upgraded to Grafana 10.1.5. 1.0.23 New: CREATE statements now includes an IF NOT EXIST clause. Description now included on the v_ad_group_members and v_ad_group_members_recursive views. SPN creation statements added to v_servers, v_servers_all and servers dashboard. Stored procedures to show differences in security between servers now includes CREATE statements. 1.0.22 New: New columns to security objects: is_empty_group, is_empty_role, is_ineffective, sid_mismatch Upgraded to Prometheus 2.47.1. Changes: Changed the way procedure- and query statistics are collected. New parameters added to dbo.config: ProcedureStatsRetrieveMinutes and QueryStatsRetrieveMinutes, that indicates how many minutes back in the cache procedure- and query information should be retrieved. 1.0.21 New: Historical data is now available for deprecated servers and databases. Support for "indirect users". Indirect users are users that are created in the databases without a direct server login, but is still having access through a group on server-level. Upgraded to Grafana 10.1.4. Changes: "service_account' renamed to "sql_service_account". 1.0.20 New: Upgraded to Grafana 10.1.2. role_sid and parent_role_sid columns added to views and dashboards. has_securables column added to views and dashboards. is_disabled and is_schema_owner columns added to database security views and dashboards. "Description" field from AD users and groups are now included on user data. Total cores is now shown in the Performance Store Control Center. Changes: "hasaccess' renamed to "has_access". "denylogin' renamed to "deny_login". 1.0.19 New: Added Agent jobs history dashboards and views. Visually see job execution times, status, duration etc. Upgraded to Grafana 10.1.1. Upgraded to Prometheus 2.47.0. Added is_production, database_base36_id and is_disabled_on_server to v_database_security. Empty AD-groups are now included in security views and dashboards. Added client_app_name and statement to audit_extended_include and audit_extended_exclude. Added support for SSMS 2019 in Database Finder. Changes: Alerts will now conform to the time zone setting. Changed timeout for handling securables from 5 minutes to 10 minutes. Security policies now also applies to agent jobs. Free database space on the Capacity dashbboard now contains both free space in the data and the log file. When downloading deadlock graphs, query plans and live query plans, the filenames will now be unique. Bug fixes: Fixed bug where FQDN was not always populated. Fixed a bug where very large databases could cause an arithmetic overflow in v_database_sizes. Fixed a bug where blocked processes could be registered twice in certain scenarios. Fixed deadlock issue when collecting missing index information. Fixed an issue where UTC times would be calculated twice for failover history. Fixed a bug in Database Finder where setting a new default item would crash the application. 1.0.17 New: Added service account and agent service account info to server views and dashboards. Upgraded to Grafana 10.0.2. 1.0.16 New: Capacity information now includes information about unused data- and log space. Optimized performance for security objects. Changes: Version store- and persisted version store information has is moved from databases to activity sections. Database size information is now kept for 400 days instead of 30 days. 1.0.15 New: SQL Server Patch Manager support for legacy SQL Server clusters. Upgraded to Grafana 10.0.1. Upgraded to Prometheus 2.45.0. Enabled experimental support for Prometheus data source delta (incremental) querying. Improved Prometheus startup time. Added new column, legacy_cluster_nodes, to server views and dashboards. The column contains information about cluster names used for "virtual servers" in a legacy SQL Cluster configuration. Added version store- and persisted version store information to views, dashboards and Database Finder. Bug fixes: When multiple monitor loops occured between samples for blocked processes, they could be registered twice in the blockings alert. 1.0.14 Changes: operations_count in unused_indexes is changed from int to bigint. 1.0.13 New: Upgraded to Grafana 9.5.3. Changes: Complete rewrite of server, database- and securables data. Data now contains multidimensional inheritance. 1.0.12 New: Added socket information to server dashboard and views. Added s_activity procedure in the local management database. Upgraded to Grafana 9.5.2. Upgraded to Prometheus 2.44.0. Changes: Changed activity column "memory_usage_mb" to "session_memory_usage_mb". 1.0.11 New: New dashboard and view: v_securables. Upgraded to Grafana 9.5.1. Changes: Removed Create statements from the Database access and Server access dashboards. 1.0.10 New: It is now possible to filter on active unused- and missing indexes. Added connected_using_listener to user activity dashboard and views. If an operation completes after the given timer duration, the operation will start immediately again and not wait for the timer to kick in before starting the operation again. New view: v_execution_status_multiple, that contains information about internal operation durations. 1.0.9 Changes: Blocked sessions are now reported based on data from v_blockings and not v_activity_aggregated anymore. Table size information is now collected using bulk copy. 1.0.8 New: Heavy data retrieval operations now uses SQL Bulk Copy. A new option in the Performance Store Control Center, Bulk Copy Batch Size, can be used to control the batch size. Changes: Optimized alert discovery speed. 1.0.7 New: New alert "High row count changes". Alert will be raised if a production database has a table with more than 1 million rows, where an increase in rows of more than 20% has happened between samples. Bug fixes: Some activity statements were not captured if plan_handle was null. An error could occur if trying to insert server level alerts (e.g. "Data drive with incorrect cluster size") in dbo.stats, when the alert occured on multiple instances on the same server. When updating from a previous version, the installer might hang if one or more of the shared tools were open during the update. Custom stats could report wrong information after the Performance Store service was restarted. Wrong values in table size- and database size predictions. 1.0.6 New: Complete rewrite of the Performance Store service data access layer, resulting in near-zero plan recompilations. New view, v_user_activity, and "User activity" dashboard. New column, plan_affecting_convert_count, added to activity views and dashboards. The column will show number of warnings when a conversion (i.e. data type conversions) is affecting the plan. New column, has_backup_checksums, added to database views and dashboards. Category added to the memory dashboard. It is now possible to select specific tables on the "Table sizes" dashboard. Added predictions for rows, data usage and index usage to the "Table sizes" dashboard and in the new v_table_sizes view. It is now possible to show inactive access objects on the "Server access" and "Database access" dashboards. "last_user_activity" column added to the "Server access" and "Database access" dashboards. Upgraded to Grafana 9.4.7. Upgraded to Prometheus 2.43.0. Added query_hash and query_plan_hash to activity views and dashboards. Added timeout history to the "Latest stats" dashboard. Added is_parameterization_forced to database views and dashboards. Rewrite of the prediction engine. Predictions are now much faster. Changes: Statistics changes are no longer shown in "Changes" on visual dashboards. Increased performance on the "Table sizes" dashboard. Members of the sysadmin role will not have default access to views anymore. Query plans are now the full query plans for the whole batch and not for the individual statements anymore. When stopping Prometheus services, it will be gracefully shut down before the service stop. Bug fixes: Fixed a bug in Database Finder related to the new "single_use_plans_mb" column. Fixed a bug where an Availability Group failover did not throw an alert. Fixed a bug where statements where collected in the extended audit when no servers where added to the include-table. Fixed a bug where it was not possible to show latch stats for more than one server at a time. 1.0.5 New: Added latch statistics. New view: v_latch_stats and new dashboard: Latches. Added new license calculations for high availability- and disaster recovery replicas. Added filter on the statement column on the Errors dashboard. Added is_tempdb_metadata_memory_optimized to server views and dashboard. Added total_plans_mb and single_use_plans_mb to server views and dashboard. Changes: When calculating license information, license costs for Availability groups with secondary backups are now excluded unless diff backups are taken. Sample time on the Waits dashboard will noe adapt to the chosen time zone. License calculations will now include servers in quarantine. Bug fixes: Some unused- and missing index information did not survive a SQL Server service restart. Fixed bug where it was not always possible to perform a database upgrade from a previous version. Fixed a bug where it was not possible to uninstall a previous version from add/remove programs if it had been upgraded more than once. Fixed bug where the last 4 digits of plan_handle and sql_handle were missing. Fixed bug where performance counters where not always visible when querying v_performance_counters. 1.0.4 New: New table, errors_whitelist, to filter out unwanted error messages. Changes: Audit data is now stored for 400 days (default, but can be changed). Users logged into Grafana will now not be signed out automatically after a while. 1.0.3 New: New dashboard: Table sizes. See size info for each table and index. Differences between nodes in an Availability Group are now shown in Latest Stats. Upgraded to Grafana 9.3.4. Upgraded to Prometheus 2.42.0. Filter on client_hostname in Top Completed Queries. 1.0.2 New: Added a new state diagram on the "Failover history" dashboard, to quickly see when a replica was the primary replica. Upgraded to Prometheus 2.40.7. A bug in the previous Grafana version prevented changes to be shown visually on graphs. Upgraded to Grafana 9.3.2. Added "Total collect duration timoeut" value to the Control Center. If the total time for sampling a server is greater than the "Total collect duration timeout" value, the sampling will be marked as timed out. Added operations_count column to unused index information. The value is the sum of seeks, scans and lookups. Added workload group name to Activity views. Changes: Added data compression on dbo.database_access and dbo.server_access Optimized database information retrieval query. Timeout information now contains location information even if IgnoreLocation is set to true in dbo.config. Bug fixes: Fixed a bug where the Performance Store service account did not start during installation. Fixed a bug where some alerts where send for all servers instead of specific servers. 1.0.1 New: Added MaxQueryPlanLength to dbo.config: A limit for the maximum query plan retrieval length can now be set in dbo.config. Performance Store service must be restarted after changing this value. SQL Server Patch Manager will now report if the requested features may not be installed or features are already at a higher patch level. Upgraded to Grafana 9.2.6 Changes: Changed column names from tempdb_allocations_* to tempdb_session_allocations_* and tempdb_current_* to tempdb_task_allocations_* in v_activity, v_current_activity and v_activity_aggregated and on dashboards. Bug fixes: Fixed a bug in SQL Server Patch Manager where a log file could not be written for certain parallel operations. 1.0.0 Initial version.