sql trace

SQL Server

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:SQLAlerts@xyz.com] Sent: Monday, October 04, 2010 10:13 AM To: dba@xyz.com Subject: SQL Server […]

Read More