Why is everyone classified in the internal workgroup?

A PFE colleague recently posted a question describing what seemed like a weird and unexpected situation he observed while he was onsite in one customer. From SQL Server Management Studio, every single entry in the Processes section of the Activity Monitor showed as being classified as the “internal” in the “Workload Group” column, just like…

0

sys.dm_exec_requests showing negative values for total_elapsed_time, wait_time, or any other column it exposes as an integer (int) data type

In the case of that DMV (and probably in many other) the problem is that the internal value which populates the column (total_elapsed_time, or open_transaction_count, or open_resultset_count for that matter) is returned as a ULONG (32bit unsigned integer covering a range of values spanning 0 to 4294967295 decimal.) However, the GetRow method of the internal…

3

Microsoft SQL Server 2008 R2 Best Practice Analyzer fails with “Engine – Login does not exist or is not a member of the System Administrator role”

If the Windows account you are using for SQL BPA to connect and analyze an instance of SQL Server Database Engine doesn’t have an individual login created in the instance and that login is a member of the System Administrator server role, you will get that error, even if the login has been made a…

0

Do the 10GB DB size limit in SQL Server Express SKUs also apply to TempDB?

No, it doesn’t. The CheckSize function from the file manager class, which is called when a file is grown or shrinked skips checking for the limits imposed by the SKU when the file correspond to the master, tempdb, or model system databases. For further information about the “Maximum Relational Database Size” limit imposed by every…

0