Pascal Tan on Zizhu Technology Park Sha… Mr WordPress on Hello world!
Category Archives: SQL Server
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
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
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
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
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
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