Does LiteSpeed works good for SQL 2012
-
Can you advice whether to go for Litespeed. I've >1TB databases setup on SQL 2012.
-
It works fine on 2012. You might also consider other 3rd party products for compression such as Red Gate SQL Backup[/url].
By the way, there is native compression of backups on 2012, right down to Standard versions. You can use that too.
Disclaimer: I do work for Red Gate.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
I've used LiteSpeed for several years now, but since SQL2008, I've always favoured native compression over 3rd Party tools. In some environments, LiteSpeed will slow to a crawl if there are multiple concurrent backups using xp_SLS.dll.
Also, Litespeed does not yet support virtual restore (ie attaching a backup as a database). The RedGate products do, I believe 🙂 And no, I don't work for RedGate 🙂
[font="Courier New"]sqlmunkee[/font]
[font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font] -
sqlmunkee (2/4/2014)
I've used LiteSpeed for several years now, but since SQL2008, I've always favoured native compression over 3rd Party tools. In some environments, LiteSpeed will slow to a crawl if there are multiple concurrent backups using xp_SLS.dll.Also, Litespeed does not yet support virtual restore (ie attaching a backup as a database). The RedGate products do, I believe 🙂 And no, I don't work for RedGate 🙂
Virtual restore is no longer supported by Red Gate, sorry to say. It's a technology that just didn't take off.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
That must be why Dell (who acquired Quest a while back) have added it to their latest LiteSpeed offering, NetVault LiteSpeed for SQL Server. 🙂 Not sure if it's enough to make me switch, though....
[font="Courier New"]sqlmunkee[/font]
[font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font] -
sqlmunkee (2/4/2014)
That must be why Dell (who acquired Quest a while back) have added it to their latest LiteSpeed offering, NetVault LiteSpeed for SQL Server. 🙂 Not sure if it's enough to make me switch, though....As far as I know - they have not added a virtual restore. They have a compressed restore process though - which is an option if all you need a a read only version.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Disclaimer: I work for Quest, now a part of Dell.
It is true that there is native compression in standard edition from 2008 R2 onwards, so you do have the capability to perform compressed backups in your 2012 environment. However, natively there is only one level of compression whereas third party vendors will offer multiple levels of compression using different algorithms that will work better with the types of data in your databases. LiteSpeed has 8 out of the box compression levels as well as 2 adaptive levels providing a number of options for you.
Third party offerings will also allow you to do more advanced things from the UI such as assigning the number of threads, CPU affinity and specifying retry periods should network access stop you from writing your backups to a network device. Having to start a backup again from the beginning if you have a network glitch is never fun, trust me I've been there.
It is true that there is no virtual restore functionality in LiteSpeed, this is due to the fact that we have been using Object Level Recovery technology and have had a transaction log reader in our product for years. The concept is that you can read your backup file(s) from the console and grab just the data you need to restore rather than having to restore a full backup or even just undo that transaction where someone forgot that all important where clause. This can significantly reduce your company's downtime.
My advice, download a couple of different products. Compare their usability, not just for one instance but how you can use it as an enterprise solution across many instances. Compare backup and restore times, space saved from various compression algorithms and how much space that can save you and therefore an ROI on both storage and reduced downtime. That's the best way to build a business case for your finance team to sign off on.
Hope this helps,
Rich[p]
[/p]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply