OT: SQL Litespeed

Does anyone have any comments about SQL Litespeed re: backups and restores.
I would like to evaluate it but would like to hear some reviews.
Thanks,
EricGrab a demo copy off the website and check it out... Personally, I think
it's an excellent product.
I evaluated it at the request of my employer (before they would sign a
purchase order) and came up with the following:
I tested SQL Litespeed's backup and restore capabilities against that of the
native SQL Server BACKUP and RESTORE statements.
Two test databases were prepared. Both were 16gb.
The first database, 'BINARY', had a single table with a single BINARY(256)
column. I populated the column with random binary data produced by
generating and then concatenating 8 16-bit binary GUIDs per row. The goal
of this test was to see if speed increase would occur on data that
theoretically cannot be compressed.
The second database, 'TEXT', had a single table with a single TEXT column.
This column was populated with the full text of the Second Informal Review
Draft of the 1992 ANSI/ISO SQL Standard document (1.67 mb of raw text) per
row. The goal of this test was to see how much speed increase would occur
with highly compressible data.
A 'real' database will fall somewhere in-between these two examples,
probably closer to the text.
Results:
Backup Product Database Backup time
Backup size Restore Time
----
----
--
SQL Server BINARY 27:39
15.9 gb 32:08
SQL LiteSpeed BINARY 25:18
15.3 gb 24:34
SQL Server TEXT 19:13
16 gb 20:55
SQL LiteSpeed TEXT 11:32
4.6 gb 11:47
----
----
--
These tests seem to indicate that SQL LiteSpeed does live up to its claims
and performs better, delivering smaller backups and faster backups and
restores than the native BACKUP and RESTORE statements. I was very pleased
with its overall functionality and ease-of-use.
"Eric Sabine" <mopar41@.___ho_y_tmail.ScPoAmM> wrote in message
news:uNd58qnPEHA.620@.TK2MSFTNGP10.phx.gbl...
> Does anyone have any comments about SQL Litespeed re: backups and
restores.
> I would like to evaluate it but would like to hear some reviews.
> Thanks,
> Eric
>|||I have been using it in production for a while now. It does what it says it
does. Backups are compressed and take less time and file space. Nothing
fancy or flashy, it just works.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Eric Sabine" <mopar41@.___ho_y_tmail.ScPoAmM> wrote in message
news:uNd58qnPEHA.620@.TK2MSFTNGP10.phx.gbl...
> Does anyone have any comments about SQL Litespeed re: backups and
restores.
> I would like to evaluate it but would like to hear some reviews.
> Thanks,
> Eric
>|||Thanks Adam, great tests.
"Adam Machanic" <amachanic@.air-worldwide.nospamallowed.com> wrote in message
news:ef7PT2nPEHA.4064@.tk2msftngp13.phx.gbl...
> Grab a demo copy off the website and check it out... Personally, I think
> it's an excellent product.
> I evaluated it at the request of my employer (before they would sign a
> purchase order) and came up with the following:
> I tested SQL Litespeed's backup and restore capabilities against that of
the
> native SQL Server BACKUP and RESTORE statements.
> Two test databases were prepared. Both were 16gb.
> The first database, 'BINARY', had a single table with a single BINARY(256)
> column. I populated the column with random binary data produced by
> generating and then concatenating 8 16-bit binary GUIDs per row. The goal
> of this test was to see if speed increase would occur on data that
> theoretically cannot be compressed.
> The second database, 'TEXT', had a single table with a single TEXT column.
> This column was populated with the full text of the Second Informal Review
> Draft of the 1992 ANSI/ISO SQL Standard document (1.67 mb of raw text) per
> row. The goal of this test was to see how much speed increase would occur
> with highly compressible data.
> A 'real' database will fall somewhere in-between these two examples,
> probably closer to the text.
> Results:
> Backup Product Database Backup time
> Backup size Restore Time
> ----
--
> ----
--
> --
> SQL Server BINARY 27:39
> 15.9 gb 32:08
> SQL LiteSpeed BINARY 25:18
> 15.3 gb 24:34
> SQL Server TEXT 19:13
> 16 gb 20:55
> SQL LiteSpeed TEXT 11:32
> 4.6 gb 11:47
> ----
--
> ----
--
> --
> These tests seem to indicate that SQL LiteSpeed does live up to its claims
> and performs better, delivering smaller backups and faster backups and
> restores than the native BACKUP and RESTORE statements. I was very
pleased
> with its overall functionality and ease-of-use.
>
> "Eric Sabine" <mopar41@.___ho_y_tmail.ScPoAmM> wrote in message
> news:uNd58qnPEHA.620@.TK2MSFTNGP10.phx.gbl...
> > Does anyone have any comments about SQL Litespeed re: backups and
> restores.
> > I would like to evaluate it but would like to hear some reviews.
> >
> > Thanks,
> > Eric
> >
> >
>|||Thanks Geoff.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:Oqh7K$nPEHA.1036@.TK2MSFTNGP09.phx.gbl...
> I have been using it in production for a while now. It does what it says
it
> does. Backups are compressed and take less time and file space. Nothing
> fancy or flashy, it just works.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Eric Sabine" <mopar41@.___ho_y_tmail.ScPoAmM> wrote in message
> news:uNd58qnPEHA.620@.TK2MSFTNGP10.phx.gbl...
> > Does anyone have any comments about SQL Litespeed re: backups and
> restores.
> > I would like to evaluate it but would like to hear some reviews.
> >
> > Thanks,
> > Eric
> >
> >
>|||We use is too. We had one piece of hardware whose log backups would fail
intermittently but it was on its way out anyway. We haven't had any problems
since migrating those databases to new hardware. We run it on 15 different
servers. I think that the largest database is 20 GB or so.
It's a snap to implement b/c you can just replace the backup commands in
your procs with the litespeed commands. I think that it comes with a
maitenance plan tool, too but I haven't used that.
Michelle
"Eric Sabine" <mopar41@.___ho_y_tmail.ScPoAmM> wrote in message
news:uNd58qnPEHA.620@.TK2MSFTNGP10.phx.gbl...
> Does anyone have any comments about SQL Litespeed re: backups and
restores.
> I would like to evaluate it but would like to hear some reviews.
> Thanks,
> Eric
>|||As a minor update, I've been pleased so far with SLS. I did learn that the
next version of the professional version will natively support object level
restorations which is pretty cool.
Eric
"Eric Sabine" <mopar41@.___ho_y_tmail.ScPoAmM> wrote in message
news:uNd58qnPEHA.620@.TK2MSFTNGP10.phx.gbl...
> Does anyone have any comments about SQL Litespeed re: backups and
restores.
> I would like to evaluate it but would like to hear some reviews.
> Thanks,
> Eric
>|||Anyone reading who can explain to me how this will work (from a lower-level
standpoint)? I was under the impression that the Virtual Device Interface
post-6.5 (was there even a VDI in 6.5?) only supports backup and restore at
the database level; how can restoration of only a single table be possible?
"Eric Sabine" <mopar41@.___ho_y_tmail.ScPoAmM> wrote in message
news:%23kv2fMyQEHA.3452@.TK2MSFTNGP10.phx.gbl...
> As a minor update, I've been pleased so far with SLS. I did learn that
the
> next version of the professional version will natively support object
level
> restorations which is pretty cool.|||Good point. Perhaps it's less glamorous than it sounds a la the way
enterprise manager "looks" like it's reordering columns for you by just
dragging a column to a new "location." It will be interesting to test it
(but I won't be getting the pro version) :-(
Eric
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uAi8BcyQEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Anyone reading who can explain to me how this will work (from a
lower-level
> standpoint)? I was under the impression that the Virtual Device Interface
> post-6.5 (was there even a VDI in 6.5?) only supports backup and restore
at
> the database level; how can restoration of only a single table be
possible?
> "Eric Sabine" <mopar41@.___ho_y_tmail.ScPoAmM> wrote in message
> news:%23kv2fMyQEHA.3452@.TK2MSFTNGP10.phx.gbl...
> > As a minor update, I've been pleased so far with SLS. I did learn that
> the
> > next version of the professional version will natively support object
> level
> > restorations which is pretty cool.
>