-- SQL Server 2014 Diagnostic Information Queries

-- Glenn Berry

-- December 2014

-- Last Modified: December 18, 2014

-- http://sqlserverperformance.wordpress.com/

-- http://sqlskills.com/blogs/glenn/

-- Twitter: GlennAlanBerry

-- Please listen to my Pluralsight courses

-- http://www.pluralsight.com/author/glenn-berry

-- Many of these queries will not work if you have databases in 80 compatibility mode

-- This should not be an issue in SQL Server 2014, since 80 compatibility mode is not supported

-- Please make sure you are using the correct version of these diagnostic queries for your version of SQL Server

--******************************************************************************

--* Copyright (C) 2014 Glenn Berry, SQLskills.com

--* All rights reserved.

--*

--* For more scripts and sample code, check out

--* http://sqlskills.com/blogs/glenn

--*

--* You may alter this code for your own *non-commercial* purposes. You may

--* republish altered code as long as you include this copyright and give due credit.

--*

--*

--* THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF

--* ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED

--* TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A

--* PARTICULAR PURPOSE.

--*

--******************************************************************************