Application for "Replaying" a Table

I'm on a quest to find a way to "replay" a selected time range of records
from a table. The purpose is to simulate the pace and content of the records
in the table exactly as they were parsed during run-time. The ideal solution
would read records from a source table and write them to a destination table
as per a specified pace, i.e clock speed, 1/2 clock speed, 4x clock speed.

Just looking to see if there's something available currently before I jump
in and develop my own solution.

Thanks,

ChrisYou can get about 85% of what you want from SQL Profiler, although it doesn't quite get you there without some help in the form of a small app... You might even be able to do this with a SQL script, but that would be much more of a challenge.

-PatP|||SQL Profiler isn't going to help him replay the activity. He wants some kind of load simulator.|||Yeah, a tool something like LoadRunner (http://www.mercury.com/us/products/performance-center/loadrunner/) would be ideal, but you can get better than 85% of the way there using SQL Profiler to record the data into a table, then a small app to play the captured activity into another database. Not everybody has deep enough pockets to make load testing tools a snap decision... Most of us need to budget for them, sometimes for a couple of years before we get the cool toys to play with. Having a simple kludge like I've described to show what you can do with this kind of tool makes it a lot easier to sell!

-PatP

Anyone Use Live Vault?

Hi Everyone,
I'm investigating a software called Live Vault (http://www.livevault.com)
whose purpose is to continuously monitor and record changes in a SQL Server
database, at the database file level, and periodically send these changes to
a remote server where they're applied to matching files. In essence, it's
kind of up-to-the-minute backup of the database.
I am unsure about how this software is going to perform and/or affect the
database and I'm very interested in hearing from anyone who has experience
with this software.
Any information, thoughts and opinions regarding this tool is greatly
appreciated.
Lou
Hi
They do not state on their case studies exactly what OS's and Database
products are supported. Not a word about SQL Server on their site.
Ask the vendor if they have certified their product for SQL Server.
And don't forget, picking up the bits off disk, shipping them over a
connection, does induce performance limitations, and if your data were to go
corrupt on the local drive, the corruption is faithfully copied to them.
A service like this does not eliminate the need for regular Database and Log
dumps.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Louis Marchand" <lmarch@.safetrans.com> wrote in message
news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
> Hi Everyone,
> I'm investigating a software called Live Vault (http://www.livevault.com)
> whose purpose is to continuously monitor and record changes in a SQL
> Server
> database, at the database file level, and periodically send these changes
> to
> a remote server where they're applied to matching files. In essence, it's
> kind of up-to-the-minute backup of the database.
> I am unsure about how this software is going to perform and/or affect the
> database and I'm very interested in hearing from anyone who has experience
> with this software.
> Any information, thoughts and opinions regarding this tool is greatly
> appreciated.
> Lou
>
|||Mike,
Thank you very much for your input.
I do nightly full database backups and hourly transaction log backups during
business hours every day and copy these backups onto tape each night. This
leaves a potential one-day data loss in case of catastrophic failure.
Management sees Live Vault as a way to have an "up-to-the-minute" database
backup. Our systems group has had success using Live Vault to restore basic
user files e.g. Word documents or PDF documents, that sort of thing.
However, I am very suspicious of a product that monitors live SQL Server
data files. It sounds wonderful in theory but I've always been very leary
of the kind of bit level monitoring that's required.
I am really hoping someone on the newsgroup is using or has used the product
and could give a first hand account of their experiences. If there's anyone
out there reading this, I'd love to hear your honest assessment of the
product, any problems you've had and the support you received from Live
Vault addressing problems.
Best regards,
Lou
Louis Marchand
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etHYsWZTFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Hi
> They do not state on their case studies exactly what OS's and Database
> products are supported. Not a word about SQL Server on their site.
> Ask the vendor if they have certified their product for SQL Server.
> And don't forget, picking up the bits off disk, shipping them over a
> connection, does induce performance limitations, and if your data were to
go
> corrupt on the local drive, the corruption is faithfully copied to them.
> A service like this does not eliminate the need for regular Database and
Log[vbcol=seagreen]
> dumps.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Louis Marchand" <lmarch@.safetrans.com> wrote in message
> news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
(http://www.livevault.com)[vbcol=seagreen]
changes[vbcol=seagreen]
it's[vbcol=seagreen]
the[vbcol=seagreen]
experience
>

Anyone Use Live Vault?

Hi Everyone,
I'm investigating a software called Live Vault (http://www.livevault.com)
whose purpose is to continuously monitor and record changes in a SQL Server
database, at the database file level, and periodically send these changes to
a remote server where they're applied to matching files. In essence, it's
kind of up-to-the-minute backup of the database.
I am unsure about how this software is going to perform and/or affect the
database and I'm very interested in hearing from anyone who has experience
with this software.
Any information, thoughts and opinions regarding this tool is greatly
appreciated.
LouHi
They do not state on their case studies exactly what OS's and Database
products are supported. Not a word about SQL Server on their site.
Ask the vendor if they have certified their product for SQL Server.
And don't forget, picking up the bits off disk, shipping them over a
connection, does induce performance limitations, and if your data were to go
corrupt on the local drive, the corruption is faithfully copied to them.
A service like this does not eliminate the need for regular Database and Log
dumps.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Louis Marchand" <lmarch@.safetrans.com> wrote in message
news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
> Hi Everyone,
> I'm investigating a software called Live Vault (http://www.livevault.com)
> whose purpose is to continuously monitor and record changes in a SQL
> Server
> database, at the database file level, and periodically send these changes
> to
> a remote server where they're applied to matching files. In essence, it's
> kind of up-to-the-minute backup of the database.
> I am unsure about how this software is going to perform and/or affect the
> database and I'm very interested in hearing from anyone who has experience
> with this software.
> Any information, thoughts and opinions regarding this tool is greatly
> appreciated.
> Lou
>|||Mike,
Thank you very much for your input.
I do nightly full database backups and hourly transaction log backups during
business hours every day and copy these backups onto tape each night. This
leaves a potential one-day data loss in case of catastrophic failure.
Management sees Live Vault as a way to have an "up-to-the-minute" database
backup. Our systems group has had success using Live Vault to restore basic
user files e.g. Word documents or PDF documents, that sort of thing.
However, I am very suspicious of a product that monitors live SQL Server
data files. It sounds wonderful in theory but I've always been very leary
of the kind of bit level monitoring that's required.
I am really hoping someone on the newsgroup is using or has used the product
and could give a first hand account of their experiences. If there's anyone
out there reading this, I'd love to hear your honest assessment of the
product, any problems you've had and the support you received from Live
Vault addressing problems.
Best regards,
Lou
Louis Marchand
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etHYsWZTFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Hi
> They do not state on their case studies exactly what OS's and Database
> products are supported. Not a word about SQL Server on their site.
> Ask the vendor if they have certified their product for SQL Server.
> And don't forget, picking up the bits off disk, shipping them over a
> connection, does induce performance limitations, and if your data were to
go
> corrupt on the local drive, the corruption is faithfully copied to them.
> A service like this does not eliminate the need for regular Database and
Log
> dumps.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Louis Marchand" <lmarch@.safetrans.com> wrote in message
> news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
> > Hi Everyone,
> > I'm investigating a software called Live Vault
(http://www.livevault.com)
> > whose purpose is to continuously monitor and record changes in a SQL
> > Server
> > database, at the database file level, and periodically send these
changes
> > to
> > a remote server where they're applied to matching files. In essence,
it's
> > kind of up-to-the-minute backup of the database.
> >
> > I am unsure about how this software is going to perform and/or affect
the
> > database and I'm very interested in hearing from anyone who has
experience
> > with this software.
> >
> > Any information, thoughts and opinions regarding this tool is greatly
> > appreciated.
> > Lou
> >
> >
>

Anyone Use Live Vault?

Hi Everyone,
I'm investigating a software called Live Vault (http://www.livevault.com)
whose purpose is to continuously monitor and record changes in a SQL Server
database, at the database file level, and periodically send these changes to
a remote server where they're applied to matching files. In essence, it's
kind of up-to-the-minute backup of the database.
I am unsure about how this software is going to perform and/or affect the
database and I'm very interested in hearing from anyone who has experience
with this software.
Any information, thoughts and opinions regarding this tool is greatly
appreciated.
LouHi
They do not state on their case studies exactly what OS's and Database
products are supported. Not a word about SQL Server on their site.
Ask the vendor if they have certified their product for SQL Server.
And don't forget, picking up the bits off disk, shipping them over a
connection, does induce performance limitations, and if your data were to go
corrupt on the local drive, the corruption is faithfully copied to them.
A service like this does not eliminate the need for regular Database and Log
dumps.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Louis Marchand" <lmarch@.safetrans.com> wrote in message
news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
> Hi Everyone,
> I'm investigating a software called Live Vault (http://www.livevault.com)
> whose purpose is to continuously monitor and record changes in a SQL
> Server
> database, at the database file level, and periodically send these changes
> to
> a remote server where they're applied to matching files. In essence, it's
> kind of up-to-the-minute backup of the database.
> I am unsure about how this software is going to perform and/or affect the
> database and I'm very interested in hearing from anyone who has experience
> with this software.
> Any information, thoughts and opinions regarding this tool is greatly
> appreciated.
> Lou
>|||Mike,
Thank you very much for your input.
I do nightly full database backups and hourly transaction log backups during
business hours every day and copy these backups onto tape each night. This
leaves a potential one-day data loss in case of catastrophic failure.
Management sees Live Vault as a way to have an "up-to-the-minute" database
backup. Our systems group has had success using Live Vault to restore basic
user files e.g. Word documents or PDF documents, that sort of thing.
However, I am very suspicious of a product that monitors live SQL Server
data files. It sounds wonderful in theory but I've always been very leary
of the kind of bit level monitoring that's required.
I am really hoping someone on the newsgroup is using or has used the product
and could give a first hand account of their experiences. If there's anyone
out there reading this, I'd love to hear your honest assessment of the
product, any problems you've had and the support you received from Live
Vault addressing problems.
Best regards,
Lou
Louis Marchand
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etHYsWZTFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Hi
> They do not state on their case studies exactly what OS's and Database
> products are supported. Not a word about SQL Server on their site.
> Ask the vendor if they have certified their product for SQL Server.
> And don't forget, picking up the bits off disk, shipping them over a
> connection, does induce performance limitations, and if your data were to
go
> corrupt on the local drive, the corruption is faithfully copied to them.
> A service like this does not eliminate the need for regular Database and
Log
> dumps.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Louis Marchand" <lmarch@.safetrans.com> wrote in message
> news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
(http://www.livevault.com)[vbcol=seagreen]
changes[vbcol=seagreen]
it's[vbcol=seagreen]
the[vbcol=seagreen]
experience[vbcol=seagreen]
>