Archive for the ‘Uncategorized’ Category

The best SQL Server training ever

If you wish to attend the best SQL Server training available on earth you have no other options as to go with SQLSkills because those guys provide the best inside ever about SQL you can imagine. The team provides only senior level of expertise and beyond literally about everything related to SQL Server ecosystem. The main reason why the team is so awesome is experience (just looks through their job records). Any other information or debates in order to persuade you to have a look at those courses are redundant.

Here is my next one I would like to attend: IEPTO2: Performance Tuning and Optimization – Part 2 class in Chicago, October 9-13, 2017




Categories: Uncategorized

Procedure Cache – Memory Pressure

December 13, 2012 3 comments

_MG_2719Hi everyone,

Recently I was dealing with unusual behavior of Procedure Cache caused pseudo-random execution plans to be removed from memory (SQL Server 2005, 2008, 2008R2). As a result, under a large workload there was observed locks contention related to schema locks required in order to compile and insert a procedure into Procedure Cache. This is a predictable behavior of heavy loaded systems. But, the main question here is – how can we identify this type of issues related to so called Memory Pressure in Procedure Cache? Read more…

Categories: Memory, Uncategorized

Microsoft® SQL Server® 2008 R2 Service Pack 1

Hi everyone!

Eventually SQL Server 2008 R2 Service Pack 1(SP1) has been released and now it is accessible for downloading. SQL Server 2008 R2 service pack updates all services of SQL Server 2008 R2 until SP1. Service pack includes all cumulative updates starting from 1 up to 6. You can use it easily to update the further list of SQL Server editions:

(1) SQL Server 2008 R2 Datacenter Edition
(2) SQL Server 2008 R2 Enterprise Edition and Developer Edition
(3) SQL Server 2008 R2 Standard Edition
(4) SQL Server 2008 R2 Web Edition
(5) SQL Server 2008 R2 Workgroup Edition
(6) SQL Server 2008 R2 Express Edition

Important: in order to update SQL Server 2008 R2 Express Edition, you should use SP1 for Express Edition or Express Edition with Advanced Services. Read more…