As an instructor I always tell my students to make a performance baseline on their SQL Server so that they have something to compare against, when (not if) the users complain about performance. But my students and customers often ask – which counters should I monitor then? Well here is, to my experi ...

47 days ago · SQLGuy · blog.sqlguy.dk by Rasmus Glibstrup ()

There are a lot of cases in which we as developers want to know how much free memory is there (or the state of some of the other system resources). This can be used for deciding whether we can handle another request, or is there enough memory (and CPU of course) to start some background work meanwhi ...

106 days ago · Vesko Kolev's Blog · veskokolev.blogspot.com by Vesko Kolev

There are a lot of cases in which we as developers want to know how much free memory is there (or the state of some of the other system resources). This can be used for deciding whether we can handle another request, or is there enough memory (and CPU of course) to start some background work meanwhi ...

106 days ago · Vesko Kolev's Blog · veskokolev.blogspot.com by Vesko Kolev

perfproc 는 Process 의 성능카운터 수집에 문제가 있는 경우인데요,. 주로 서버 로드가 매우 높은 경우에 발생하곤 합니다. 물론 로드에 해당하는 부분이 꼭 CPU 만은 아니고요,. 해당 이벤트가 발생하는 시점에 어떤 작업이나 서버 리소스 상태가 어떤 상태인지 먼저 파악해 보는게 좋을것 같습니다. 그냥,. 단지 오류로그가 안뜨게 하고 싶다면 레지스트리에서 성능카운터 수집을 disable 하면 되느데요,. 그렇게 하면 해당 성능카운터를 이용할수 없거나,. 해당 카운터를 이용하는 관련 프로그램에도 오류가 나겠지요.. HKEY ...

144 days ago · 서버주무르기 · wssplex.net by WSSplex 1 reference