Visual Studio debugging with production database

Chieko Jurkus 1 Reputation point

Recently, a website that was working fine up until one day it started returning an exception for "Execution Timeout Expired" when trying to retrieve information from our production database. Our UAT environment with the exact same data did not return any exceptions when retrieving the exact same data. When I told our database architect that I had used the visual studio 2015 (vs) debugger with production database, he informed me that I should not run the vs debugger with the production database because visual studio attaches "hooks" and other things to the database that make the database run even slower. The solution to our problem was to restart the sql server and the file server that is reside on. But, I would like to know what exactly is visual studio doing to the sql server database to make the database performance bad?
Thank you,
Chieko Jurkus

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,869 questions
{count} votes