Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Resource Governor Bug Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2014 2:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 1:21 AM
Points: 12, Visits: 59
Has anyone notice a bug on the 2008 version of resource governor, where the reported CPU usage is different when you run test query on the server itself and on another PC connecting to the server?

This is a 2 core server.
When i run 2 different load on the server itself via SSMS, i can see from performance monitor that the 2 load is taking 50% CPU each.
When i run 2 different load on the PC however, performance monitor is showing only 50% CPU shared by the 2 load.

I am very sure that the 2 load had landed on different scheduler.

Anyone kind enough to help me do a quick test on their environment?
Post #1597190
Posted Tuesday, July 29, 2014 6:19 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 1:21 AM
Points: 12, Visits: 59
Anyone encounter similar issues?
Post #1597536
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse