Search results
21 wrz 2023 · There are various causes for connectivity issues in SQL Server. This article series helps you troubleshoot the most common SQL Server connectivity issues and describes the tools and methods you can use for troubleshooting.
10 paź 2024 · Consult this MSSQL error code list to find explanations for error messages for SQL Server database engine events.
20 cze 2023 · Verify basic connectivity over IP address and check for any abnormalities: ping -a <SQL Server machine>, ping -a <SQL Server IP address>. If you notice any issues, work with your network administrator. Alternatively, you can use Test-NetConnection in PowerShell: $servername = "DestinationServer" Test-NetConnection -ComputerName $servername ...
9 mar 2023 · Get detailed explanations, causes, and user actions for the top 25 most common SQL Server Engine errors!
12 paź 2011 · Here's what I've done so far: Run SQL trace of long running queries and deadlocks. This shows no deadlocks at the times of the problems, and long running queries all coincide with our timeout errors, but look to be a side effect, and not the cause.
16 mar 2022 · This blog provides TSQL samples for troubleshooting common SQL Server issues as listed below. You can modify the parameters (i.e. database name, table name, keyword name, duration, etc.) based on customized environment settings and requirements.
13 mar 2014 · To find out what’s happening with your SQL Server, start with monitoring databases, watch the performance metrics over time to create baselines and trend lines for normal operation, isolate the processes that use a lot of resources.