SQL lag issues
Posted on 2013-01-11
I'm currently experiencing a massive issue within our Environment. On Saturday I physically moved servers one by one. The "move" was roughly 4-7 feet total, however now when a query is ran from a workstation back to the server we are seeing delays of over 20 seconds. Here's the kicker, it afflicts random users. One user will have zero issues for hours, while the other is dead in the water. It can all change on the fly though, there's no specific time frame in which a user will be up and running.
List of steps already taken:
Repaired all the Databases including master and temp.
Truncated log files, as I did have one that was over 19gb.
Swapped ports and switches for all servers concerned, as well as some workstations. (I have verified we do not have a Layer 2 Loop).
Verified VSS wasn't enabled on Symantec System Restore 2010, and then uninstalled the component completely.
Disabled AV on the server, issue still persisted a hour after disabling.
Ping tests to our primary SQL server is consistent without packet loss.
Ran a few SQL traces through the SQL Server Profiler tool.
-I did find some of the query's that are taking an incredibly long time from the workstations, but it doesn't appear to be any one particular query.
Query's ran on the server itself are near instant
Got with the manufacturer of the company who installed and supports our Application (Infor's Visual). They pointed to a network issue, but couldn't find anything saying it was a network issue, somewhere. The call resolved with having him saying he will check around and see if anyone else has seen the issue. While I do believe there maybe a network issue I have nothing to go on to determine what to fix.
I do have a spare gig switch that is being delivered today to eliminate the possibility of network overload, but I'm grasping at straws currently.