Mercury LoadRunner

I am using MS SQL 2005. I am working with a consultant to load test my app.
I heard rumors that Mercury LoadRunner can't perform load testing on an app
that uses ADO/OLE DB.
Has anyone tried this? If so, do you have any links that I can look at?
Why would the app testing the app care what the app uses behind the scenes
to connect to the database? Should be completely transparent to the testing
app.
"Isaac Alexander" <isaacNOSPAM@.goNOSPAMprocura.com> wrote in message
news:eMTsq%23iJIHA.748@.TK2MSFTNGP04.phx.gbl...
>I am using MS SQL 2005. I am working with a consultant to load test my
>app.
> I heard rumors that Mercury LoadRunner can't perform load testing on an
> app
> that uses ADO/OLE DB.
> Has anyone tried this? If so, do you have any links that I can look at?
>
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OFEncAjJIHA.1620@.TK2MSFTNGP03.phx.gbl...
> Why would the app testing the app care what the app uses behind the scenes
> to connect to the database? Should be completely transparent to the
> testing app.
>
This is what I thought, but it supposedly traps the low level calls (DB
Calls) so the UI doesn't need to be opened. They are trying to see what
happens to the database server when 3500 users are hitting it from my app.
They record the calls, then replicate those calls over and over again.
sql

Mercury LoadRunner

I am using MS SQL 2005. I am working with a consultant to load test my app.
I heard rumors that Mercury LoadRunner can't perform load testing on an app
that uses ADO/OLE DB.
Has anyone tried this? If so, do you have any links that I can look at?Why would the app testing the app care what the app uses behind the scenes
to connect to the database? Should be completely transparent to the testing
app.
"Isaac Alexander" <isaacNOSPAM@.goNOSPAMprocura.com> wrote in message
news:eMTsq%23iJIHA.748@.TK2MSFTNGP04.phx.gbl...
>I am using MS SQL 2005. I am working with a consultant to load test my
>app.
> I heard rumors that Mercury LoadRunner can't perform load testing on an
> app
> that uses ADO/OLE DB.
> Has anyone tried this? If so, do you have any links that I can look at?
>|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OFEncAjJIHA.1620@.TK2MSFTNGP03.phx.gbl...
> Why would the app testing the app care what the app uses behind the scenes
> to connect to the database? Should be completely transparent to the
> testing app.
>
This is what I thought, but it supposedly traps the low level calls (DB
Calls) so the UI doesn't need to be opened. They are trying to see what
happens to the database server when 3500 users are hitting it from my app.
They record the calls, then replicate those calls over and over again.

Mercury LoadRunner

I am using MS SQL 2005. I am working with a consultant to load test my app.
I heard rumors that Mercury LoadRunner can't perform load testing on an app
that uses ADO/OLE DB.
Has anyone tried this? If so, do you have any links that I can look at?Why would the app testing the app care what the app uses behind the scenes
to connect to the database? Should be completely transparent to the testing
app.
"Isaac Alexander" <isaacNOSPAM@.goNOSPAMprocura.com> wrote in message
news:eMTsq%23iJIHA.748@.TK2MSFTNGP04.phx.gbl...
>I am using MS SQL 2005. I am working with a consultant to load test my
>app.
> I heard rumors that Mercury LoadRunner can't perform load testing on an
> app
> that uses ADO/OLE DB.
> Has anyone tried this? If so, do you have any links that I can look at?
>|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:OFEncAjJIHA.1620@.TK2MSFTNGP03.phx.gbl...
> Why would the app testing the app care what the app uses behind the scenes
> to connect to the database? Should be completely transparent to the
> testing app.
>
This is what I thought, but it supposedly traps the low level calls (DB
Calls) so the UI doesn't need to be opened. They are trying to see what
happens to the database server when 3500 users are hitting it from my app.
They record the calls, then replicate those calls over and over again.

Memory Usage of SQL Server Ce

Hi,

I'm wondering about the memory usage of SQL Server Ce and the Compact Framework.

I've heard I can use only 32 MB per process. SQL Server Ce runs in process and my database file is about 60 MB big.

1. Does that means, I can only use for my application:
32 MB - CLR - SQL-Server Runtime - parts of my database file hold in memory

2. Is SQL Server Ce swapping parts of my database file into my process memory?
If so, is there a chance to group some tables, that they are swapped together to increase
performance?

3. Means big databases big memory usage in my process memory?

Thanks,
Stefan
You only need SQL CE memory for your connection object and the data objects that you have currently loaded. The remaining database resides on disk.|||Thanks,
Stefan