sql server performance issue due to tranlog,memory,cpu


I am getting performance issues while load testing is ramping up on the server

1.Transaction log is getting filled up
2.memory utilization is more
3.Cpu is pegged up to 100%

I need to pinpoint the issue for which what are the steps hould i follow.
Who is Participating?
momi_sabagConnect With a Mentor Commented:
if you think you can improve the queries that are coming in and get them to consume less resources, you should try that
otherwise, maybe you truly reached the limit of the server
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.