SQL Server 2014 Diagnostic Information Queries

 

  • Version : SQL Server 2014

 

SQL Server 2014 진단 쿼리 – 이 쿼리 한방이면 SQL 상태 확인 가능.

첨부파일 SQL Server 2014 Diagnostic Information Queries.txt 참고.

-- 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.

--*

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

 

 

[참고자료]

http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-december-2014/?utm_source=rss&utm_medium=rss&utm_campaign=sql-server-diagnostic-information-queries-for-december-2014

 





profile

강성욱 / jevida@naver.com
Microsoft SQL Server MVP
Blog : http://sqlmvp.kr
Facebook : http://facebook.com/sqlmvp

Kakao Talk : SQLMVP

Line : jevida


현재 LA에 거주하고 있으며 SQL에 관심있는 분이면 언제든 친추 환영합니다.