SQL Server tools - HxGN SDx - Update 63 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language
English
Product
HxGN SDx
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
10

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.