Tuesday, August 18, 2015

Outage with Network in SQL Server

We had a small outage today  and tried to look at
1.SQL server logs
2.Event Viewer
3.Any jobs running ?
4.any blocking or deadlocks happened?

the possible outage could be due to
I  was trying to Move 50-70GB .trc files from Production F drive to a local computer or shared drive and that eaten up lot of network bandwidth and caused slow network and few customers got outage for a quick minute .



so, be careful while moving the files from production to a Shared /slow drives outside the network.



No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...