How It Works: SQL Server Engine Error Messages

The Senior Escalation Engineers do various training and mentoring activities.  As I do this I thought I would try to propagate some of this information on the blog. The majority of SQL Server errors are handled by a central routine named ex_raise.   The routine takes a MAJOR and a MINOR identifier along with the severity,…

1

How It Works: System Sessions

The Senior Escalation Engineers do various training and mentoring activities.  As I do this I thought I would try to propagate some of this information on the blog. Looking at a SQL Server error log it is formatted with the date, time and session identifier.   Many of the identifiers contain the s following the spid…

2

SQL Server Urban Legends Discussed

I have been answering questions on two of the most misunderstood ‘SQL Server Urban Legends’ frequently again so I decided to make a post about them. ·         SQL Server Uses One Thread Per Data File ·         A Disk Queue Length greater than 2 indicates an I/O bottleneck SQL Server Uses One Thread Per Data File…

19