Using TypePerf to get performance data on the command prompt.

re: Using TypePerf to get performance data on the command prompt.

Kurt — Sat, 04 Apr 2009 00:32:52 GMT

I have moved to a Vista business laptop. I have both sql 2008 dev and express installed. I can use the sql counters in performance monitor but when I execute "typeperf -q" from command prompt, I get a long list of counters but no SQL counters.

I have seen cases where sql counters weren't installed on a machine but they are clearly installed because I can use them in the UI version of perfmon.

thanks,

Kurt

re: Using TypePerf to get performance data on the command prompt.

BooRadely — Tue, 12 Aug 2008 18:51:53 GMT

Hey Techguy, I don't know if typeperf is the best solution. I'd use WMI to pull the data perhaps from more than one server. Check out the post I did on scriptomatic. Using this you should be able to do what you want quite easily.

Using TypePerf to get performance data on the command prompt.

techguy — Mon, 11 Aug 2008 15:11:30 GMT

Hey brad I need to script typeperf in such a way that we can use it to find avg cpu usage on about 50 servers. Do you think its possible. Need help ! Thanks a ton!

re: Using TypePerf to get performance data on the command prompt.

BooRadely — Sat, 15 Mar 2008 00:50:57 GMT

Jim, just give me an exmaple of what you're trying to do and I'll see if I have an example around.

re: Using TypePerf to get performance data on the command prompt.

Jim Cauble — Thu, 13 Mar 2008 21:11:14 GMT

This is great, I, too, am a big fan of the command prompt, and really like to batch these up for automating the task.

Maybe you can provide some examples of the most useful operands you have used?