Hot answers tagged performance-counters
5
The asterisk stands for "All Instances," which includes _Total where applicable.
Perfmon is probably the easiest place to look at the counters and see what's available on your system.
From the documentation for typeperf:
•Counter path format
The general format for counter paths is as follows: [\\Computer]\object[parent/instance#index]\counter] where:
...
3
To take advantage of the extra RAM you need to enable PAE as well as AWE.
http://support.microsoft.com/?kbid=283037
Additionally, you should allow the account that is running your SQL services the "lock pages in memory" option.
http://msdn.microsoft.com/en-us/library/ms190730.aspx
The Buffer Cache Hit Ratio value isn't that far out of bounds. You generally ...
2
First you need to understand that RAM usage is related to but not the same as memory usage. See my answer to this question for an explanation of how memory works in windows. That being said the counter that measures physical ram in use (commmit charge peak) is \Memory\Committed Bytes. You should see page faults long before the system actually uses up all ...
2
Check your stop condition. In order to have a report for each day (rather than one report for multiple days), I'm pretty sure you would need to restart your performance counter. The counter will run for as long as you have it configured for in stop condition. Check the logman command for automating via command line.
2
see How do I tell if my Windows server is swapping? . In general the thing to worry about is the working set of the application. You want to ensure that the working set will fit in ram without having to force other applications to start to page fault. Windows doesn't allocate physical ram directly to an application. (there are ways to effectively do ...
2
You can create perfmon counters using .NET code and thus using PowerShell too. A moderate amount of coding is required.
2
Which performance counters matter the most, when judging server load?
Almost all of them , but you should probably start with CPU %,Private working sets and IOPS.
is it a performance concern if one leaves such data-collectors running
indefinitely?
Yes mainly I/O , memory ,cpu , disk space. Mostly in that order.
I will not know when the ...
1
Are you speaking of the sys.dm_os_performance_counters DMV ?
You need to grant the SQL Server login the VIEW SERVER STATE permission.
GRANT VIEW SERVER STATE to [performance_user]
This will also give the user account access to all other DMV's, & may not be granular enough. Simply granting SELECT permission on the view doesn't work!!
If you want to ...
1
The definition seems pretty straightforward?
Requests/Sec = number of requests processed over a one-second period
Requests Current = number of currently executing requests (i.e. at the instant in time at which it's sampled)
If your ISAPI takes less than a second to process a request, you can squeeze more requests through in a second than are executing at ...
1
You don't specify what type of check you have Pingdom performing. However, my guess is you are doing an HTTP check. In this case Pingdom issues a full HTTP request for your site and the response time is the total time of the request to be sent, received, acknowledged, and for data to fully transfer. So the 1100-1200ms you see is the combination of the ...
Only top voted, non community-wiki answers of a minimum length are eligible
