Category Archives: SQL Server

Beware the impact of Auto Update Stats kicking in unexpectedly..

Interesting catch today with someone complaining of some API latency a week ago for a couple minutes.  IGNITE shows some 50 processes blocked at this time: Head blocker is a SPID (694) from a SOAP server. The SQL being executed … Continue reading

Image | Posted on by | Tagged | Leave a comment

New SQL Server SKUs with SSD coming soon

Just been informed of 3 new SQL Server SKUs that have been designed for this year.  The SKU engineers have finally come to the table with a design that provides both the capacity and the performance we need. All of these … Continue reading

Posted in Hardware, SQL Server | Tagged , | Leave a comment

2013-11-13 Perils of SSIS Logins Transfer

9pm – Harman gets me on Lync. He’s running some SSIS Logins transfer wizard for one of the new TAKO SQL servers we’re preparing to migrate to tomorrow and he’s now lost SQL access! Great! looks like the wizard has … Continue reading

Posted in SQL Server | Leave a comment

DBA diaries – ghost NICs and ILO

Monday morning, 9am, settling down to my first coffee of the day, notice SQL connectivity alerts from a server in our risk cluster. My first thought is why the hell hasn’t the on-call person seen these alerts as they would have … Continue reading

Posted in SQL Server | Leave a comment

when you need 10,000 IOPS from direct attached storage

Our white lab coat engineers have provided a fixed range of optimised servers. In most cases we can find a server for our needs but just sometimes we need that extra capacity or IOPS. Our priciest HP DL580G7 server at … Continue reading

Posted in SQL Server | Tagged , | Leave a comment

DBA Diaries – Losing the EMC SAN (again)

A quiet afternoon doing my ‘Mid Year Review Check-In’ is interrupted by SQL mirroring “disconnected”email alerts telling me that my mirrors are down for some reason. Quick confirmation from my DBA team that they were not doing any maintenance and were … Continue reading

Posted in SQL Server | Tagged , , | Leave a comment

My SQL Server Perfmom counters are missing….

just had MS Premier Support restore some missing SQL Counters for us. Actually, the counters weren’t missing but rather had missing data.. Here is the fix: –        We followed the steps below to reload the SQL Server counters. 1. Open … Continue reading

Posted in SQL Server | Leave a comment