Azure Site Recovery jobs fail on servers hosting SQL Server instances with AUTO_CLOSE DBs

This post is to help you if you are suffering from the following issue:

A VSS writer has rejected an event with error. The writer experienced a non-transient error. If the backup process is retried, the error is likely to reoccur. Changes that the writer made to the writer components while handling the event will not be available to the requester. Check the event log for related events from the application hosting the VSS writer.

Symptoms


Consider the following scenario:

  • You have a server that is running any version of Microsoft SQL Server.
  • This SQL Server instance hosts databases that have the AUTO-CLOSE option set.
  • You run a non-component VSS backup (for example, by using Azure Site Recovery (ASR) Agent) against volumes of this server that is hosting SQL Server database files.

In this situation, you notice that the VSS backup fails and triggers the following entry in the Application log.

Continue reading

Azure SQL Database – Automatic Tuning – Have you enabled it?

Do you enable this setting to allow automatic tuning to care of all your performance needs? Well not ALL your needs, more so:

  • CREATE INDEX
  • DROP INDEX
  • FORCE LAST GOOD PLAN

Continue reading

SQL Server 2019 eBook

SQL Server 2019 is ready available for use, but before you download you should review the webinars, white papers and eBook available on the technology (definitely the eBook 😉 ).

2019book.JPG

You can find the eBook at the following link –

https://info.microsoft.com/ww-landing-introducing-sql-server-2019-content.html

 

 

Execution Plans in Azure SQL Database

Yes you can still get execution plans for Azure SQL Database, you cannot get this from the Azure Portal so it is good to know for your tuning days. It is based on the same code you have probably run many times before. Lets get the plan handle and work through an example.

Continue reading

Azure SQL Best Practices?

A way to enforce good practice and standards is by Azure Policy. As stated by Microsoft “Azure Policy is a service in Azure that you use to create, assign, and manage policies. These policies enforce different rules and effects over your resources, so those resources stay compliant with your corporate standards and service level agreements”.  Pretty important stuff if you ask me.

Continue reading