SQL Server 2014 Diagnostic Information Queries

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

 

 

2014-12-30 / 강성욱 / http://sqlmvp.kr

 

Sqlserver, mssql, sql2014, sql 분석, DB 분석, DB 진단, DB튜닝, SQL Health Check, DBA