DBSrv11 Only 1-2 Active Requests -gn 20-100

[Former Member]

Hi there, I'm using Perfmon to monitor my database server's performance, and i'm noticing that "Requests: Active" doesn't go any higher than 2.

VM with 4 processors, 2 cores each, 32GB of Memory.

Database 11.01 x64: -gt 2 -gtc 8 -gn 100, license only allows for 2 CPUs, so i'm going to modify the VM to be 2 CPU with 4 cores each. (Experimenting for best performance)

The requests element is sometimes well in to the thousands, but only 2 requests remain active at any given moment.

I would like to see a lot more active requests open because the server's resources aren't really being used and users complain of slow searches, etc.

Another question I had in regards to remoteput waits. When this number increases, does the server basically pause until the remote client receives all of the data? Would high remoteput waits slow performance down for all users or just the user receiving the data?

Thanks so much for the help.

[Breck_Carter]

Confirm that perfmon is telling the truth by running this query: SELECT PROPERTY ( 'ActiveReq' );

The 'Req' property is cumulative so it's pretty meaningless unless you compute changes over time (requests per second), which is something Foxhound does for you...

ActiveReq = 2 indicates a server that is either idle or starved for resources... sometimes "starved for resources" can be explained by inappropriate VM settings or usage.

[Former Member]

Thanks Breck, I'm going to look deeper in to the stats this week.