Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SqlServer Operations too slow in Ubuntu #2280

Closed
TejasPatadiya10 opened this issue Dec 19, 2023 · 6 comments
Closed

SqlServer Operations too slow in Ubuntu #2280

TejasPatadiya10 opened this issue Dec 19, 2023 · 6 comments
Labels
⏳ Waiting for Customer Issues/PRs waiting for user response/action. ℹ️ Needs more Info Issues that have insufficient information to pursue investigations

Comments

@TejasPatadiya10
Copy link

Currently we have one scenario where certain queries getting executed in windows in in 5 seconds and same queries are taking time of more than 2 minutes in Ubuntu linux.

We are using latest version of Microsoft.Data.SqlClient and we have also check that certain posts regarding the same in this repo and it shows that it is fixed but still we are facing this.

Please guide to avoid this slowness in Ubuntu.
@TejasPatadiya10 TejasPatadiya10 mentioned this issue Dec 19, 2023
Closed
@ErikEJ
Copy link
Contributor

ErikEJ commented Dec 19, 2023

Please provide a full repro demonstrating the issue.

@JRahnama JRahnama added the 🆕 Triage Needed For new issues, not triaged yet. label Dec 19, 2023
@kf-gonzalez kf-gonzalez added ℹ️ Needs more Info Issues that have insufficient information to pursue investigations ⏳ Waiting for Customer Issues/PRs waiting for user response/action. and removed 🆕 Triage Needed For new issues, not triaged yet. labels Dec 19, 2023
@TejasPatadiya10
Copy link
Author

We have figured it out, It was due to MARS set to true if we make it false it is working fine.

We can not eliminate MARS so please suggest the best possible way to run it fast in Ubuntu.

@Wraith2
Copy link
Contributor

Wraith2 commented Dec 28, 2023

Why is it impossible to remove usage of MARS? Generally I consider any code written to require mars to be bad code.

@kf-gonzalez
Copy link

We would still need some repro information in order to investigate the issue

@kf-gonzalez
Copy link

This issue may be a duplicate of #422

@cheenamalhotra
Copy link
Member

Closing as duplicate of #422

@cheenamalhotra cheenamalhotra closed this as not planned Won't fix, can't repro, duplicate, stale Jul 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
⏳ Waiting for Customer Issues/PRs waiting for user response/action. ℹ️ Needs more Info Issues that have insufficient information to pursue investigations
Projects
SqlClient Triage Board
Status: Closed
Milestone
No milestone
Development

No branches or pull requests
6 participants
@ErikEJ @Wraith2 @cheenamalhotra @JRahnama @TejasPatadiya10 @kf-gonzalez