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.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 ***

No comments:

Post a Comment