SQL Nexus 5.5.0.1 was released

We just released SQL Nexus 5.5.0.1 on codeplex.   In addition to numerous ‘rules’ that catch issues that can potentially impact your SQL Server performance, we added quite a few reports.  Some of the reports are displayed below. The following three were born out of troubleshooting experience. “Top 20 Active CPU Intensive Queries”:  When troubleshooting CPU…

1

Unable to drop a user in a database

A user called in for help because he wasn’t able to drop a user from a database.  The error message is below Msg 15136, Level 16, State 1, Line 2The database principal is set as the execution context of one or more procedures, functions, or event notifications and cannot be dropped. From the error, the…

2