- lastwaittype frequently beocmes SOS_SCHEDULER_YIELD in SQL server 2008 R2
- SELECT 'SQL Server '
- + CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
- + CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
- + CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'