SQL Stability Challenges and Solutions.

With my limited SQL background, I'm seeking insights into an intricate issue that unfolded with our meticulously built SQL 2016 server. Our setup, constructed with utmost care, adhered strictly to Microsoft's best practices and recommendations from renowned entities like PURE (iSCSI), Litespeed, and Brent Ozar. Notably, even a third-party SQL specialist's review affirmed the soundness of our approach.

However, our experience was marred by a series of vexing challenges related to Litespeed. These included failed log shipping, recurring troubles with locked or corrupted backup files, and SQL crashes attributed to a Litespeed dll triggering memory violations, purportedly addressed in SQL CU7 and subsequent updates.

Strangely, these issues were absent in earlier iterations of Litespeed on older SQL versions. Despite our efforts to seek resolutions from Litespeed, the problems persisted, compelling us to eliminate all remnants of the software. Since transitioning to native backup solutions, our system has maintained stability, albeit at the cost of prolonged backup and restore durations. Even with attempts to mitigate this via multiple file usage, the problem persists.

As we evaluate backup tools on a test server, the critical question looms: how can I reassure both myself and my superiors about the server's stability? I'm particularly concerned about litespeed.exe's tendency to lock backup files indefinitely, hindering completion. Consequently, the dilemma remains between embracing a third-party tool, with lingering apprehensions from past experiences, or persisting with native procedures despite their sluggishness.

It's worth mentioning our disappointment with Litespeed's support, as their inability to resolve any of our issues persisted, often shifting the blame to Microsoft, who in turn redirected it to Litespeed. Since eliminating Litespeed, our predicaments have dissipated, leaving us in a state of uncertainty koowspin moving echatrandom forward.

  • Hello 

    Thank you for using our forums, your feedback is well received.

    Generally speaking, issues matching the aforementioned description were introduced after a Microsoft update and thus resolved by Microsoft on a future CU.

    Moreover, please note these issues were observed on older SQL versions such as 2016 and most of our users mitigated them with a SQL Server version upgrade.

    Further, kindly recall that LiteSpeed, as a third-party tool, depends on the technology SQL Server offers and thus in some respects depends on Microsoft for specific solutions such as in the case in question.

     

    It is unfortunate that you feel the support experience was not optimal for your scenario. If you would allow us the chance to improve your views of our support system, as a LiteSpeed product specialist I will make the exception to take care of you directly and assure to follow-up your cases until resolution, including possible collaboration calls with you and Microsoft.

     

     

    Looking forward to hearing from you soon.