search

microsoft / CRM-Performance-Toolkit

The Microsoft Dynamics CRM 2015 Performance Toolkit was created by the Microsoft CRM product team to formalize performance testing of Microsoft CRM 2013 and later releases. The performance toolkit can be used by the Microsoft CRM partners and customers to collect data to support their CRM deployment decisions.
44 stars 18 forks source link

SQL EMDB Loader #17

Open andrescolodrero opened 8 years ago

andrescolodrero commented 8 years ago

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 commented 8 years ago

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/Microsoft/CRM-Performance-Toolkit/issues/17.

jeffreyzhzhang commented 8 years ago

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.com<mailto: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.com<mailto: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 https://github.com/Microsoft/CRM-Performance-Toolkit/issues/17#issuecomment-172946090 .

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

andrescolodrero commented 8 years ago

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 commented 8 years ago

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/Microsoft/CRM-Performance-Toolkit/issues/17#issuecomment-173164447.

andrescolodrero commented 8 years ago

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 commented 8 years ago

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 commented 8 years ago

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/Microsoft/CRM-Performance-Toolkit/issues/17#issuecomment-174455864.

andrescolodrero commented 8 years ago

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.