SearchDiagnostics/CollectionDbSearchDiagnostics.ps1 log dir is created inside sql script folder

[sqdavid]

Hi.
This is not a bug, but a simple fix to make CollectionDBSearchDiagnostics.ps1 behave like ConfigurationDBSearchDiagnostics.ps1
The first script creates the log folder inside the SQL scripts folder instead of creating it in the root, as the second script does.

https://github.com/Microsoft/Code-Search/blob/3be409ea44ce2a58e5936f6534b4273b0d5b51e4/SearchDiagonistics/CollectionDBSearchDiagnostics.ps1#L20

If the sugestion is accepted and you are busy I could make a PR, since it is quite simple.

Regards

[bittusarkar]

@sqdavid The bug actually is the usage of $PWD instead of $PSScriptRoot. If this is fixed, the log folder will always be created in the SearchDiagnostics folder. There are a lot of places in our scripts where this bug is present. We would love for you to send a PR.