Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Perf Mon


I am in a new position and at my new workplace, there are a variety of people
that log into the Sql Servers.  (2000 specifically)  How can I keep Perf Mon
up and running?  Whenever someone logs out, won't they kill whatever Perf Mon
log that I've set up?
Performance Monitor does not have to be running on the box being
monitored.  It works very well monitoring remotely, and in fact that
is the preferred situation when monitoring servers.  Servers should be
locked away from people, and nobody should normally be sitting at a
server.  I used to have a spare desktop in my workspace with one
PerfMon window running for each server I was responsible for.  If
there was any question about server status I simply had to turn my
head to have a very good idea of what was going on.

Roy Harvey
Beacon Falls, CT

On Tue, 5 Jun 2007 11:56:00 -0700, CLM <C@discussions.microsoft.com>
wrote:

Another option is to use the background perfmon service to log counter
values to .csv files which you can consume with SSIS or a custom program &
display on an intranet page for every one to see.

This is what we do with our servers..

Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
http://www.SQLBenchmarkPro.com

"CLM" <C@discussions.microsoft.com> wrote in message

news:BCC31304-B42F-4390-BADF-FDF3EA309978@microsoft.com...

Or you can purchase SQL Benchmark Pro from Mr. Linwood, and have a very
slick automated system to do profiling and more!!  :-))

--
TheSQLGuru
President
Indicium Resources, Inc.

"Greg Linwood" <g_linw@hotmail.com> wrote in message

news:OQc9gM8pHHA.4100@TK2MSFTNGP04.phx.gbl...

I tried to post this yesterday, but I think it went into computer oblivion:

I've started a new job with a bunch of Sql Servers (2000) and various admins
(with differing logins) log in and out of the server throughout the day.  How
can I keep Perf Mon running?  If I kick off a log in Perf Mon, won't it get
shut off the next time another admin logs on??  Is there any way around this?

-----------------------------------------------Reply-----------------------------------------------

Hey, thanks!

Only problem here is that SQLBenchmarkPro doesn't collect Perfmon data at
all (c:

SQLBenchmarkPro focusses on collecting & analysing SQLTrace data, to reveal
the CAUSE of the performance problems/s (which queries are running badly
against benchmarks) where Perfmon generally only shows higher level
diagnostics (high CPU, disk, memory etc) which are generally only the
consequences of poorly running queries..

Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
http://www.SQLBenchmarkPro.com

"TheSQLGuru" <kgbo@earthlink.net> wrote in message

news:%23eOuBsEqHHA.3952@TK2MSFTNGP03.phx.gbl...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc