Performance Monitor

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Brian Shannon (bshannon_at_lbrspec.com)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 13:32:21 -0500

I posted something similiar in microsoft.public.sqlprogramming group and
then realized I should have cross posted. Although I didn't get much
results in the SQL group so hopefully you guys can help a rookie.

I am wanting to begin collecting performance data on my SQL server 2000 box
loaded on a Windows 2000 server. I have done a lot of reading on Performance
Monitor and found the counters I
want to track. Also, I have learned to run Performance Monitor on a remote
machine.

Has anyone had success with this? I am using my test server which is an
exact replica of my production server to try and track performance data.
When I go to select the computer on my test server to monitor only the local
machine is listed. So I type in the name of the name of the targeted server
and I keep getting an error saying computer not found!

Do you need to be on a domain. We are not on a windows domain for most of
our stuff is on a Novell server. Although my SQL box is on the windows 2000
server which is ran from a workgroup.

Both my machines are on the same workgroup. I went into the Performance
Logs and Alerts service and changed the start up from localsystem to a
Administrators login on the remote machine gathering the data.

Do I need to set up any login info on the targeted server?

Any suggestions from people who have encountered this. It is probably
something really stupid.

Thanks!

Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)