http://blogs.msdn.com/b/psssql/archive/2013/08/13/how-it-works-sql-server-2012-database-engine-task-scheduling.aspx

SQL Server 2012 EE SKU

Starting with SQL Server 2012 EE SKU the behavior changes for a new task  (Batch, RPC, Disconnect, …) only after the connection has been established and pool assignment made.   (No connection no preferred scheduler yet!)

Note: Even if the RG is disabled the DEFAULT pool is used internally.  

구글 번역

SQL 서버 2012 EE SKU 연결이 설정되고 풀 할당 한 후에 만 새 작업의 동작 변경 (배치, RPC, 연결 끊기, ...)로 시작 -

http://blogs.msdn.com/b/psssql/archive/2013/03/19/sql-server-2012-partitioned-table-statistics-update-behavior-change-when-rebuilding-index.aspx

If a table is partitioned, ALTER INDEX REBUILD will only update statistics for that index with default sampling rate.  In other words, it is no longer a FULLSCAN.  This is documented in http://technet.microsoft.com/en-us/library/ms188388.aspx.  But lots of users do not realized that.  If you want fullscan, you will need to run UPDATE STATISTCS WITH FULLSCAN.   This change was made because we started to support large number of partitions up to 15000 by default.

Free ebook 정보가 올라왔네요^^ 빨간색 책들을 제외하고는 모두 sample 용도로 한개에서 두개정도면 올라왔네요.. 나머지는 돈 주고 사야죠 머~~

http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more.aspx

Moving to Microsoft Visual Studio 2010  VS2005 PDF  VS2005 XPS  VS2008 PDF  VS2008 XPS	Programming Windows 8 Apps  PDF	Managing SQL Servers and Policy-Based Management
	Introducing Windows Server 2012  PDF  EPUB  MOBI	Introducing Microsoft SQL Server 2012  PDF  EPUB  MOBI	Introducing Microsoft SQL Server 2008 R2  PDF  XPS
SQL Server 2012 Tutorials: Analysis Services - Tabular Modeling  PDF  EPUB  MOBI	Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery  PDF  EPUB  MOBI	Transact-SQL Data Manipulation Language (DML) Reference  PDF  EPUB  MOBI	QuickStart: Learn DAX Basics in 30 Minutes   PDF  EPUB  MOBI
SQL Server 2012 Tutorials: Analysis Services - Data Mining  PDF  EPUB  MOBI	Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide  PDF  EPUB  MOBI	Data Analysis Expressions (DAX) Reference  PDF  EPUB  MOBI	SQL Server 2012 Upgrade Technical Guide PDF  EPUB  MOBI
Backup and Restore of SQL Server Databases   PDF  EPUB  MOBI	SQL Server 2012 Tutorials: Analysis Services - Multidimensional Modeling  PDF  EPUB  MOBI	Master Data Services Capacity Guidelines   PDF  EPUB  MOBI

원본문서 : http://msdn.microsoft.com/en-us/library/jj573256

Resource Governor in SQL Server 2012 Word document.

The Resource Governor feature allows you to set limits on the amount of memory and CPU resources incoming requests can use, and it provides a way to isolate and limit runaway queries, adding fine-grained resource tracking for chargeback and delivering predictable performance

SQL Server 2012 supports up to 62 user-definable pools

 Resource Governor in SQL Server 2012.docx

"변경된 SQL2012의 메모리 관리" 드뎌 올라왔다.

1. memory counters as "kb"

2. any-size page allocator

3. central role of the redesigned Memory Manager

어디보자. 다시 익히려면 애좀 먹겠군. ㅠㅠ

http://blogs.msdn.com/b/sqlosteam/archive/2012/07/11/memory-manager-surface-area-changes-in-sql-server-2012.aspx

http://blogs.msdn.com/b/sqlosteam/archive/2012/07/12/memory-manager-configuration-changes-in-sql-server-2012.aspx

Memory Manager

Max server memory

DWA : direct Windows allocations

SQL Server 2012

안녕하세요. 주디아줌마입니다.

SQL의 대기 유형 타입은 SQL2005, 2008 수천가지가 있습니다. SQL2012에는 169개가 추가적으로 대기 유형 정보를 확인할 수 있습니다.

아래의 링크 정보에서 대기 유형 정보를 확인할 수 있습니다.

공부를 해야겠죵? ㅠㅠㅠ

http://msdn.microsoft.com/en-us/library/ms179984.aspx 

select wait_type from sys.dm_os_wait_stats order by wait_type asc;

(원본) http://www.confio.com/db-resources/sql-wait-types/

Wait Type Reference Articles

• WRITELOG
• OLEDB
• PAGEIOLATCH_EX
• CXPACKET
• ASYNC Network IO
• SQL Server sp_addmessage System Stored Procedure
• SQL Server SOS_SCHEDULER_YIELD Wait Type
• SQL Server NETWORKIO Wait Type
• SQL Server DBCC LOG Command
• SQL Server Buffer Cache Hit Ratio
• SQL Server DTC Wait Type

안녕하세요. 주디아줌마입니다.

SQL2012 11.0.2325 버전을 사용중입니다.  SQL 개체 스크립팅을 사용하려고 했는데 그중 특정 옵션만 활성화만 시키게 되면 저장프로시져 Script의 주석문 및 Script 정보가 변경되어 있는 것을 확인하였습니다.

테스트 방법 

도구>옵션>SQL Server 개체 탐색기>스크립트>테이블 및 뷰 옵션

"사용자 정의 데이터 형식을 기본 형식"를 enable하게 되면 저장프로시져의 주석문이안 나오는 문제가 있습니다. 이것이 버그일까요? 

1.  아래의 옵션을 활성화 하였습니다.

2. 테스트 하려는 프로시져를 생성하고 저장된 정보를 확인 한다.

3. 프로시져를 선택하여 수정하기를 했을 때 스크립트된 결과

    - 주석문이 제거 됨.

    - WITH EXECUTE AS CALLER 옵션 추가

SQL2012 메모리 사이즈 정책 관련 자료가 올라왔네요.

http://blogs.msdn.com/b/sqlosteam/archive/2012/06/20/sql-server-2012-memory-manager-kb-articles.aspx

How has memory sizing changed in SQL 2012?

2663912 Memory configuration and sizing considerations in SQL Server 2012 -http://support.microsoft.com/default.aspx?scid=kb;EN-US;2663912  

Setting "locked pages" to avoid SQL Server memory pages getting swapped has been simplified, particularly for Standard Edition, the details can be found here:

2659143 How to enable the "locked pages" feature in SQL Server 2012 - http://support.microsoft.com/default.aspx?scid=kb;EN-US;2659143

Note the following deprecation (particularly relevant for 32-bit installations):

2644592 The "AWE enabled" SQL Server feature is deprecated - http://support.microsoft.com/default.aspx?scid=kb;EN-US;2644592 

(AWE Enable하는 옵션이 완전 없어졌군요.)

Note the following fixes available:

2708594 FIX: Locked page allocations are enabled without any warning after you upgrade to SQL Server 2012 -http://support.microsoft.com/kb/2708594/EN-US

2688697 FIX: Out-of-memory error when you run an instance of SQL Server 2012 on a computer that uses NUMA -http://support.microsoft.com/kb/2688697/EN-US

SQL Server Max Memory Myths Video
http://www.brentozar.com/archive/2012/06/sql-server-max-memory-myths-video/

SQL2012 upgrade 되면서 메모리 관리 아키텍쳐가 변경되었다.  이제는 어떻게 메모리 설정하는게 좋을까? 고민되네~~

- 읽어볼 내용들

http://blog.beyondrelational.com/modules/24/syndicated/389/Posts/13492/any-size-page-allocator-memory-allocation-changes-with-sql-2012.aspx

http://sqlskills.com/blogs/jonathan/post/How-much-memory-does-my-SQL-Server-actually-need.aspx

http://sqlblog.com/blogs/tibor_karaszi/archive/2014/03/06/setting-max-server-memory.aspx  -- 최대 메모리 설정 쿼리

- Memory Manager Redesign:

Predictable sizing and governing SQL memory consumption:

sp_configure ‘max server memory’ now limits all memory committed by SQL Server
Resource Governor governs all SQL memory consumption (other than special cases like buffer pool)

Improved scalability of complex queries and operations that make >8K allocations

Improved CPU and NUMA locality for memory accesses

Single memory manager that handles page allocations of all sizes

Consistent Out-of-memory handling & management across different internal components

SQL2012 이전 버젼에서 Max memory 관련 설정 할때 나름 공식이 있었는데 이부분이 변경되었다고 하니, 새로운 공식을 만들어야겠네요. 좀더 자세히 정리해보아야겠습니다.

sys.dm_os_memory_clerks system view에서 multi_pages_kb으 열이 제거되었습니다. 

Glenn Berry's 

Suggested Max Memory Settings for SQL Server 2005/2008

http://www.sqlservercentral.com/blogs/glennberry/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008/

SQL TAG

http://cafe.naver.com/sqlmvp/600

Cool... Now we have a calculator for finding out a Max. Server Memory value

http://www.texastoo.com/post/2012/05/20/Best-of-MSDN-Blogs%E2%80%93Calculator-for-finding-out-a-Max-Server-Memory-value.aspx

http://blogs.msdn.com/b/sqlsakthi/archive/2012/05/19/cool-now-we-have-a-calculator-for-finding-out-a-max-server-memory-value.aspx

http://blogs.msdn.com/b/sqlsakthi/p/max-server-memory-calculator.aspx

안녕하세요. 주디아줌마입니다.
SQL2012 관련 샘플 DB를 등록해봅시다.^^

※.링크

http://www.mssqltips.com/sqlservertip/2638/attach-sample-database--adventureworks-in-sql-server-2012/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=2012513

※.다운로드 
AdventureWorks2012_Data.mdf for case-insensitive collation
AdventureWorks2012CSData.mdf for case-sensitive collation 

CREATE DATABASE AdventureWorks2012_Data
ON (FILENAME = N'E:\SQLData\AdventureWorks2012_Data.mdf')
FOR ATTACH_REBUILD_LOG 
Go

추가 테스트 환경 설정

※. 테스트를 위해서 adventureworks db를 크게 만드는 script.. by adam download
http://sqlblog.com/blogs/adam_machanic/archive/2011/10/17/thinking-big-adventure.aspx

※. Enlarging the AdventureWorks Sample Databases - Jonathan Kehayias
http://www.sqlskills.com/blogs/jonathan/enlarging-the-adventureworks-sample-databases/

※. Adventureworks2012, Adventureworks2012DW, pubs, Northwind
http://www.sqlpanda.com/2013/09/sql-server-2012-sample-database.html