SQL Server tools - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

These tools are available as part of your SQL Server database product installation. Refer to SQL Server documentation for information about these products.

  • SQL Profiler - Generates trace results that show how a query is submitted to the server and how the result set is returned. You can interpret the trace results or run the results through the Tuning Advisor for recommendations.

  • Activity Monitor and Reports - Monitors SQL Server real-time resource usage, sessions, wait times, as well as recent and active expensive queries. Furthermore, SQL Server provides server and database-level reports that can give diagnostic-level information.