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,
jc
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=20
> taking part of a transaction log and load testing the server from a =
remote=20
> location. We are trying to get around some licensing issues by the use =
of=20
> only one centralized database. I do not have access to the source for =
the=20
> application so I can not optimize it for use over a wan. It makes no =
use of=20
> 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=20
> to a remote destination and be able to run those transactions from the =

> remote site.
>=20
> whew,
> jc=20
>=20
>
|||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...
> of
> log
>

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
> >
> >
>

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=20
> taking part of a transaction log and load testing the server from a =
remote=20
> location. We are trying to get around some licensing issues by the use =
of=20
> only one centralized database. I do not have access to the source for =
the=20
> application so I can not optimize it for use over a wan. It makes no =
use of=20
> 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=20
> to a remote destination and be able to run those transactions from the =

> remote site.
>=20
> whew,
> jc=20
>=20
>|||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 sta
tements themselves. You can have a
DELETE which modifies 1000 rows. This will be logged as 1000 delete log reco
rds 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.p
hx.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 databa
se
> 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...
> of
> log
>

PLZZ HELP ! ERROR CONNECTING TO SQL SERVER

Hello everybody

i am getting problem in connecting my asp.net(c#) web application with Sql Server 2000 programatically on the page load of my web form

I wrote following code in the page load

private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page
SqlConnection myConnection = new SqlConnection("server=(local);database=master;Integrated Security=SSPI");
SqlDataAdapter myCommand = new SqlDataAdapter("select * from emp", myConnection);

DataSet ds = new DataSet();
myCommand.Fill(ds, "emp");

DataGrid1.DataSource=ds.Tables["emp"].DefaultView;
DataGrid1.DataBind();
}

Build OK but following exception occurred:

Server Error in '/datagridtest' Application.
------------------------

Login failed for user 'MATRIX\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'MATRIX\ASPNET'.

Source Error:

Line 27:
Line 28: DataSet ds = new DataSet();
Line 29: myCommand.Fill(ds, "emp"); //THIS APPEARS IN RED ON THE PAGE
Line 30:
Line 31: DataGrid1.DataSource=ds.Tables["emp"].DefaultView;

----------------------------
PLZ HELP ME, I THINK THE PROBLEM IS WITH CONNECTIONSTRING, I STUCK UP HERE FROM LAST 3 DAYS AND COULD NOT PROCEED WITH MY FURTHER STUDY AND PRACTICE

THANX IN ADVANCE

BSSGlad you got this worked out!view post 806235

plz help me how to give reportname in Reportexecutionservice

Hi

Im trying to load a report using

Reportexecutionservice

like this

Reportexecutionservice.ExecutionInfo exinfo=res.LoadReport(reportname, null);

rptname consists of report which is present @. my server.How to give reportname inorder to load a report .im using reportingservice2005

plz do help me.

error im getting Unable to indentify the report.Plz tell what is path i should given in order to acces th report..

It needs to be the path to the report, not just the name. So if your report named "MyReport" is in a folder named "Reports", then the path would be "/MyReport/Reports".

|||

Hai,

thnx for reply.Well all reports r present in Server.i mean We had created couple of Report using Businessintelligence studio .we try to deploy reports @. our server.So how to access those reports

With regards,

mahender

|||Browse to http://servername/reports. That will show you the Report Manager application which will let you navigate around and find the path to the published reports. From code, you can accomplish this using the ListChildren() method.|||HI,
Thnx for once again .Ha u said to search the path from reportmanager.I open my server as
(10.150.100.184:100/report) I saw my reports deployed how abt path there r actually stored .i need to give actuall we give reportpathname as "reportdirectory\reportname" similary for Report @. my server how can i access is it like"\\10.150.142.186\reportdirectory\reportname".Im i right

Plz do replyme...

With regards,
mahender

plz help me how to give reportname in Reportexecutionservice

Hi

Im trying to load a report using

Reportexecutionservice

like this

Reportexecutionservice.ExecutionInfo exinfo=res.LoadReport(reportname, null);

rptname consists of report which is present @. my server.How to give reportname inorder to load a report .im using reportingservice2005

plz do help me.

error im getting Unable to indentify the report.Plz tell what is path i should given in order to acces th report..

It needs to be the path to the report, not just the name. So if your report named "MyReport" is in a folder named "Reports", then the path would be "/MyReport/Reports".

|||

Hai,

thnx for reply.Well all reports r present in Server.i mean We had created couple of Report using Businessintelligence studio .we try to deploy reports @. our server.So how to access those reports

With regards,

mahender

|||Browse to http://servername/reports. That will show you the Report Manager application which will let you navigate around and find the path to the published reports. From code, you can accomplish this using the ListChildren() method.|||HI,
Thnx for once again .Ha u said to search the path from reportmanager.I open my server as
(10.150.100.184:100/report) I saw my reports deployed how abt path there r actually stored .i need to give actuall we give reportpathname as "reportdirectory\reportname" similary for Report @. my server how can i access is it like"\\10.150.142.186\reportdirectory\reportname".Im i right

Plz do replyme...

With regards,
mahender