I've got a couple of servers running SQL Server 2005 Enterprise and I'd like to monitor them remotely using Perfmon (Windows' Performance Monitor). On my machine, I have an instance of SQL Server ...
The counter, Process(sqlservr)\% Processor Time, is hovering around 300% on one of my database servers. This counter reflects the percent of total time SQL Server spent running on CPU (user mode + ...
Problem: I have a production server ( 64-bit Windows server 2003 R2 ), when i try to add Sql:Databases counter in the perfmon, it does not show me the recently added databases to select from. ...