SQLH2

21 Apr 2006 7:34 AM

shawn.dba

I'm having issues with my SQLH2.PerfCollector not grabbing info for
Avg.DiskQueueLength from my prodSQLservers. Null data for over 50 servers.
All other data seems to be collected properly, and there are no related
errors in the gather logs. I read somewhere that you have to run 'diskperf'
from a command prompt to turn on queuelength info gathering, but I was under
the impression that Win2k and 2k3 server had this turned on by default. Any
help would be much appreciated.

--
Shawn Burton

21 Apr 2006 9:40 AM

privatenews

Hello Shawn,

In Windows 2000 the Physical Disk object is turned on by default and the
Logial Disk object is turned off by default.
You could run "diskperf" command to check the status of current status of
diskperf.

To enable the Diskperf service, try the following method:

1. Choose the Command Prompt icon in the Main group.
2. At the command prompt, type "DISKPERF -Y" (without the quotation marks)
and press ENTER. You will receive the following message: Disk performance
counters on this system are now set to start at boot. This change will take
effect after the system is rebooted.

253251 Using Diskperf in Windows 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;253251

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

22 Apr 2006 1:16 AM

Grigory Pogulsky (MS)

Shawn
This is a bug in .Net.
There is a KB article describing the problem
http://support.microsoft.com/default.aspx?scid=kb;en-us;324548

Unfortunately, we didn't know about it when we shipped the tool. But as it
stands right now nothing we can do about it.

Show quote

"shawn.dba" wrote:

> I'm having issues with my SQLH2.PerfCollector not grabbing info for
> Avg.DiskQueueLength from my prodSQLservers. Null data for over 50 servers.
> All other data seems to be collected properly, and there are no related
> errors in the gather logs. I read somewhere that you have to run 'diskperf'
> from a command prompt to turn on queuelength info gathering, but I was under
> the impression that Win2k and 2k3 server had this turned on by default. Any
> help would be much appreciated.
> --
> Shawn Burton