VPS
Quickly find long running queries and determine what’s taking so long
Today’s question is: How can I quickly find the longest running query and determine why it’s taking so long? In this video we’ll discover one of the ways we can use the Vroom Performance Suite to quickly locate a long running query, then drill in to see where its spending its time.
Read MoreWhat is VPS?
VPS is the Vroom Performance Suite Simply put, VPS is a performance monitoring, tuning and alerting tool for Windows, SQL Server, VMWare and IIS. VPS was conceptualized and built out of necessity as tools that exist in this ecosystem lack various features that simply the daily life of Database Administrators, Systems Engineers and Developers. We…
Read MoreVPS Change Log 1.0.8.4
Added WMI encryption, which defaults to enabled. Replaced threading model for more efficient and secure utilization of security tokens. Added full Windows fail-over cluster awareness. Added full SQL Server fail-over cluster awareness. Added full VMWare ESXi vSphere integration Datacenters, hosts and VMWare clusters are automatically added to monitoring. VMs and Virtual Disks are automatically added…
Read MoreInstall VPS in Workgroup Environment
Installing VPS on any server is a pretty straight forward process – and installing on a workgroup is no different. Active Directory domains are recommended for larger environments because they benefit from the centralized security management – but many website setups or corporate ERP packages rely on dedicated walled off sets of systems that may…
Read MoreVPS Change Log 1.0.8.3
Features Added explicit support for Windows Workgroups (non-active directory installations). Added ability to modify entity attributes via UI. Added default date to real-time query drill through. Added SQL-authentication support for meta-base database in monolithic installer. Issues Added service termination upon invalid configuration. This is to ensure that a faulty start doesn’t appear to function correctly.…
Read MoreVPS Change Log 1.0.8.2
SQL Server Database Collection Added option to ignore read-only databases. Added attribute to allow for ignoring individual databases on a per instance level. SQL Server Sessions Added new plan explorer to breakdown each statement of an observed batch. Fixes Resolved issue that caused VPS to not collect some metrics when a database permission is lacking.…
Read MoreVPS Change Log 1.0.8.1
Installer Reworked certificate generation methods. Physical Disk Collections Added trilevel checks for HDD health to allow alerts to reliably detect failing physical disk drives. UI Misc. Altered the way in which the last selected Server/SQL Instance maintained from one dashboard to the next. Real-Time Dashboard. Changed disk performance metrics. Now displays bytes instead of IOPS.…
Read MoreVPS Change Log 1.0.8.0
Alerting Added occurrence date to the available deadlock alert fields. Added date-time formatting for all alerts. This allows VPS to use dates/times in alert identifiers and conditions. Removed SQL Server Blocks alert category, it was made redundant with this update. (All block alerting is still available). SQL Server Query Observations Added the collection of additional…
Read MoreVPS Change Log 1.0.7.3
Blocked Processes Added cached collection and interpretation of SQL Server Agent job names. Notable Query Added default Query checksum for binary zero hashes. This will prevent the grouping of queries which are not alike such as ROW FETCH operations. Added advanced option [Use Actuals when Deltas Are Unavailable] which allows for collection of single run…
Read MoreVPS Change Log 1.0.7.2
Alerts Reworked Alert Field Identifiers so that they are included in real-time emails (in addition to UI). Added configurable “Days to Observe Average Utilization for Alerts” to allow for custom alerting threshold. SQL Notable Queries Added “cumulative notable query” collection in addition to “per-execution notable query” collection. Added fallback to “original login name” when current…
Read More