반응형

SQL Server 2008R2 Diagnostic Information Queries

 

  • Version : SQL Server 2008R2

 

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

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

-- SQL Server 2008 R2 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

-- 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, sql2008R2, sql 분석, DB 분석, DB 진단, DB튜닝, SQL Health Check, DBA

 

 

반응형

+ Recent posts