Category Archives: SQL Server

Elfriede lebe hoch!

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

Posted in #Elfriede, SQL Server, Uncategorized | Leave a comment

Log chain broken? How to deal with backups from the future.

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

Posted in Backup, SQL Server | Leave a comment

Create failed for Availability Group Listener

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

Posted in AlwaysOn Availability Groups, SQL Server, Uncategorized | Leave a comment

redgate SQL Monitor – The RPC Server is unavailable

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

Posted in SQL Server | Leave a comment

How to tune ISV apps – Capture the workload

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

Posted in SQL Server, Uncategorized | Tagged , , , , | 1 Comment

Blog Post Series „How to tune ISV apps“

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

Posted in SQL Server | Tagged , , | 1 Comment

Is SQL Server under high Memory Pressure?

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

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