Category Archives: Uncategorized

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

Shrink an SAP database “online”.

Shrinking is bad First of all: shrinking a database is nothing that you should do on a regular basis, like using this step in a Maintenance Plan or setting it up yourself via SQL Server Agent Jobs. But if the … Continue reading

Posted in Uncategorized | 1 Comment

SQL Server 2008 R2 Installation Failed -2068052081, 1212, 1935

Today: Server Team provided Windows Server 2008 Service Pack 2, Build 6002 Installation of SQL Server 2008 R2 failed with this message: Overall summary: Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the … Continue reading

Posted in Uncategorized | Leave a comment

0x851c0001 – the credentials you provided for the ‘SQLSERVERAGENT’ service is invalid.

We always install SQL Server with configuration.ini files to be sure that each and every server looks like the other. Today we received the error message: (01) 2016-11-29 14:23:47 Slp: Exception type: Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException (01) 2016-11-29 14:23:47 Slp: Message: (01) 2016-11-29 … Continue reading

Posted in Uncategorized | 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

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

Last “Touch” on each Database per Instance

Originally posted on cms4j:
Today i was asked if some of the databases on a specific instance were in use or not. As this is an interesting question that could be easily answered by the SQL Server DMVs i…

Posted in Uncategorized | Leave a comment