ASYNC_NETWORK_IO or NETWORK_IO

What is ASYNC_NETWORK_IO  or  NETWORK_IO ? When a query is fired, SQL Server produces the the results ,place it in output buffer and send it to client/Application. Client/Application then fetch the result from the Output buffer, process data  and send acknowledgement to SQL Server. If client/Application takes long time to send acknowledgement then SQL Server…


Unable to open large profiler trace files

Profiler filling up space of my system drive……. When you run the profiler trace (GUI) or open the saved profiler trace file your System Drive gets out of space SQL Server profile uses ‘TMP’ Environment variable for storing the .Trc and trace replay files   By default TMP directory points to your system drive, so…

1

The process cannot access the file ‘C:Windowssystem32perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll’ because it is being used by another process.

  SQL Server CU’s update fails with error “ScoException: The process cannot access the file ‘C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll’ because it is being used by another process. —> System.IO.IOException: The process cannot access the file ‘C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll’ because it is being used by another process. ”   In Detail.txt you will find errors like one listed below Sco: Attempting…

1