February 14, 2022 at 4:28 pm
Hi All,
I want to find out non sql application / service / process that how much CPU is using it. Which counter I need to check to find non-sql application CPU usage.
Since both SQL and applications are in same server, could not find CPU is used by SQL or other application, whenever there is a slowness complaint I could see MS office is using 80% which is running more that 6 thread with PID, since our application is using MS office for printing.
February 14, 2022 at 8:02 pm
Ouch.
Based on my past experience, you'll continue to have trouble until you move all non-SQL-Server apps to different boxes. Not just CPU could be an issue, you could easily run into serious RAM issues if you allow other apps on the same box as SQL Server.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
February 14, 2022 at 11:27 pm
on top of using a non supported configuration - and potentially some licensing issues on that also (Office is not licensed to run on a server).
but that aside move that application to its own server and leave the box alone for SQL Server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply