2012.11.28

SQL

• DBCC CHECKDB Parallel Checks and SQL Server Edition
  http://www.sqlskills.com/blogs/erin/post/DBCC-CHECKDB-Parallel-Checks-and-SQL-Server-Edition.aspx

  Standard Edition에서 DBCC CHECKDB는 항상 단일 쓰레드로 검사 수행. Enterprise Editio에서는 max dop의 구성에 따라 영향 받는다.

     

• SQL Server vNext coming up with lot a new features | Hekaton, Polybase, PDW, and many more

  http://sqlwithmanoj.wordpress.com/2012/11/27/sql-server-vnext-coming-up-with-lot-a-new-features-hekaton-polybase-pdw-and-many-more/

  SQL2012 버전과 향후 버젼에 대한 대략적인 소개이네요. 2014~2015년도 사이에 Hekaton과 polybase 출시 예정,

     

• Unused Indexes
  http://sqlserver365.blogspot.kr/2012/11/unused-indexes.html
  사용되지 않은 인덱스 판별은 sys.dm_db_index_usage_stats DMV를 이용해서 where the user_seeks + user_scans + user_lookups = 0 의 결과로 알아볼 수 있다. System database를 제외한 사용자 db를 대상으로 인덱스 사용 현황을 매일 아침에 메일로 보내는 script를 확인할 수 있다.

     

• Performance Problems with SQL Server 2012 Enterprise Edition Under CAL Licensing
  http://www.sqlperformance.com/2012/11/system-configuration/2012-cal-problems
   
• SQL Server T-SQL Tuning -TVF and Scalar Functions
  http://www.sql-server-performance.com/2012/sql-tuning-tvf-scalar-functions/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+SQLServerPerformance+%28Latest+SQL-Server-Performance.com+Updates%29
   
• Back to Basics: Capturing Baselines on Production SQL Servers
  http://www.sqlservercentral.com/articles/baselines/94656/

     

• How to Set SQL Server Max Memory for VMware
  http://www.brentozar.com/archive/2012/11/how-to-set-sql-server-max-memory-for-vmware/
  VMWare에서 SQL Server 메모리 사용하기 위해서는 확인해야 할게 많은데, guest's memory, sql server memory, vmware reservation 고려해야 한다. 요즘 대세가 VMWare 이니~ 고려해야 할게 많네요.
   

  

     

     

• Understanding the SQL Server 2012 BI Semantic Model (BISM)

  http://www.mssqltips.com/sqlservertip/2818/understanding-the-sql-server-2012-bi-semantic-model-bism/
   

• SQL SERVER – Shard No More – An Innovative Look at Distributed Peer-to-peer SQL Database
  http://blog.sqlauthority.com/2012/11/27/sql-server-shard-no-more-an-innovative-look-at-distributed-peer-to-peer-sql-database/

     

Cloud & BigData

• Crutchfield Turns to Microsoft and EMC to Help Transform SQL Server to the Private Cloud

  http://blogs.technet.com/b/dataplatforminsider/archive/2012/11/27/crutchfield-turns-to-microsoft-and-emc-to-help-transform-sql-server-to-the-private-cloud.aspx

     

• Windows Azure Virtual Machines - Make Sure You Follow the Documentation

  http://sqlblog.com/blogs/buck_woody/archive/2012/11/27/windows-azure-virtual-machines-make-sure-you-follow-the-documentation.aspx

     

• Windows Azure Update 2012년 11월 – SQL Azure
  http://redju.tistory.com/248