SQL EMDB Loader

[andrescolodrero]

hi @jeffreyzhzhang

I finished the setup. I have a big CRM Organization DB for testing (>300GB).
Do i need to run EMDB loader?

It is possible to skp this step?

[jeffreyzhzhang]

Unfortunately you need to run EMDB loader prior to the perf testing.

From: Guybrush [mailto:notifications@github.com]
Sent: Tuesday, January 19, 2016 7:41 AM
To: Microsoft/CRM-Performance-Toolkit CRM-Performance-Toolkit@noreply.github.com
Cc: Jeffrey Zhang zhzhan@microsoft.com
Subject: [CRM-Performance-Toolkit] SQL EMDB Loader (#17)

hi @jeffreyzhzhanghttps://github.com/jeffreyzhzhang

I finished the setup. I have a big CRM Organization DB for testing (>300GB).
Do i need to run EMDB loader?

It is possible to skp this step?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/17.

[jeffreyzhzhang]

From the documentation:
Populate the EntityManager Database
To keep the tests realistic, it is not advisable for the test infrastructure to touch the CRM databases directly during the test runs. For this reason, all the pre-requisite data used by the performance tests is copied to a local database on the Client from the CRM database servers. This database is called EntityManager database. The EntityManager database is created by the CRM Performance Toolkit setup process. The copying of the data from the CRM databases to the EntityManager database can be done running the EMDBLoader.exe which is a part of the CRM_Perf_Toolkit solution.

From: Guybrush [mailto:notifications@github.com]
Sent: Tuesday, January 19, 2016 10:52 AM
To: Microsoft/CRM-Performance-Toolkit CRM-Performance-Toolkit@noreply.github.com
Cc: Jeffrey Zhang zhzhan@microsoft.com
Subject: Re: [CRM-Performance-Toolkit] SQL EMDB Loader (#17)

Thanks,
I thought i could use the data of the existing organization, so i could do
the load test over that organization (that includes plugins,solutions,etc).

But as the tutorial mentioned,it should be enought data.
El 19/1/2016 18:41, "jeffreyzhzhang" <notifications@github.commailto:notifications@github.com> escribió:

Unfortunately you need to run EMDB loader prior to the perf testing.

From: Guybrush [mailto:notifications@github.com]
Sent: Tuesday, January 19, 2016 7:41 AM
To: Microsoft/CRM-Performance-Toolkit <
CRM-Performance-Toolkit@noreply.github.commailto:CRM-Performance-Toolkit@noreply.github.com>
Cc: Jeffrey Zhang <zhzhan@microsoft.commailto:zhzhan@microsoft.com>
Subject: [CRM-Performance-Toolkit] SQL EMDB Loader (#17)

hi @jeffreyzhzhanghttps://github.com/jeffreyzhzhang

I finished the setup. I have a big CRM Organization DB for testing
(>300GB).
Do i need to run EMDB loader?

It is possible to skp this step?

—
Reply to this email directly or view it on GitHub<
https://github.com/Microsoft/CRM-Performance-Toolkit/issues/17>.

—
Reply to this email directly or view it on GitHub
#17 (comment)
.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/17#issuecomment-172949640.

[andrescolodrero]

Hi @jeffreyzhzhang ,
Sorry my question was not correct...

could i use an existing Organization for the Load Test?
I guess i would need to apply an array of existing users with Data instead of "crmtestxx" users.

[jeffreyzhzhang]

I am not sure how your existing org is like. It is possible to run the perf test against an existing org; but there might be lots of tweaks involved. Are you working with anyone from Microsoft?

From: Guybrush [mailto:notifications@github.com]
Sent: Wednesday, January 20, 2016 2:31 AM
To: Microsoft/CRM-Performance-Toolkit CRM-Performance-Toolkit@noreply.github.com
Cc: Jeffrey Zhang zhzhan@microsoft.com
Subject: Re: [CRM-Performance-Toolkit] SQL EMDB Loader (#17)

Hi @jeffreyzhzhanghttps://github.com/jeffreyzhzhang ,
Sorry my question was not correct...

could i use an existing Organization for the Load Test?
I guess i would need to apply an array of existing users with Data instead of "crmtestxx" users.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/17#issuecomment-173164447.

[andrescolodrero]

The organization has several plugins and solutions that could affect performance.
But it would be ok to test our CRM structure (backends, frontends, database, f5 load balancer, etc).
I will give a try with a new organization and load the DB with your toolkit.

looking forward to make it work!

I work with MS partner.

[andrescolodrero]

Hi @jeffreyzhzhang
Could you let me know the steps to populate a Organization?

Reading the documentation, if i understand i have to:

1. DataPopulation: I run on my computer DataPopulation_5UserBaseline.ps1. This will generate DATA for an empty organization in CRM SQL Server. right?

Im calling the script with DataPopulation_5UserBaseline.ps1 CRM2015SP1

and i get this error:
Exception calling "Start" with "0" argument(s): "The system cannot find the file specified"

1. EMDBLoader. I will generate the EM database to a local database on the client (my computer).

If i run executable:
Connecting to EntityManager SQL: Application Name=CRM_Perf_BenchMark;Server=MyClient\CRM;Initial Catalog=EntityManager;Integrated Security=sspi
Connected to Entity Manager SQL Database
Failure in loading EMDB from CRM. Error msg: Cannot find the object "Account" because it does not exist or you do not have permissions.

i guess it is failing because it doesnt find the previous populated DB.

Thanks for your time.

[jeffreyzhzhang]

Please try the DataPopulation_320UserBaseline.ps1 in the same location. 5-user org data was created exclusively for online deployment. I’ll clean up the 5-user related scripts and data xml files soon.

If you need prompt response, please ask help from your Microsoft Contact/Partner.

From: Guybrush [mailto:notifications@github.com]
Sent: Monday, January 25, 2016 1:58 AM
To: Microsoft/CRM-Performance-Toolkit CRM-Performance-Toolkit@noreply.github.com
Cc: Jeffrey Zhang zhzhan@microsoft.com
Subject: Re: [CRM-Performance-Toolkit] SQL EMDB Loader (#17)

Hi @jeffreyzhzhanghttps://github.com/jeffreyzhzhang
Could you let me know the steps to populate a Organization?

Reading the documentation, if i understand i have to:

1. DataPopulation: I run on my computer DataPopulation_5UserBaseline.ps1. This will generate DATA for an empty organization in CRM SQL Server. right?

Im calling the script with DataPopulation_5UserBaseline.ps1 CRM2015SP1

and i get this error:
Exception calling "Start" with "0" argument(s): "The system cannot find the file specified"

1. EMDBLoader. I will generate the EM database to a local database on the client (my computer).

If i run executable:
Connecting to EntityManager SQL: Application Name=CRM_Perf_BenchMark;Server=MyClient\CRM;Initial Catalog=EntityManager;Integrated Security=sspi
Connected to Entity Manager SQL Database
Failure in loading EMDB from CRM. Error msg: Cannot find the object "Account" because it does not exist or you do not have permissions.

i guess it is failing because it doesnt find the previous populated DB.

Thanks for your time.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/17#issuecomment-174455864.

[andrescolodrero]

hi @jeffreyzhzhang
I want to woirk withan MS partner, however they are busy until end of Februar.
I guess this toolkit is probably just for MS Partners?
IM trying to set this up myself.

The DataPopulation_320UserBaseline.ps1 seems to work but i need to check what it does in the background because it runs but only create the table "Person" in EM.

I´ll to my MS partner to be availble.. in the meantime i will try to do this myself.