greyfox
greyfox
PostsComments
CC#
Created by Cryy on 5/25/2025 in #help
High SQL Server memory usage with EF6 composite key batch existence check
Generally you pay for execution speed with memory usage, unless the script was pulling back a horrifying amount of data.
34 replies
CC#
Created by Cryy on 5/25/2025 in #help
High SQL Server memory usage with EF6 composite key batch existence check
If there are some joins you could try moving parts of the where clause into the joins. If there are subqueries you could try moving those out of the query.
34 replies
CC#
Created by Cryy on 5/25/2025 in #help
High SQL Server memory usage with EF6 composite key batch existence check
Once you get the SQL scripts you could look at the execution plan and see if there are any table scans being done.
34 replies
CC#
Created by Cryy on 5/25/2025 in #help
High SQL Server memory usage with EF6 composite key batch existence check
Dunno, you'd have to examine the precise SQL being executed. Have you tried monitoring it with SQL Profiler?
34 replies
CC#
Created by Cryy on 5/25/2025 in #help
High SQL Server memory usage with EF6 composite key batch existence check
SQL Server will typically try to grab as much memory as possible by default regardless of how much is actually needed. 90%+ is normal enough.
34 replies
CC#
Created by Cryy on 5/25/2025 in #help
High SQL Server memory usage with EF6 composite key batch existence check
Why is the memory usage a problem?
34 replies
CC#
Created by 03xej on 5/18/2025 in #help
✅ vscode c# dev tools is there a way to run faster
One of the messages emitted is that it checked for packages to restore. Was there one to restore, it would have been downloaded.
34 replies
CC#
Created by 03xej on 5/18/2025 in #help
✅ vscode c# dev tools is there a way to run faster
You'll start pulling down nuget packages.
34 replies
CC#
Created by 03xej on 5/18/2025 in #help
✅ vscode c# dev tools is there a way to run faster
Get a faster computer and faster Internet connectivity.
34 replies
CC#
Created by Pavan on 5/4/2025 in #help
C# PigLatin exercise : tests failing for Rule 3 and Rule 4
Have you set breakpoints and stepped through the code?
12 replies
CC#
Created by ItsTrapp3r on 5/3/2025 in #help
Rock Paper Scissors error
After a quick google: https://github.com/dotnet/android/issues/9133
6 replies
CC#
Created by RobG66 on 4/30/2025 in #help
Enumerating "Open With" applications and populating a menu
What problem are you having?
20 replies
CC#
Created by eddyrick on 3/3/2025 in #help
Concurrency issues - distributed system
Might be a good idea to remove the triggers and consolidate the business rules in the application
7 replies
CC#
Created by eddyrick on 3/3/2025 in #help
Concurrency issues - distributed system
Have you sharded your db?
7 replies
CC#
Created by eddyrick on 3/3/2025 in #help
Concurrency issues - distributed system
Have you read Designing Data Intensive Applications? https://www.amazon.com/Designing-Data-Intensive-Applications-Reliable-Maintainable/dp/B08VL1BLHB/
7 replies
CC#
Created by eddyrick on 3/3/2025 in #help
Concurrency issues - distributed system
Dumb question, but I assume you've already added a shedload of resources to the database server(s)? What kind of setup do you already have?
7 replies
CC#
Created by πR on 3/2/2025 in #help
Dotnet webapi test failing on GitHub Workflow
I may have been wrong, console may be correct for this.
32 replies
CC#
Created by πR on 3/2/2025 in #help
Dotnet webapi test failing on GitHub Workflow
Follow the steps here: https://docs.github.com/en/actions/monitoring-and-troubleshooting-workflows/monitoring-workflows/using-workflow-run-logs#viewing-logs-to-diagnose-failures
32 replies
CC#
Created by πR on 3/2/2025 in #help
Dotnet webapi test failing on GitHub Workflow
No
32 replies
CC#
Created by πR on 3/2/2025 in #help
Dotnet webapi test failing on GitHub Workflow
Ok, if it's running locally then the text file it'll be logged on your local machine on whatever file path you designate as the log folder
32 replies