Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 SQL Server 2012 SP3 Released  [new]
Winnipuh
Member [заблокирован]

Откуда: Київ
Сообщений: 10428
http://www.microsoft.com/en-us/download/details.aspx?id=49996

SQL Server 2012 SP3 has just been freshly released! Not only does this release contain bug fixes, it also contains a slew of performance tuning related features.

Many of these features are about memory grants. This is NOT the memory used in the buffer pool/ data cache by the query — it’s the memory also known as Query Workspace Memory. Start reading more here.

Check these out:

KB 3107398 – Improvements to sys.dm_exec_query_stats

This is kind of a big deal. The sys.dm_exec_query_stats DMV will now report on total, last, min and max statistics for granted workspace memory, ideal workspace memory, degree of parallelism, and reserved threads. These columns are in SQL Server 2016 CTP3, but it’s really awesome that they’ve been backported town to 2012!

KB 3107397 – “Actual Rows Read” Added to Query Execution Plans

This is really exciting! It’s hard for people to read execution plans. You may have a very large index seek or scan that reads a ton of rows, and it has a hidden filter in the seek or scan. But it may be hard to diagnose because you only see the number of rows to come OUT of the seek or scan operator. This lets you know not only the rows that exit the operator, but how many it had to consume, too. It’s sorta like having a little bit of STATISTICS IO in your execution plan!

KB 3107401 – New Query Hints for min_grant_percent and max_grant_percent

Previously, if you identified that a query was asking for a problematic memory grant, your options were pretty limited – code changes, index changes, resource governor, or server wide settings. These options let you shoot yourself in the foot tune this just for a single query. Check out the KB– there is a safety in the feature. If the minimum required grant is higher than max_grant_percent, it will still get the minimum.

KB 3107172 – hash_spill_details Added to Extended Events to Diagnose tempdb Spills, Improvements to sort_warning and hash_warning

Ever seen sort or hash spill warnings in execution plans and wondered how much of a difference they were making to the runtime of the plan? That may be less of a mystery with these improvements.

KB 3107173 – query_memory_grant_usage added to Extended Events

This XEvent allows tracing for the ideal memory grant for queries, what they actually got, and the degree of parallelism they used.

What About SQL Server 2014?

I don’t believe any of these are currently available for SQL Server 2014, but looking at past release patterns it’s likely they’ll be available soon
23 ноя 15, 20:41    [18461636]     Ответить | Цитировать Сообщить модератору
 Re: SQL Server 2012 SP3 Released  [new]
komrad
Member

Откуда:
Сообщений: 5735
Winnipuh,

текст на английском - это цитата откуда-то?
если это не авторский текст, то обычно указывают ссылку на источник
24 ноя 15, 11:59    [18463423]     Ответить | Цитировать Сообщить модератору
 Re: SQL Server 2012 SP3 Released  [new]
o-o
Guest
SQL Server 2012 SP3 Adds Memory Grant and Performance Features by Kendra Little
24 ноя 15, 12:06    [18463472]     Ответить | Цитировать Сообщить модератору
 Re: SQL Server 2012 SP3 Released  [new]
Winnipuh
Member [заблокирован]

Откуда: Київ
Сообщений: 10428
o-o
SQL Server 2012 SP3 Adds Memory Grant and Performance Features by Kendra Little


да!
;-)
24 ноя 15, 13:00    [18463975]     Ответить | Цитировать Сообщить модератору
 Re: SQL Server 2012 SP3 Released  [new]
Winnipuh
Member [заблокирован]

Откуда: Київ
Сообщений: 10428
komrad
Winnipuh,

текст на английском - это цитата откуда-то?
если это не авторский текст, то обычно указывают ссылку на источник


спешил донести люядм информацию, отредактировать пост не смог, чтобы вставить ссылку
24 ноя 15, 13:00    [18463981]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить