| Author |
Topic |
|
MorrisK
Yak Posting Veteran
83 Posts |
 Posted - 2007-11-15 : 13:49:53
|
| I'm new to server monitoring but some things I've read say it's a good idea to do it remotely.The problem is that my workstation is a Vista machine and our server is Win2003 and SQL Server 2000. When I open the Vista Reliability and Performance Monitor and connect to my SQL server and try to add counters, it looks like the SQL specific counters are not available. There are many others listed, just not the SQL ones that I see when in Performance Monitor on the server.Can anyone tell me if this is possible? Is this just due to an incompatability? Thanks,Kevin |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-15 : 15:52:48
|
| counters are installed when sql server is installed. you have to run perfmon on the server._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-15 : 16:14:29
|
quote:
Originally posted by spirit1
counters are installed when sql server is installed. you have to run perfmon on the server.
That shouldn't be the case and is not recommended. PerfMon should be run from a client machine. It does not require SQL Server to be installed on the client to see the SQL Server counters from a remote database server. You just have to change the computer to \\ServerName to remotely monitor it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-15 : 16:16:12
|
| hmm... so why don't i have sql counters on one of our win xp machines that don't have sql server installed?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-15 : 16:33:43
|
quote:
Originally posted by tkizer
quote:
Originally posted by spirit1
counters are installed when sql server is installed. you have to run perfmon on the server.
That shouldn't be the case and is not recommended. PerfMon should be run from a client machine. It does not require SQL Server to be installed on the client to see the SQL Server counters from a remote database server. You just have to change the computer to \\ServerName to remotely monitor it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
I don't know. Works fine for me (I just verified it too).EDIT: I should rephrase this. When I say it works fine for me, I mean I first have to switch the computer to \\SQLServerName, wait for it to load the counters, then I can see all available counters including SQL Server ones. SQL counters won't be available if you point computer to the local one if SQL Server is not installed but they will be once you switch it to a server that does.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-15 : 16:34:21
|
| As for the OP's question though, I'm not sure if it's a problem with Vista or not. I don't have a Vista machine where I can test this. We are strictly on XP or 2003.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-15 : 16:43:10
|
| i'll check that... thanx tara._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-11-15 : 17:38:12
|
is this a 32bit/64bit issue? if you are running 64bit OS on your SQL Server, remote perfmon access will only see the 64bit process counters. SQL 2000 is 32bit, so the only way to get at the 32bit counters is to run the 32bit perfmon locally on the server from the syswow64 folder.if this isn't a 32bit/64bit issue you can ignore what I just said  -ec |
|
|
|
MorrisK
Yak Posting Veteran
83 Posts |
Posted - 2009-04-06 : 12:34:35
|
| I'm revisiting this. I still have not been able to get this to work from my workstation but would really like to.Here's what I've done so far - 1)In help it says "You can build a Data Collector Set from a custom combination of Data Collectors. These Data Collectors can include Performance Counters, Configuration data, or data from Trace Providers.Membership in the local Performance Log Users or Administrators group, or equivalent, is the minimum required to complete this procedure."So I added my username in the form of (domain\username) to the Performance Log Users and Performance Monitor Users groups (and Administrators for good measure).2)Connected Reliability And Performance Monitor to the remote computer (the SQL server)3)Ran the Create new Data Collector Set Wizard specifying our SQL 2000 server name when selecting counters. For testing I added the SQLServer:Buffer Manager-Buffer Cache Hit Ratio. 4)In the Root Directory I enter C:\PerfLogs intending for this to be my workstation. I want to save the log file on my computer, not the server. 5)Clicked Finish without specifying a Run As user.6)Clicked Run. It runs!However, the problem now is that it is saving the log file on the server instead of the workstation! If I look at the properties, Directory tab it says C:\PerfLogs and if I click the Browse button it appears to be looking at my C:\ drive.How do I get it to save the log on my computer???Kevin |
|
|
|
|
Vista Perf Mon for SQL 2000 server?