Thursday, January 30, 2014

SQL 2012 : SQL Server Agent - Reloading Agent Settings


I encountered this for the first time today.
The SQL Agent log filled with the message 'Reloading Agent Settings'.
The options are to apply the latest service pack or apply a registry entry, detailed here.

Friday, January 24, 2014

MCSE : Business Intelligence

Following my success in upgrading my SQL 2008 DBA & Development certifications to SQL 2012 Data Platform, I attempted and passed the BI one today.

It was only 1 upgrade exam (70-460) as I had already done 70-457 & 70-458 for the data platform certification, A bit of a no-brainer really when I found out the same prerequisites could be used for multiple exam paths.

So, I'm now MCSE Business Intelligence too.

Sunday, January 5, 2014

SQL 2012 Wait Types

Checking over a 2012 instance today, I happened upon a couple of wait types I had not seen before.
Despite the particular VM being freshly configured and having a workload of basically nothing, 2 wait types found themselves in pole position according to my script.


In short, they are -

DIRTY_PAGE_POLL - A wait type associated with SQL 2012's Indirect Check Points.

HADR_FILESTREAM_IOMGR_IOCOMPLETION - A wait that is associated with checking the health of an Always On instance. It turns out it can be ignored if Always ON  is not being used.

So. time to update my waits scripts it would appear, and checking Brent Ozar's sp_blitz, he already has :)