News

When you encounter the “Network-related or instance-specific error” in SQL Server, it usually happens when trying to connect to a database, and the connection ...
Use SQL Server Profiler to: Monitor the performance of an instance of the Analysis Services engine. Debug query statements. Identify queries that run slowly. Test query statements in the development ...
You will fail to connect to your database if the SQL Server service is not running. If you try running the SQL Server service from the Services.msc app, you will ...
instance-name>:Wait Statistics(Waits in progress)\Lock waits <instance-name>:Wait Statistics(Waits in progress)\Log write waits Download the SQL-Server-IO-Pressure-Check.xml file onto the server ...
As part of general monitoring of Dynamics AX overall system health and/or troubleshooting, you’ll want to check the Windows event logs in your AOS server(s) and SQL ...