'2015/05'에 해당되는 글 2건
- 2015.05.20 SQL Server 2012 Certification upgrade info
- 2015.05.18 TokenAndPermUserStore
SQL Server 2012 Certification upgrade info
1. SQL 2008이 있는 경우 - 아래 두개의 시험을 봐야 MCSA가 됩니다. Admin 기준.
70-457: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1
70-458: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2
MCSE: Data Platform involves
· A pass in Microsoft Certified IT Professional (MCITP) Database Administrator 2008 or Database Developer 2008 (70-450 or 70-451)
- Exam 70-457: Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 – Part 1
- Exam 70-458: Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 – Part 2
- Exam 70-459: Transition your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE:Data Platform
MCSE: Business Intelligence involves
A pass in Microsoft Certified IT Professional (MCITP) Business Intelligence 2008 (70-452)
· Exam 70-457: Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 – Part 1
· Exam 70-458: Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 – Part 2
· Exam 70-460: Transition your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence
2. 처음 부터 SQL 2012를 취득 하고 자 한다면
'ETC' 카테고리의 다른 글
MS-SQL 2016 New Features (0) | 2017.02.24 |
---|---|
메모리 dump 분석 예 ( 정확하지 않음 ) (0) | 2014.11.06 |
Windbg 명령어 & 설치 (0) | 2014.11.06 |
Window 서비스 등록/삭제 방법 (0) | 2011.10.20 |
TokenAndPermUserStore
DBCC FREESYSTEMCACHE (
'TokenAndPermUserStore'
)
GO
SELECT
[type],
[name],
cache_address,
buckets_count,
buckets_in_use_count
FROM sys.dm_os_memory_cache_hash_tables
WHERE [type] = 'TokenAndPermUserStore';
-- SQL 2012
SELECT
[name],
sum(pages_kb)/1024 MB
FROM sys.dm_os_memory_clerks
WHERE type = 'USERSTORE_TOKENPERM' and pages_kb > 8
GROUP BY name;
-- SQL 2008
SELECT SUM(single_pages_kb + multi_pages_kb) AS "CurrentSizeOfTokenCache(kb)"
FROM sys.dm_os_memory_clerks
WHERE name = 'TokenAndPermUserStore'
-- 어떤 내용들이 있는지
SELECT COUNT(*) as TokenCount, *
FROM
(SELECT
x.value('(//@name)[1]', 'varchar (100)') AS [Token Name],
x.value('(//@class)[1]', 'bigint') AS [Class],
x.value('(//@subclass)[1]', 'int') AS [SubClass]
FROM
(SELECT CAST (entry_data as xml)
FROM sys.dm_os_memory_cache_entries
WHERE type = 'USERSTORE_TOKENPERM')
AS R(x)
) a
GROUP BY [Token Name],[Class],[SubClass]
'Common Admin' 카테고리의 다른 글
Admin::Mini dump 추출 방법 (0) | 2016.09.02 |
---|---|
성능 Counter - Disk Transfers/sec (Disk Reads/sec, Disk Writes/sec) (1) | 2015.12.28 |
Database Landscape map – February 2013 (0) | 2013.03.13 |
SQL Server tempdb 복구 (0) | 2013.01.08 |