Blogs I Follow
Recent Blog posts
Top Posts & Pages
- Msg 14607, Level 16, State 1 - profile name is not valid
- SQL Server 2008 R2 Installation Failed -2068052081, 1212, 1935
- redgate SQL Monitor - The RPC Server is unavailable
- 0x851c0001 - the credentials you provided for the 'SQLSERVERAGENT' service is invalid.
- Windows Server 2012, .NET Framework 3.5, 0x800F0906, 0x800F081F
- Log chain broken? How to deal with backups from the future.
- Is SQL Server under high Memory Pressure?
Category Archives: SQL Server
Szenario. Sie sind DBA einer IT-Firma, die ein Tickettool einsetzt, um Geschäftsprozesse abzubilden. Nach Jahren ist das Datenvolumen der Datenbank auf mehr als 250 GB angewachsen. Elfriede vom Controlling hat mit den SQL Server Reporting Services mehrere komplexe Berichte implementiert. … Continue reading
Today (2015-10-05) we had to deal with an interesting phenomenon. Backups from the future breaking the log chain! Problem Our third party software solution that is responsible for backup and restore tried to take a transaction log backup of a … Continue reading
Problem Today I tried to create an AlwaysOn Availability Group. Everything went fine until I configured the Availability Group Listener. It failed with the error message: Create failed for Availability Group Listener <ListenerName>. Microsoft SQL Server, Error 19471. The Windows … Continue reading
Lucky me, I am setting up redgate SQL Monitor to monitor SQL Server Instances. First to say – as ever – redgate is developing ingeniously simple tools. So the installation just took minutes, the services on one VM, the repository database … Continue reading
This is the first article of my blog post series How to tune ISV apps In today’s blog post i will describe the steps that you have to do in order to capture a typical workload during business hours. Importance … Continue reading
Inspired by Brent Ozars Blog post http://www.brentozar.com/archive/2014/12/whos-allowed-add-indexes-isv-apps/ I will start this series. It will consist of: Capture the workloadCapturing a typical workload during business hours. Diagnosis and Doing with “sp_BlitzIndex™”Diagnose and Delete/Alter/Add Indexes with the help of Brent Ozars “sp_BlitzIndex™”. … Continue reading
A few weeks ago, i started a blog post series that covers the finding of performance bottlenecks in SQL Server. In the first blog post in the series https://cms4j.wordpress.com/2014/09/30/is-sql-server-under-high-cpu-pressure/ i focused on CPU Pressure. In this blog post i will … Continue reading