Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

HI All,

First up, I'm a total newb at Performance Monitoring. I'm looking to set up central performance monitoring of some boxes.

  • 2K3 TS ( Monitor General OS Perf & Session Specific Counters )
  • 2K8 R2 ( XenApp 6 = Monitor General OS Perf & Session Specific Counters )
  • File Server ( Standard File I/O )

My ultimate aim is to get as many counters/information, without impacting the clients session experience at all. Including counters specific to their sessions.

I was thinking it logging directly to a SQL on another server, instead of a two part process of blg file then relog to sql.

Would that work ok? Does anyone know the overhead of going straight to SQL from the client?

I've searched around a bit, but havent found so much information it can be overwhelming.

thanks

share|improve this question

1 Answer 1

up vote 2 down vote accepted

We log from perfmon into SQL and have collected 10s of millions of datapoints this way. I've never noticed any appreciatable overheads, and it's great to have the data immediately available.

share|improve this answer
    
same opinion here. Haven't noticed perf impact of remote perfmon on Server 2008 or newer. –  Bret Fisher Mar 15 '11 at 1:00
    
Awesome, just the info I was after. Thanks. –  StuartC Mar 16 '11 at 7:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.