'분류 전체보기'에 해당되는 글 684건

  1. 필터링 된 인덱스 예외 케이스
  2. [펌] Why ROWLOCK Hints Can Make Queries Slower and Blocking Worse in SQL Server
  3. slient install sql server 2016 SSMS
  4. Live Query Statistics - SQL Server 2016 new feature (4)
  5. SQL Server 2016 Community Technology Preview 2 Evaluations
  6. VLF 생성 알고리즘 변경 SQL2014 이후 버젼 (1)
  7. 2014.12.05
  8. SQLTest
  9. sp_whopro ~~
  10. sqltag book 2

SQL Server에서는 IS NULL 조건자와 함께 작성 하는 필터링 된 인덱스를 사용 하지 않습니다. 필터드 인덱스 사용시 IS NULL 조건자의 경우 include에 컬럼 추가되어야 함

https://support.microsoft.com/ko-kr/help/3051225/a-filtered-index-that-you-create-together-with-the-is-null-predicate-i

예) 필터드 인덱스 조건 중 IS NULL의 경우 include 컬럼 항목

CREATE NONCLUSTERED INDEX New_i_action_filt_action_date_type ON dbo.filter_test (action_type) include (action_date) WHERE action_date IS NULL


LOCK_ESCALATION Disable 이슈 및 RowLock 힌트로 인한 슬로우 쿼리 발생 가능.
https://www.littlekendra.com/2016/02/04/why-rowlock-hints-can-make-queries-slower-and-blocking-worse-in-sql-server/




https://svenaelterman.wordpress.com/2016/05/23/performing-a-silent-install-of-sql-server-management-studio-2016/


SQL2016 SSMS 한방에 설치하기^^ 


SSMS-Setup-KOR.exe /install /passive /quiet /norestart


Because this data is available in real time without needing to wait for the query to complete, these execution statistics are extremely useful for debugging query performance issues.

https://msdn.microsoft.com/en-us/library/dn831878(v=sql.130).aspx

Live Query Stats button in showplan


SQL Server 2016 Community Technology Preview 2 Evaluations

새로운 버젼이 나왔네요...
2014 버젼도 쓰지 않은데, 2016버젼까지 나왔으니... 에휴에휴 



As the biggest leap forward in Microsoft’s data platform history, SQL Server 2016 delivers breakthrough mission critical performance, deeper insights across any data on many devices and enables the power of hyperscale cloud to unlock new hybrid scenarios.

• Operational Analytics: Insights on operational data, works with in-memory OLTP or on disk 

• In-memory OLTP enhancements: Greater T-SQL surface area, terabytes of memory supported and greater number of parallel CPUs

• Query Data Store: Monitor and optimize query plans with full history of query execution 

• Native JSON: Parsing & storing of JSON as relational data & exporting relational data to JSON 

• Temporal Database: Track historical changes 

https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016
https://www.microsoft.com/en-us/server-cloud/products/sql-server-2016/


http://www.sqlskills.com/blogs/paul/important-change-vlf-creation-algorithm-sql-server-2014/


For SQL Server 2014, the algorithm is now:

  • Is the growth size less than 1/8 the size of the log?
  • Yes: create 1 new VLF equal to the growth size
  • No: use the formula above

So on SQL Server 2014, if you created your log at 1GB and it auto-grow in chunks of 512 MB to 200 GB, you’d have:

  • 16 VLFs from the initial log creation
  • All growths up to the log being 4.5 GB would use the formula, so growths at 1, 1.5, 2, 2.5, 3, 3.5, 4 GB would each add 8 VLFs * = 56 VLFs
  • All growths over 4 GB will only create 1 VLF per growth = (200 – 4) x 2 = 392 VLFs
  • Total = 392 + 56 + 16 = 464 VLFs

464 is a much more reasonable number of VLFs than 3200, and will be far less of a performance problem.

2014.12.05


RAMESH MEYYAPPAN님의 최신 블로깅 내용 

Slow performance due to SQL Server 2014 Buffer Pool Extension (BPE) and serial queries (MAXDOP 1)
http://blog.sqlworkshops.com/slow-performance-due-to-sql-server-2014-buffer-pool-extension-bpe-and-serial-queries-maxdop-1/


NUMA remote (foreign) memory access overhead on Windows, SQL Server and In-Memory OLTP
http://blog.sqlworkshops.com/slow-performance-due-to-sql-server-2014-buffer-pool-extension-bpe-and-serial-queries-maxdop-1/

'SQLTAG Daily Links' 카테고리의 다른 글

2014.12.05  (0) 2014.12.05
sqltag book 2  (0) 2014.10.21
2014.05.27  (0) 2014.05.27
2014.05.26  (0) 2014.05.26
2014.05.22  (0) 2014.05.22
2014.05.21  (0) 2014.05.21

SQLTest


SQLTest (SQLWorkshops)
http://www.sqltest.org/ 


다운로드 : http://www.sqltest.org/Download
동영상 : http://www.sqlvideo.com/SQLTest


'Tool' 카테고리의 다른 글

SQLTest  (0) 2014.12.05
sp_whopro ~~  (0) 2014.12.05
SQL Server 툴과 유틸 모음 링크  (0) 2014.08.07
FineBuild  (0) 2014.01.15
DISK benchmark tool  (0) 2013.11.08
SQLQueryStress  (0) 2013.11.07

sp_whopro ~~


sp_whopro™ Script  - SQL Server Activity Monitoring and Logging Stored Procedure 
(SQLWorkshops)
http://www.sqldownload.com/Download



사용 방법


'Tool' 카테고리의 다른 글

SQLTest  (0) 2014.12.05
sp_whopro ~~  (0) 2014.12.05
SQL Server 툴과 유틸 모음 링크  (0) 2014.08.07
FineBuild  (0) 2014.01.15
DISK benchmark tool  (0) 2013.11.08
SQLQueryStress  (0) 2013.11.07

sqltag book 2


드디어 출간 되었습니다.
SQL DBA라면~~

http://www.kyobobook.co.kr/product/detailViewKor.laf?ejkGb=KOR&mallGb=KOR&barcode=9791195328307&orderClick=LAG&Kc=

'SQLTAG Daily Links' 카테고리의 다른 글

2014.12.05  (0) 2014.12.05
sqltag book 2  (0) 2014.10.21
2014.05.27  (0) 2014.05.27
2014.05.26  (0) 2014.05.26
2014.05.22  (0) 2014.05.22
2014.05.21  (0) 2014.05.21