SQL Server 2000 EE SP3a.
Through PerfMon the sql server specific perfomance
counters are not displayed. I have revisited the
installation CD and per the installation SQL Server
Components/Performance Counters SubComponent are installed.
Any Ideas on how I can see these counters. This is a
production machine so all maintenance is late night.
TIA,hi,
take a look at this
article
http://support.microsoft.com/?id=152513
>--Original Message--
>SQL Server 2000 EE SP3a.
>Through PerfMon the sql server specific perfomance
>counters are not displayed. I have revisited the
>installation CD and per the installation SQL Server
>Components/Performance Counters SubComponent are
installed.
>Any Ideas on how I can see these counters. This is a
>production machine so all maintenance is late night.
>TIA,
>.
>|||I have looked at this article. Again the only counters
that do not show up are the SQL Server specific counters.
Joe
>--Original Message--
>hi,
>take a look at this
>article
>http://support.microsoft.com/?id=152513
>>--Original Message--
>>SQL Server 2000 EE SP3a.
>>Through PerfMon the sql server specific perfomance
>>counters are not displayed. I have revisited the
>>installation CD and per the installation SQL Server
>>Components/Performance Counters SubComponent are
>installed.
>>Any Ideas on how I can see these counters. This is a
>>production machine so all maintenance is late night.
>>TIA,
>>.
>.
>|||Did you restart the server before looking at the perfmon,
To get u'r counters back just restart the entire system
and look at it
>--Original Message--
>I have looked at this article. Again the only counters
>that do not show up are the SQL Server specific counters.
>Joe
>>--Original Message--
>>hi,
>>take a look at this
>>article
>>http://support.microsoft.com/?id=152513
>>--Original Message--
>>SQL Server 2000 EE SP3a.
>>Through PerfMon the sql server specific perfomance
>>counters are not displayed. I have revisited the
>>installation CD and per the installation SQL Server
>>Components/Performance Counters SubComponent are
>>installed.
>>Any Ideas on how I can see these counters. This is a
>>production machine so all maintenance is late night.
>>TIA,
>>.
>>.
>.
>
Showing posts with label specific. Show all posts
Showing posts with label specific. Show all posts
Friday, March 23, 2012
Performance counters
Performance counters
I have noticed that on my server (on which I am a 'co'-
administrator), the SQL Server specific performance
counters are not available in the performance monitoring
tool. Did I overlook something when I installed SQL
Server? (My development server does in fact show these
performance counters.) Or, could they have been removed?
If so, how? And, finally, can I get them in there without
having to re-install SQL Server?
Any assistance/feedback is greatly appreciated.> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
See my answer on microsoft.public.sqlserver.setup
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Ask your 'co'-administrator what had he/she ran on that server before you
started SQL Server setup.
It seems like you missed one or two error messages in Windows NT Error Log
when you were installing SQL Server.
It might be one of those HP/Compaq "smart monitoring utilities" that holds
perfh009.dat and/or perfc009.dat files.
Check the following article with your 'co'-administrator and be careful if
this is a production server.
http://support.microsoft.com/defaul...kb;en-us;300956
Regards,
Igor
"/.dz" <anonymous@.discussions.microsoft.com> wrote in message
news:d61901c3ef48$efda49d0$a401280a@.phx.gbl...
> Performance counters
> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
> Any assistance/feedback is greatly appreciated.
>
I have noticed that on my server (on which I am a 'co'-
administrator), the SQL Server specific performance
counters are not available in the performance monitoring
tool. Did I overlook something when I installed SQL
Server? (My development server does in fact show these
performance counters.) Or, could they have been removed?
If so, how? And, finally, can I get them in there without
having to re-install SQL Server?
Any assistance/feedback is greatly appreciated.> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
See my answer on microsoft.public.sqlserver.setup
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Ask your 'co'-administrator what had he/she ran on that server before you
started SQL Server setup.
It seems like you missed one or two error messages in Windows NT Error Log
when you were installing SQL Server.
It might be one of those HP/Compaq "smart monitoring utilities" that holds
perfh009.dat and/or perfc009.dat files.
Check the following article with your 'co'-administrator and be careful if
this is a production server.
http://support.microsoft.com/defaul...kb;en-us;300956
Regards,
Igor
"/.dz" <anonymous@.discussions.microsoft.com> wrote in message
news:d61901c3ef48$efda49d0$a401280a@.phx.gbl...
> Performance counters
> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
> Any assistance/feedback is greatly appreciated.
>
Performance counters
Performance counters
I have noticed that on my server (on which I am a 'co'-
administrator), the SQL Server specific performance
counters are not available in the performance monitoring
tool. Did I overlook something when I installed SQL
Server? (My development server does in fact show these
performance counters.) Or, could they have been removed?
If so, how? And, finally, can I get them in there without
having to re-install SQL Server?
Any assistance/feedback is greatly appreciated.> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
See my answer on microsoft.public.sqlserver.setup
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Ask your 'co'-administrator what had he/she ran on that server before you
started SQL Server setup.
It seems like you missed one or two error messages in Windows NT Error Log
when you were installing SQL Server.
It might be one of those HP/Compaq "smart monitoring utilities" that holds
perfh009.dat and/or perfc009.dat files.
Check the following article with your 'co'-administrator and be careful if
this is a production server.
http://support.microsoft.com/default.aspx?scid=kb;en-us;300956
Regards,
Igor
"/.dz" <anonymous@.discussions.microsoft.com> wrote in message
news:d61901c3ef48$efda49d0$a401280a@.phx.gbl...
> Performance counters
> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
> Any assistance/feedback is greatly appreciated.
>
I have noticed that on my server (on which I am a 'co'-
administrator), the SQL Server specific performance
counters are not available in the performance monitoring
tool. Did I overlook something when I installed SQL
Server? (My development server does in fact show these
performance counters.) Or, could they have been removed?
If so, how? And, finally, can I get them in there without
having to re-install SQL Server?
Any assistance/feedback is greatly appreciated.> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
See my answer on microsoft.public.sqlserver.setup
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Ask your 'co'-administrator what had he/she ran on that server before you
started SQL Server setup.
It seems like you missed one or two error messages in Windows NT Error Log
when you were installing SQL Server.
It might be one of those HP/Compaq "smart monitoring utilities" that holds
perfh009.dat and/or perfc009.dat files.
Check the following article with your 'co'-administrator and be careful if
this is a production server.
http://support.microsoft.com/default.aspx?scid=kb;en-us;300956
Regards,
Igor
"/.dz" <anonymous@.discussions.microsoft.com> wrote in message
news:d61901c3ef48$efda49d0$a401280a@.phx.gbl...
> Performance counters
> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
> Any assistance/feedback is greatly appreciated.
>
Saturday, February 25, 2012
PerfMon- SQL Server:Databases counter
I'm trying to get some specific transactions/sec info on one of the
databases on an enterprise-wide SQL Server that has 120 databases on it.
It's SQL Server 2000 sp3a running on Win2k3 sp1.
In Performance Monitor, I am selecting the object SQLServer:Databases
and the Transactions/sec counter, I am only able to see 99 of the 120
databases available on the server. See kb 330088. The workaround in
the kb article is to install named instances which is not an acceptable
solution. Has anyone else run into this problem? What have you done to
get around it?
Thank you.
Toni
*** Sent via Developersdex http://www.codecomments.com ***
I checked this on Windows 2003 system monitor as well, and the problem is
still there. I am not sure if there's any other way out.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Toni" <teibner@.SQLallina.com> wrote in message
news:u3SamtejFHA.1416@.TK2MSFTNGP09.phx.gbl...
I'm trying to get some specific transactions/sec info on one of the
databases on an enterprise-wide SQL Server that has 120 databases on it.
It's SQL Server 2000 sp3a running on Win2k3 sp1.
In Performance Monitor, I am selecting the object SQLServer:Databases
and the Transactions/sec counter, I am only able to see 99 of the 120
databases available on the server. See kb 330088. The workaround in
the kb article is to install named instances which is not an acceptable
solution. Has anyone else run into this problem? What have you done to
get around it?
Thank you.
Toni
*** Sent via Developersdex http://www.codecomments.com ***
databases on an enterprise-wide SQL Server that has 120 databases on it.
It's SQL Server 2000 sp3a running on Win2k3 sp1.
In Performance Monitor, I am selecting the object SQLServer:Databases
and the Transactions/sec counter, I am only able to see 99 of the 120
databases available on the server. See kb 330088. The workaround in
the kb article is to install named instances which is not an acceptable
solution. Has anyone else run into this problem? What have you done to
get around it?
Thank you.
Toni
*** Sent via Developersdex http://www.codecomments.com ***
I checked this on Windows 2003 system monitor as well, and the problem is
still there. I am not sure if there's any other way out.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Toni" <teibner@.SQLallina.com> wrote in message
news:u3SamtejFHA.1416@.TK2MSFTNGP09.phx.gbl...
I'm trying to get some specific transactions/sec info on one of the
databases on an enterprise-wide SQL Server that has 120 databases on it.
It's SQL Server 2000 sp3a running on Win2k3 sp1.
In Performance Monitor, I am selecting the object SQLServer:Databases
and the Transactions/sec counter, I am only able to see 99 of the 120
databases available on the server. See kb 330088. The workaround in
the kb article is to install named instances which is not an acceptable
solution. Has anyone else run into this problem? What have you done to
get around it?
Thank you.
Toni
*** Sent via Developersdex http://www.codecomments.com ***
PerfMon- SQL Server:Databases counter
I'm trying to get some specific transactions/sec info on one of the
databases on an enterprise-wide SQL Server that has 120 databases on it.
It's SQL Server 2000 sp3a running on Win2k3 sp1.
In Performance Monitor, I am selecting the object SQLServer:Databases
and the Transactions/sec counter, I am only able to see 99 of the 120
databases available on the server. See kb 330088. The workaround in
the kb article is to install named instances which is not an acceptable
solution. Has anyone else run into this problem? What have you done to
get around it?
Thank you.
Toni
*** Sent via Developersdex http://www.codecomments.com ***I checked this on Windows 2003 system monitor as well, and the problem is
still there. I am not sure if there's any other way out.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Toni" <teibner@.SQLallina.com> wrote in message
news:u3SamtejFHA.1416@.TK2MSFTNGP09.phx.gbl...
I'm trying to get some specific transactions/sec info on one of the
databases on an enterprise-wide SQL Server that has 120 databases on it.
It's SQL Server 2000 sp3a running on Win2k3 sp1.
In Performance Monitor, I am selecting the object SQLServer:Databases
and the Transactions/sec counter, I am only able to see 99 of the 120
databases available on the server. See kb 330088. The workaround in
the kb article is to install named instances which is not an acceptable
solution. Has anyone else run into this problem? What have you done to
get around it?
Thank you.
Toni
*** Sent via Developersdex http://www.codecomments.com ***
databases on an enterprise-wide SQL Server that has 120 databases on it.
It's SQL Server 2000 sp3a running on Win2k3 sp1.
In Performance Monitor, I am selecting the object SQLServer:Databases
and the Transactions/sec counter, I am only able to see 99 of the 120
databases available on the server. See kb 330088. The workaround in
the kb article is to install named instances which is not an acceptable
solution. Has anyone else run into this problem? What have you done to
get around it?
Thank you.
Toni
*** Sent via Developersdex http://www.codecomments.com ***I checked this on Windows 2003 system monitor as well, and the problem is
still there. I am not sure if there's any other way out.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Toni" <teibner@.SQLallina.com> wrote in message
news:u3SamtejFHA.1416@.TK2MSFTNGP09.phx.gbl...
I'm trying to get some specific transactions/sec info on one of the
databases on an enterprise-wide SQL Server that has 120 databases on it.
It's SQL Server 2000 sp3a running on Win2k3 sp1.
In Performance Monitor, I am selecting the object SQLServer:Databases
and the Transactions/sec counter, I am only able to see 99 of the 120
databases available on the server. See kb 330088. The workaround in
the kb article is to install named instances which is not an acceptable
solution. Has anyone else run into this problem? What have you done to
get around it?
Thank you.
Toni
*** Sent via Developersdex http://www.codecomments.com ***
PerfMon- SQL Server:Databases counter
I'm trying to get some specific transactions/sec info on one of the
databases on an enterprise-wide SQL Server that has 120 databases on it.
It's SQL Server 2000 sp3a running on Win2k3 sp1.
In Performance Monitor, I am selecting the object SQLServer:Databases
and the Transactions/sec counter, I am only able to see 99 of the 120
databases available on the server. See kb 330088. The workaround in
the kb article is to install named instances which is not an acceptable
solution. Has anyone else run into this problem? What have you done to
get around it?
Thank you.
Toni
*** Sent via Developersdex http://www.developersdex.com ***I checked this on Windows 2003 system monitor as well, and the problem is
still there. I am not sure if there's any other way out.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Toni" <teibner@.SQLallina.com> wrote in message
news:u3SamtejFHA.1416@.TK2MSFTNGP09.phx.gbl...
I'm trying to get some specific transactions/sec info on one of the
databases on an enterprise-wide SQL Server that has 120 databases on it.
It's SQL Server 2000 sp3a running on Win2k3 sp1.
In Performance Monitor, I am selecting the object SQLServer:Databases
and the Transactions/sec counter, I am only able to see 99 of the 120
databases available on the server. See kb 330088. The workaround in
the kb article is to install named instances which is not an acceptable
solution. Has anyone else run into this problem? What have you done to
get around it?
Thank you.
Toni
*** Sent via Developersdex http://www.developersdex.com ***
databases on an enterprise-wide SQL Server that has 120 databases on it.
It's SQL Server 2000 sp3a running on Win2k3 sp1.
In Performance Monitor, I am selecting the object SQLServer:Databases
and the Transactions/sec counter, I am only able to see 99 of the 120
databases available on the server. See kb 330088. The workaround in
the kb article is to install named instances which is not an acceptable
solution. Has anyone else run into this problem? What have you done to
get around it?
Thank you.
Toni
*** Sent via Developersdex http://www.developersdex.com ***I checked this on Windows 2003 system monitor as well, and the problem is
still there. I am not sure if there's any other way out.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Toni" <teibner@.SQLallina.com> wrote in message
news:u3SamtejFHA.1416@.TK2MSFTNGP09.phx.gbl...
I'm trying to get some specific transactions/sec info on one of the
databases on an enterprise-wide SQL Server that has 120 databases on it.
It's SQL Server 2000 sp3a running on Win2k3 sp1.
In Performance Monitor, I am selecting the object SQLServer:Databases
and the Transactions/sec counter, I am only able to see 99 of the 120
databases available on the server. See kb 330088. The workaround in
the kb article is to install named instances which is not an acceptable
solution. Has anyone else run into this problem? What have you done to
get around it?
Thank you.
Toni
*** Sent via Developersdex http://www.developersdex.com ***
Monday, February 20, 2012
Perf Mon creating large temp files
I am using a remote connection to connect to a specific server (13B) and I a
m
running a trace from there against another server (138). I have a template t
o
track performance points and am saving the results to a table. My problem is
that when I run this trace, I also am creating a very large set of tmp files
on the local C drive of 13B. The files are named nst1.tmp,prf3.tmp,prf4.tmp.
The C drive space is not very large so I max out the space quickly. I am
looking for a way to point the tmp files to another drive or elimate them
altogether.
ThanksNever go directly to a table. Place the files on a local hard drive first
and then import them later. Otherwise you will incur more overhead than you
need to. If you want to import Perfmon files take a look at the Logman.exe
utility.
Andrew J. Kelly SQL MVP
"MNDiver" <MNDiver@.discussions.microsoft.com> wrote in message
news:1F3F9BF1-5D66-4882-83A2-19C28F1522B1@.microsoft.com...
>I am using a remote connection to connect to a specific server (13B) and I
>am
> running a trace from there against another server (138). I have a template
> to
> track performance points and am saving the results to a table. My problem
> is
> that when I run this trace, I also am creating a very large set of tmp
> files
> on the local C drive of 13B. The files are named
> nst1.tmp,prf3.tmp,prf4.tmp.
> The C drive space is not very large so I max out the space quickly. I am
> looking for a way to point the tmp files to another drive or elimate them
> altogether.
> Thanks
m
running a trace from there against another server (138). I have a template t
o
track performance points and am saving the results to a table. My problem is
that when I run this trace, I also am creating a very large set of tmp files
on the local C drive of 13B. The files are named nst1.tmp,prf3.tmp,prf4.tmp.
The C drive space is not very large so I max out the space quickly. I am
looking for a way to point the tmp files to another drive or elimate them
altogether.
ThanksNever go directly to a table. Place the files on a local hard drive first
and then import them later. Otherwise you will incur more overhead than you
need to. If you want to import Perfmon files take a look at the Logman.exe
utility.
Andrew J. Kelly SQL MVP
"MNDiver" <MNDiver@.discussions.microsoft.com> wrote in message
news:1F3F9BF1-5D66-4882-83A2-19C28F1522B1@.microsoft.com...
>I am using a remote connection to connect to a specific server (13B) and I
>am
> running a trace from there against another server (138). I have a template
> to
> track performance points and am saving the results to a table. My problem
> is
> that when I run this trace, I also am creating a very large set of tmp
> files
> on the local C drive of 13B. The files are named
> nst1.tmp,prf3.tmp,prf4.tmp.
> The C drive space is not very large so I max out the space quickly. I am
> looking for a way to point the tmp files to another drive or elimate them
> altogether.
> Thanks
Subscribe to:
Posts (Atom)