Pointy Headed Boss

I have this dilbert kinda boss. He wants to know if there is a tool for
taking part of a transaction log and load testing the server from a remote
location. We are trying to get around some licensing issues by the use of
only one centralized database. I do not have access to the source for the
application so I can not optimize it for use over a wan. It makes no use of
the server everything is clientside. So to make a long story short the
pointy head boss wants to know if he can run tests here, take the trans log
to a remote destination and be able to run those transactions from the
remote site.
whew,
jcNot the transaction log, but you can run a trace using profiler and =then replay the trace at a remote site.
Mike John
"John Cantley" <kayjohn59@.sbcglobal.net> wrote in message =news:u1any%23wJEHA.1192@.TK2MSFTNGP11.phx.gbl...
> I have this dilbert kinda boss. He wants to know if there is a tool =for > taking part of a transaction log and load testing the server from a =remote > location. We are trying to get around some licensing issues by the use =of > only one centralized database. I do not have access to the source for =the > application so I can not optimize it for use over a wan. It makes no =use of > the server everything is clientside. So to make a long story short the =
> pointy head boss wants to know if he can run tests here, take the =trans log > to a remote destination and be able to run those transactions from the =
> remote site.
> > whew,
> jc > >|||Just adding to Mike's suggestion a little..
It's actually better to use profiler than any log analysis tool as the log
doesn't give you the selects - it only gives you the updates to the database
which is of course, only part of the load testing you're trying to perform.
Profiler gives you the selects as well, so it's necessarily a better
approach than analysing the log..
Regards,
Greg Linwood
SQL Server MVP
"Mike John" <Mike.John@.knowledgepool.spamtrap.com> wrote in message
news:OTYeqYxJEHA.1096@.TK2MSFTNGP10.phx.gbl...
Not the transaction log, but you can run a trace using profiler and then
replay the trace at a remote site.
Mike John
"John Cantley" <kayjohn59@.sbcglobal.net> wrote in message
news:u1any%23wJEHA.1192@.TK2MSFTNGP11.phx.gbl...
> I have this dilbert kinda boss. He wants to know if there is a tool for
> taking part of a transaction log and load testing the server from a remote
> location. We are trying to get around some licensing issues by the use of
> only one centralized database. I do not have access to the source for the
> application so I can not optimize it for use over a wan. It makes no use
of
> the server everything is clientside. So to make a long story short the
> pointy head boss wants to know if he can run tests here, take the trans
log
> to a remote destination and be able to run those transactions from the
> remote site.
> whew,
> jc
>|||And just to add a tiny bit to that:
The log only contains the effect of the modification statements. Not the statements themselves. You can have a
DELETE which modifies 1000 rows. This will be logged as 1000 delete log records in the transaction log.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message news:uS6GxizJEHA.3276@.TK2MSFTNGP12.phx.gbl...
> Just adding to Mike's suggestion a little..
> It's actually better to use profiler than any log analysis tool as the log
> doesn't give you the selects - it only gives you the updates to the database
> which is of course, only part of the load testing you're trying to perform.
> Profiler gives you the selects as well, so it's necessarily a better
> approach than analysing the log..
> Regards,
> Greg Linwood
> SQL Server MVP
> "Mike John" <Mike.John@.knowledgepool.spamtrap.com> wrote in message
> news:OTYeqYxJEHA.1096@.TK2MSFTNGP10.phx.gbl...
> Not the transaction log, but you can run a trace using profiler and then
> replay the trace at a remote site.
> Mike John
> "John Cantley" <kayjohn59@.sbcglobal.net> wrote in message
> news:u1any%23wJEHA.1192@.TK2MSFTNGP11.phx.gbl...
> > I have this dilbert kinda boss. He wants to know if there is a tool for
> > taking part of a transaction log and load testing the server from a remote
> > location. We are trying to get around some licensing issues by the use of
> > only one centralized database. I do not have access to the source for the
> > application so I can not optimize it for use over a wan. It makes no use
> of
> > the server everything is clientside. So to make a long story short the
> > pointy head boss wants to know if he can run tests here, take the trans
> log
> > to a remote destination and be able to run those transactions from the
> > remote site.
> >
> > whew,
> > jc
> >
> >
>