Need help with SQL Server performance issues

vivek101

Hello everyone,

I'm currently experiencing performance issues with my SQL Server and I'm hoping to get some help in troubleshooting and resolving the issue. Here's some information about my setup:

SQL Server version: [SQL 2019]

Operating system: [Windows 10]

CPU: [intel 11th Gen]

RAM: [8 GB]

The issue I'm facing is that queries are taking longer than usual to execute and the database seems to be running slower overall. I've already tried some basic troubleshooting steps such as checking for blocked queries and optimizing indexes, but the issue persists.

I'm hoping someone can point out the slowdown's root cause and offer some advice on how to fix it. I would be very grateful for any assistance.

Thank you in advance!

TeunvdBiggelaar

Can you show your queryplan? and some more decent specs? Overall 8GB memory is not much specially if this is shared with your windows OS.