Why Resource Governor Ignores Your SQL Server Agent Job Owner

· by · in

You did everything right. Resource Governor is configured, you have a workload group that caps CPU and memory so one runaway job cannot starve everything else, and you have a classifier function that reads the…

SQL Server Trace Flags

· by · in

Maintaining an up-to-date list of SQL Server Trace Flags is time consuming, and difficult since the majority are undocumented. Aaron over at SQLCrossJoin.wordpress.com maintains an incredibly detailed and comprehensive list of trace flags at https://sqlcrossjoin.wordpress.com/category/trace-flags/….