Connections to TempDB
With a team of 6 using source control, we are finding the performance of both SSMS on individual machines and our developement SQL box to be crippled by Source control.
Our developement server is showing literally hundreds of connections to TempDB from Sql source Control which is slowing the box considerably
4
votes
Stuart Davis
shared this idea
-
Jason Crider
commented
We have added that node and we still see the tempdb growing over 5GB in most cases as SSMS is left open. Is there another way to keep it from eating up the tempdb on the server?
-
Aleksandar
commented
While not the greatest work around, turning polling off or severely reducing polling frequency will help quite a bit. See here: