Tag «sql trace»

SQL Trace causing error “The client was unable to reuse a session with SPID XXX”

We will open traces whenever a slow performing process needs to be pinpointed. We never experienced a high overhead until today. A couple of our production sites and services started to time out and SQL Server started login this errror: From: SQLAlerts [mailto:[email protected]] Sent: Monday, October 04, 2010 10:13 AM To: [email protected] Subject: SQL Server …