locked
VSS writer issue RRS feed

  • Question

  • We have an SQL server where the memory keeps going up and we have to randomly restart the sql server service to release the memory.

    We are trying to understand what is causing the issue and it seems to be related to the VSS services.

    We are seeing a bunch of VSS event logs source VSS eventid 8193

    Event id is displaying info below. What would cause this.

    Volume Shadow Copy Service error: Unexpected error calling routine ConvertStringSidToSid(S-1-5-21-2483102095-2371545625-1991247448-10397.bak).  hr = 0x80070539, The security ID structure is invalid.

    .

     

    Operation:

       OnIdentify event

       Gathering Writer Data

     

    Context:

       Execution Context: Shadow Copy Optimization Writer

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

       Writer Name: Shadow Copy Optimization Writer

       Writer Instance ID: {14341a33-86a7-41cc-b6b5-af0f7c6a9901}

    Wednesday, September 14, 2016 10:58 AM

Answers

  • We have an SQL server where the memory keeps going up and we have to randomly restart the sql server service to release the memory.

    Hello,

    That is the quite normal behavior to allocate as much memory as it needs and as it can get, and there is no direct relation to VSS Writer.

    If it's really required for your application to restart SQL Server, then it's more an issue of your application or caused by it; normally it's never a solution or required to restart SQL Server, the most installations of SQL Server runs 24/7 without any issue.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, September 14, 2016 5:45 PM
  • We have an SQL server where the memory keeps going up and we have to randomly restart the sql server service to release the memory.

    We are trying to understand what is causing the issue and it seems to be related to the VSS services.

    We are seeing a bunch of VSS event logs source VSS eventid 8193

    Event id is displaying info below. What would cause this.

    Volume Shadow Copy Service error: Unexpected error calling routine ConvertStringSidToSid(S-1-5-21-2483102095-2371545625-1991247448-10397.bak).  hr = 0x80070539, The security ID structure is invalid.


    Bubba,

    Unfortunately you are wrong VSS has nothing to do with SQL Server memory utilization, regarding VSS error what might be happening is some tool which uses VSS to connect to database or take disks snapshot backup is failing for some reason which you have to find out.

    Its quite normal for SQL Server to utilize all memory given to it. I suggest you set max server memory leaving some good amount for OS. If you still feel memory is less add more RAM

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Thursday, September 15, 2016 4:10 AM

All replies

  • follow few steps  and see does it helps.

    https://social.technet.microsoft.com/Forums/windows/en-US/7b52f7c1-a783-409e-9af3-da64567676df/vss-error-8193?forum=winserverfiles
    https://www.experts-exchange.com/questions/27834600/Event-ID-8193.html
    https://community.spiceworks.com/windows_event/show/146-vss-8193
    https://www.veritas.com/support/en_US/article.TECH157464


    Regards, S_NO "_"

    Wednesday, September 14, 2016 12:26 PM
  • We have an SQL server where the memory keeps going up and we have to randomly restart the sql server service to release the memory.

    Hello,

    That is the quite normal behavior to allocate as much memory as it needs and as it can get, and there is no direct relation to VSS Writer.

    If it's really required for your application to restart SQL Server, then it's more an issue of your application or caused by it; normally it's never a solution or required to restart SQL Server, the most installations of SQL Server runs 24/7 without any issue.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, September 14, 2016 5:45 PM
  • We have an SQL server where the memory keeps going up and we have to randomly restart the sql server service to release the memory.

    We are trying to understand what is causing the issue and it seems to be related to the VSS services.

    We are seeing a bunch of VSS event logs source VSS eventid 8193

    Event id is displaying info below. What would cause this.

    Volume Shadow Copy Service error: Unexpected error calling routine ConvertStringSidToSid(S-1-5-21-2483102095-2371545625-1991247448-10397.bak).  hr = 0x80070539, The security ID structure is invalid.


    Bubba,

    Unfortunately you are wrong VSS has nothing to do with SQL Server memory utilization, regarding VSS error what might be happening is some tool which uses VSS to connect to database or take disks snapshot backup is failing for some reason which you have to find out.

    Its quite normal for SQL Server to utilize all memory given to it. I suggest you set max server memory leaving some good amount for OS. If you still feel memory is less add more RAM

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Thursday, September 15, 2016 4:10 AM
  • Hi bubba1984 ,

    I’m writing to follow up with you on this post. Was the issue resolved? If you issue has resolved, I’d like to mark this issue as "Answered". Please also feel free to unmark the issue, with any new findings or concerns you may have.

    If you have any other questions, please let me know.

    Regards,
    Lin
    Thursday, September 22, 2016 2:57 PM