Performance Object SQL Server

Hello
We are running W2003 Server with SQL Server 2000. Now I want to monitor
performance using the administrative tool Performance.
According to the SQL Server 2000 System Administration (Chapter 14), there
should be several SQL Server Performance Objects to track SQL server
activity, but...
I can't find them. What happend, where are they.
Anyone?
Thanks,
BartBart
I'm nbot sure uinderstand you. Click Start --Run --perfmon.
On the sceen right click and Add counters. There is Perfomance Object
combobox where you can choose many counters for SQL Server as well
"Bart Steur" <solnews@.xs4all.nl> wrote in message
news:%23EaGga8PHHA.404@.TK2MSFTNGP02.phx.gbl...
> Hello
> We are running W2003 Server with SQL Server 2000. Now I want to monitor
> performance using the administrative tool Performance.
> According to the SQL Server 2000 System Administration (Chapter 14), there
> should be several SQL Server Performance Objects to track SQL server
> activity, but...
> I can't find them. What happend, where are they.
> Anyone?
> Thanks,
> Bart
>|||Thats the problem, It should be there but it isn't.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OGHpRg8PHHA.3544@.TK2MSFTNGP03.phx.gbl...
> Bart
> I'm nbot sure uinderstand you. Click Start --Run --perfmon.
> On the sceen right click and Add counters. There is Perfomance Object
> combobox where you can choose many counters for SQL Server as well
>
>
>
>
> "Bart Steur" <solnews@.xs4all.nl> wrote in message
> news:%23EaGga8PHHA.404@.TK2MSFTNGP02.phx.gbl...
>|||Some Extra information (Had a chat with our System Administrator).
The W2003 Server runs 2 SQL servers. 1 SQL Server 2000 and another that came
with our backup program (BACKUPEXEC) to store backup information. The last
one I can see in the Performance Monitor. But that's not the one I would
like to monitor. Any idea how to get the objects of the other SQL server
into the performance monitor, or maybe how to swap them.
thanks
Bart|||Bart
http://support.microsoft.com/kb/227662
http://support.microsoft.com/kb/246328
"Bart Steur" <solnews@.xs4all.nl> wrote in message
news:uJzNb68PHHA.2312@.TK2MSFTNGP04.phx.gbl...
> Some Extra information (Had a chat with our System Administrator).
> The W2003 Server runs 2 SQL servers. 1 SQL Server 2000 and another that
> came with our backup program (BACKUPEXEC) to store backup information. The
> last one I can see in the Performance Monitor. But that's not the one I
> would like to monitor. Any idea how to get the objects of the other SQL
> server into the performance monitor, or maybe how to swap them.
> thanks
> Bart
>|||Those articles do not apply to SQLServer 2000.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eXynY$8PHHA.5012@.TK2MSFTNGP02.phx.gbl...
> Bart
> http://support.microsoft.com/kb/227662
> http://support.microsoft.com/kb/246328
> "Bart Steur" <solnews@.xs4all.nl> wrote in message
> news:uJzNb68PHHA.2312@.TK2MSFTNGP04.phx.gbl...
>|||Bart
You are right, my mistake, sorry
For detailed information, please reference the following article:
330088 BUG: SQLServer:Databases Performance Counters Limited to First 99
http://support.microsoft.com/?id=330088
SQL Server 2000 Performance Counters Do Not Appear in the Performance
http://support.microsoft.com/?id=827260
http://support.microsoft.com/?id=812915
"Bart Steur" <solnews@.xs4all.nl> wrote in message
news:u5fIPIGQHHA.2468@.TK2MSFTNGP06.phx.gbl...
> Those articles do not apply to SQLServer 2000.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eXynY$8PHHA.5012@.TK2MSFTNGP02.phx.gbl...
>|||Thanks Uri, but none of the provided solutions helped.
Maby it is because the SQL Server used by our Backup Program (BACKUPEXEC) is
a DESKTOP version.
The 'real' SQL Server used for our data is an ENTERPRISE edition.
FYI. I'm not interested in the performance of the DESKTOP version. So those
may be eliminated from the Perfmon.
By the way, the reason I'm so eager to see the performance, is because we
plugged in an additional 2GB (making it 4GB) and I can't see any difference
in (heavy) query speeds. So I lookup the tuning part in the SQLS2000 System
Administration book and that talked about the perfmon.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:udOdfOGQHHA.4172@.TK2MSFTNGP04.phx.gbl...
> Bart
> You are right, my mistake, sorry
> For detailed information, please reference the following article:
> 330088 BUG: SQLServer:Databases Performance Counters Limited to First 99
> http://support.microsoft.com/?id=330088
>
> SQL Server 2000 Performance Counters Do Not Appear in the Performance
> http://support.microsoft.com/?id=827260
> http://support.microsoft.com/?id=812915
>
> "Bart Steur" <solnews@.xs4all.nl> wrote in message
> news:u5fIPIGQHHA.2468@.TK2MSFTNGP06.phx.gbl...
>|||Bart

> By the way, the reason I'm so eager to see the performance, is because we
> plugged in an additional 2GB (making it 4GB) and I can't see any
> difference in (heavy) query speeds. So I lookup the tuning part in the
> SQLS2000 System Administration book and that talked about the perfmon.
I have my doubt that a 'bad' written query will perform better if you add
more memory. I'd run SQL Server Profiler to identify long running queries
and start tunning them
"Bart Steur" <solnews@.xs4all.nl> wrote in message
news:uWovibGQHHA.3624@.TK2MSFTNGP05.phx.gbl...
> Thanks Uri, but none of the provided solutions helped.
> Maby it is because the SQL Server used by our Backup Program (BACKUPEXEC)
> is a DESKTOP version.
> The 'real' SQL Server used for our data is an ENTERPRISE edition.
> FYI. I'm not interested in the performance of the DESKTOP version. So
> those may be eliminated from the Perfmon.
> By the way, the reason I'm so eager to see the performance, is because we
> plugged in an additional 2GB (making it 4GB) and I can't see any
> difference in (heavy) query speeds. So I lookup the tuning part in the
> SQLS2000 System Administration book and that talked about the perfmon.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:udOdfOGQHHA.4172@.TK2MSFTNGP04.phx.gbl...
>|||Hello Bart,
Can you pl. check the AWE option?
http://msdn2.microsoft.com/en-us/library/aa213764(SQL.80).aspx
Cheers,
MB
"Bart Steur" <solnews@.xs4all.nl> wrote in message
news:uWovibGQHHA.3624@.TK2MSFTNGP05.phx.gbl...
> Thanks Uri, but none of the provided solutions helped.
> Maby it is because the SQL Server used by our Backup Program (BACKUPEXEC)
> is a DESKTOP version.
> The 'real' SQL Server used for our data is an ENTERPRISE edition.
> FYI. I'm not interested in the performance of the DESKTOP version. So
> those may be eliminated from the Perfmon.
> By the way, the reason I'm so eager to see the performance, is because we
> plugged in an additional 2GB (making it 4GB) and I can't see any
> difference in (heavy) query speeds. So I lookup the tuning part in the
> SQLS2000 System Administration book and that talked about the perfmon.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:udOdfOGQHHA.4172@.TK2MSFTNGP04.phx.gbl...
>