How It Works: What is behind the SQLCLR wait category in SQL Server 2008 Activity Monitor
First published on MSDN on Dec 02, 2008 I was asked a question as the CSS First Aid Station at SQL PASS 2008 where the Activity Monitor kept showing the SQLCLR wait category as the top waiter, even when no other activity was going on.Service status watcher in SQL Server Management Studio – How it works
First published on MSDN on Aug 21, 2013 Have you ever wondered about the mechanism using which SQL Server Management Studio(SSMS) - Object Explorer shows the service status for SQL Server and SQL Agent service? We recently worked with a customer on a issue related to this and thought that this might be useful information to share out.
