AnsweredAssumed Answered

vCenter Snapshots freeze MS-SQL server

Question asked by Adam Bond on May 2, 2016
Latest reply on Dec 7, 2016 by Adam Bond

We're battling an issue with a virtual SQL server and vCenter sync'd snapshots.  We're not having snapshot failures, but the snap is causing just a bit of disruption so that some of our apps are timing out with VSS snap creation.  We don't have the problem when using Veeam's application consistent snaps so I think there must be something else wrong on my guest OS.  I know I can disable unnecessary VSS writers, but I'm a bit unsure which ones it would be safe to disable and still get the consistent snaps in Nimble.

 

Here is what we have on our list of enabled VSS writers.  There is a way to disable them using this article: https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1031200

 

vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool

(C) Copyright 2001-2005 Microsoft Corp.

 

 

Writer name: 'Task Scheduler Writer'

   Writer Id: {d61d61c8-d73a-4eee-8cdd-f6f9786b7124}

   Writer Instance Id: {1bddd48e-5052-49db-9b07-b96f96727e6b}

   State: [1] Stable

   Last error: No error

 

 

Writer name: 'VSS Metadata Store Writer'

   Writer Id: {75dfb225-e2e4-4d39-9ac9-ffaff65ddf06}

   Writer Instance Id: {088e7a7d-09a8-4cc6-a609-ad90e75ddc93}

   State: [1] Stable

   Last error: No error

 

 

Writer name: 'Performance Counters Writer'

   Writer Id: {0bada1de-01a9-4625-8278-69e735f39dd2}

   Writer Instance Id: {f0086dda-9efc-47c5-8eb6-a944c3d09381}

   State: [1] Stable

   Last error: No error

 

 

Writer name: 'System Writer'

   Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}

   Writer Instance Id: {27c00a72-3215-48b6-a699-7bd01b674fa8}

   State: [1] Stable

   Last error: No error

 

 

Writer name: 'SqlServerWriter'

   Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}

   Writer Instance Id: {c7c46f7d-8a70-4530-9445-30a5a80d7fd2}

   State: [1] Stable

   Last error: No error

 

 

Writer name: 'ASR Writer'

   Writer Id: {be000cbe-11fe-4426-9c58-531aa6355fc4}

   Writer Instance Id: {c29e355b-c672-4ef3-8d34-7e75407e96ae}

   State: [1] Stable

   Last error: No error

 

 

Writer name: 'Shadow Copy Optimization Writer'

   Writer Id: {4dc3bdd4-ab48-4d07-adb0-3bee2926fd7f}

   Writer Instance Id: {0048c718-52fd-416e-bdcc-fc6efac7c369}

   State: [1] Stable

   Last error: No error

 

 

Writer name: 'Registry Writer'

   Writer Id: {afbab4a2-367d-4d15-a586-71dbb18f8485}

   Writer Instance Id: {2c79e02d-8724-469f-8bb8-280e73a21a89}

   State: [1] Stable

   Last error: No error

 

 

Writer name: 'BITS Writer'

   Writer Id: {4969d978-be47-48b0-b100-f328f07ac1e0}

   Writer Instance Id: {abc3b9c3-61f6-4de9-a4de-873133b6c8d9}

   State: [1] Stable

   Last error: No error

 

 

Writer name: 'COM+ REGDB Writer'

   Writer Id: {542da469-d3e1-473c-9f4f-7847f01fc64f}

   Writer Instance Id: {f0908cd6-c87c-4dc3-9bb1-2d4b7862e538}

   State: [1] Stable

   Last error: No error

 

 

Writer name: 'WMI Writer'

   Writer Id: {a6ad56c2-b509-4e6c-bb19-49d8f43532f0}

   Writer Instance Id: {b8fc017d-7c54-439d-a612-e70e80bb98f7}

   State: [1] Stable

   Last error: No error

 

 

Which of these are necessary in order to get a quiesced snap in VMware?

Outcomes