High CPU Usage Caused by SQL Server

[@fbifido2]

Say you buy an account or business application (eg: Quick Books, PCLaw, etc...) that uses SQL Server 2017/2019/2022, you install the client side on 20 to 50 users workstation.
- how can you look at the SQL Server to see if:
a. The SQL Server needs more RAM, CPU or IOP's ?
b. The SQL Server needs a faster network connection?
c. The Client Application is the problem they maybe facing ?

[@fbifido2]

Can you also show us the SQL Server counters if that same or somewhat modify SQL-script would run from 3 to 5 computers connect to that sql server ?

[@wowerman]

Nicely explained. How can you limit SQL?

[@fbifido2]

Can you run the SQL workload from another computer, and show us the SQL Server counters?

[@TheUttamkumarbagchi]

what about high memory usage caused by SQL Server?

[@VimalPatel-ek8pb]

Really helpful Amit sir

[@NakeDr]

Yeah, it's handy sometimes to quickly assess what's what. I run it through PS

[@fbifido2]

Love this video

[@ITSupportOdisha]

Thanx a lot Sir

[@mallikamaragani7691]

Thank you sir

[@amigoscanariosdeclashofclan]

Nice , thanks

[@AmitKumar-pl4qm]

Nice one

[@ashiskumar1863]

Nice