Check in lag troubleshooting

We have some solidworks file that takes quite some time to checkin.
I discovered a network misconfiguration that caused the traffic to slow down a lot, and that improved “get latest” a lot, close to saturate our network available bandwidth, but sometimes checkins are still sluggish, it seems to affect some old assemblies and the problem is not network related: apparently the traffic from the workstation is like some kbps not even close to megabit class. This leads me to think that the client machine is basically waiting for the SQL server before sending the file to the archive and I would like to try and troubleshoot what is the root cause of it.

I know it is going to be a quite broad topic, but any advice on where to start?
Or what to look at as a possible test workflow?

You can run traces on the SQL server that will tell you exactly how much time is being spent in each stored procedure.

If a particular stored procedure is at fault, you can search for its name in the Knowledge Base and it will sometimes have a cause and fix.

3 Likes