I am looking for a tool that will help optimize TSQL and Stored Procedures
in SQL Server 2000. Can anybody recommend a good tool?
I need something that will scan a TSQL, Stored Procedure or View and
recommend optimizations.
Thanks.
Take a look at www.superiorsql.com
This is a tool to build sql statements on the fly, don't know whether this
tool has a performance-optimizer
Within query analyzer you can show the execution plan for each stored
procedure.
Open a new window in query analyzer and type execute myprocedurename ( type
an existing procedure name in the field myprocedurename)
The execution plan will show all scans to be performed and will give hints
to improve (for instance building extra indexes).
Performance-optimizing is the essence of a DBMS so I guess you have to use
the internal algorithms by using the execution plan of MSSQL
"Ed Willis" <ed_willis@.acsi.orgnospam> schreef in bericht
news:%23X682%234wEHA.2732@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that will help optimize TSQL and Stored Procedures
> in SQL Server 2000. Can anybody recommend a good tool?
> I need something that will scan a TSQL, Stored Procedure or View and
> recommend optimizations.
> Thanks.
>
|||Hi Ed,
Quest Software has a ton of tuning and optimization tools built into their
Quest Central for SQL Server product. You can get an older version as
freeware at http://www.quest.com/quest_central/s...ver/freeware/. Check out the
Database Analysis tool in the freeware product. The latest version has a
lot more SQL tuning tools where it will look at your SQL statements and
recommend much better performing queries. I'm not sure if that version is
in trialware or freeware yet.
Hope this helps,
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support the PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:%23X682%234wEHA.2732@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that will help optimize TSQL and Stored Procedures
> in SQL Server 2000. Can anybody recommend a good tool?
> I need something that will scan a TSQL, Stored Procedure or View and
> recommend optimizations.
> Thanks.
>
Showing posts with label tool. Show all posts
Showing posts with label tool. Show all posts
Friday, March 30, 2012
Performance Tool Question
I am looking for a tool that will help optimize TSQL and Stored Procedures
in SQL Server 2000. Can anybody recommend a good tool?
I need something that will scan a TSQL, Stored Procedure or View and
recommend optimizations.
Thanks.Take a look at www.superiorsql.com
This is a tool to build sql statements on the fly, don't know whether this
tool has a performance-optimizer
Within query analyzer you can show the execution plan for each stored
procedure.
Open a new window in query analyzer and type execute myprocedurename ( type
an existing procedure name in the field myprocedurename)
The execution plan will show all scans to be performed and will give hints
to improve (for instance building extra indexes).
Performance-optimizing is the essence of a DBMS so I guess you have to use
the internal algorithms by using the execution plan of MSSQL
"Ed Willis" <ed_willis@.acsi.orgnospam> schreef in bericht
news:%23X682%234wEHA.2732@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that will help optimize TSQL and Stored Procedures
> in SQL Server 2000. Can anybody recommend a good tool?
> I need something that will scan a TSQL, Stored Procedure or View and
> recommend optimizations.
> Thanks.
>|||Hi Ed,
Quest Software has a ton of tuning and optimization tools built into their
Quest Central for SQL Server product. You can get an older version as
freeware at www.quest.com/quest_central/sql_server/freeware/. Check out the
Database Analysis tool in the freeware product. The latest version has a
lot more SQL tuning tools where it will look at your SQL statements and
recommend much better performing queries. I'm not sure if that version is
in trialware or freeware yet.
Hope this helps,
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support the PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:%23X682%234wEHA.2732@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that will help optimize TSQL and Stored Procedures
> in SQL Server 2000. Can anybody recommend a good tool?
> I need something that will scan a TSQL, Stored Procedure or View and
> recommend optimizations.
> Thanks.
>
in SQL Server 2000. Can anybody recommend a good tool?
I need something that will scan a TSQL, Stored Procedure or View and
recommend optimizations.
Thanks.Take a look at www.superiorsql.com
This is a tool to build sql statements on the fly, don't know whether this
tool has a performance-optimizer
Within query analyzer you can show the execution plan for each stored
procedure.
Open a new window in query analyzer and type execute myprocedurename ( type
an existing procedure name in the field myprocedurename)
The execution plan will show all scans to be performed and will give hints
to improve (for instance building extra indexes).
Performance-optimizing is the essence of a DBMS so I guess you have to use
the internal algorithms by using the execution plan of MSSQL
"Ed Willis" <ed_willis@.acsi.orgnospam> schreef in bericht
news:%23X682%234wEHA.2732@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that will help optimize TSQL and Stored Procedures
> in SQL Server 2000. Can anybody recommend a good tool?
> I need something that will scan a TSQL, Stored Procedure or View and
> recommend optimizations.
> Thanks.
>|||Hi Ed,
Quest Software has a ton of tuning and optimization tools built into their
Quest Central for SQL Server product. You can get an older version as
freeware at www.quest.com/quest_central/sql_server/freeware/. Check out the
Database Analysis tool in the freeware product. The latest version has a
lot more SQL tuning tools where it will look at your SQL statements and
recommend much better performing queries. I'm not sure if that version is
in trialware or freeware yet.
Hope this helps,
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support the PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:%23X682%234wEHA.2732@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that will help optimize TSQL and Stored Procedures
> in SQL Server 2000. Can anybody recommend a good tool?
> I need something that will scan a TSQL, Stored Procedure or View and
> recommend optimizations.
> Thanks.
>
Performance Tool Question
I am looking for a tool that will help optimize TSQL and Stored Procedures
in SQL Server 2000. Can anybody recommend a good tool?
I need something that will scan a TSQL, Stored Procedure or View and
recommend optimizations.
Thanks.Take a look at www.superiorsql.com
This is a tool to build sql statements on the fly, don't know whether this
tool has a performance-optimizer
Within query analyzer you can show the execution plan for each stored
procedure.
Open a new window in query analyzer and type execute myprocedurename ( type
an existing procedure name in the field myprocedurename)
The execution plan will show all scans to be performed and will give hints
to improve (for instance building extra indexes).
Performance-optimizing is the essence of a DBMS so I guess you have to use
the internal algorithms by using the execution plan of MSSQL
"Ed Willis" <ed_willis@.acsi.orgnospam> schreef in bericht
news:%23X682%234wEHA.2732@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that will help optimize TSQL and Stored Procedures
> in SQL Server 2000. Can anybody recommend a good tool?
> I need something that will scan a TSQL, Stored Procedure or View and
> recommend optimizations.
> Thanks.
>|||Hi Ed,
Quest Software has a ton of tuning and optimization tools built into their
Quest Central for SQL Server product. You can get an older version as
freeware at www.quest.com/quest_central/sql_server/freeware/. Check out the
Database Analysis tool in the freeware product. The latest version has a
lot more SQL tuning tools where it will look at your SQL statements and
recommend much better performing queries. I'm not sure if that version is
in trialware or freeware yet.
Hope this helps,
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support the PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:%23X682%234wEHA.2732@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that will help optimize TSQL and Stored Procedures
> in SQL Server 2000. Can anybody recommend a good tool?
> I need something that will scan a TSQL, Stored Procedure or View and
> recommend optimizations.
> Thanks.
>sql
in SQL Server 2000. Can anybody recommend a good tool?
I need something that will scan a TSQL, Stored Procedure or View and
recommend optimizations.
Thanks.Take a look at www.superiorsql.com
This is a tool to build sql statements on the fly, don't know whether this
tool has a performance-optimizer
Within query analyzer you can show the execution plan for each stored
procedure.
Open a new window in query analyzer and type execute myprocedurename ( type
an existing procedure name in the field myprocedurename)
The execution plan will show all scans to be performed and will give hints
to improve (for instance building extra indexes).
Performance-optimizing is the essence of a DBMS so I guess you have to use
the internal algorithms by using the execution plan of MSSQL
"Ed Willis" <ed_willis@.acsi.orgnospam> schreef in bericht
news:%23X682%234wEHA.2732@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that will help optimize TSQL and Stored Procedures
> in SQL Server 2000. Can anybody recommend a good tool?
> I need something that will scan a TSQL, Stored Procedure or View and
> recommend optimizations.
> Thanks.
>|||Hi Ed,
Quest Software has a ton of tuning and optimization tools built into their
Quest Central for SQL Server product. You can get an older version as
freeware at www.quest.com/quest_central/sql_server/freeware/. Check out the
Database Analysis tool in the freeware product. The latest version has a
lot more SQL tuning tools where it will look at your SQL statements and
recommend much better performing queries. I'm not sure if that version is
in trialware or freeware yet.
Hope this helps,
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support the PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:%23X682%234wEHA.2732@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that will help optimize TSQL and Stored Procedures
> in SQL Server 2000. Can anybody recommend a good tool?
> I need something that will scan a TSQL, Stored Procedure or View and
> recommend optimizations.
> Thanks.
>sql
Saturday, February 25, 2012
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...
>
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...
>
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...
>> 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
>|||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...
>> 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
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...
>> 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
>>
>|||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...
>> 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...
>> 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
> 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...
>> 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...
>> 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
>>
>>
>>
>|||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...
>> 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...
>> 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
>>
>>
>>
>|||That would be the next step, but I got stuck at perfmon, because I couldn't
find any counters.
I'll skip to that part now, and hope to find info on the counters in the
mean time. If you have any more info, please let me know.
regards,
Bart
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23jD6leGQHHA.780@.TK2MSFTNGP03.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...
>> 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...
>> 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
>>
>>
>>
>>
>|||I've looked into this, but I don't think this option applies to my
situation. First we are using Window 2003 Server Standard, and second this
is for very large memory sizes. We only have 4 GB. But thanks for the
support. Any other suggestions are welcome.
Regards
Bart
"MB" <MB@.MB.com> wrote in message
news:uedn1jGQHHA.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...
>> 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...
>> 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
>>
>>
>>
>>
>|||Try here: http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.aspx
John
Bart Steur wrote:
> I've looked into this, but I don't think this option applies to my
> situation. First we are using Window 2003 Server Standard, and second this
> is for very large memory sizes. We only have 4 GB. But thanks for the
> support. Any other suggestions are welcome.
> Regards
> Bart
> "MB" <MB@.MB.com> wrote in message
> news:uedn1jGQHHA.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...
>>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...
>>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
>>>
>>
>>
>>
>|||Works like a charm. Thanks John John
"John John" <audetweld@.nbnet.nb.ca> wrote in message
news:OdafzcHQHHA.1380@.TK2MSFTNGP05.phx.gbl...
> Try here: http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.aspx
> John
> Bart Steur wrote:
>> I've looked into this, but I don't think this option applies to my
>> situation. First we are using Window 2003 Server Standard, and second
>> this is for very large memory sizes. We only have 4 GB. But thanks for
>> the support. Any other suggestions are welcome.
>> Regards
>> Bart
>> "MB" <MB@.MB.com> wrote in message
>> news:uedn1jGQHHA.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...
>>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...
>>>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
>>>
>>>
>>>
>>
>>|||You're welcome.
John
Bart Steur wrote:
> Works like a charm. Thanks John John
> "John John" <audetweld@.nbnet.nb.ca> wrote in message
> news:OdafzcHQHHA.1380@.TK2MSFTNGP05.phx.gbl...
>>Try here: http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.aspx
>>John
>>Bart Steur wrote:
>>
>>I've looked into this, but I don't think this option applies to my
>>situation. First we are using Window 2003 Server Standard, and second
>>this is for very large memory sizes. We only have 4 GB. But thanks for
>>the support. Any other suggestions are welcome.
>>Regards
>>Bart
>>"MB" <MB@.MB.com> wrote in message
>>news:uedn1jGQHHA.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...
>>
>>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...
>>>
>>>
>>>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
>>>
>>>
>>>
>
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...
>> 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
>|||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...
>> 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
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...
>> 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
>>
>|||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...
>> 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...
>> 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
> 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...
>> 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...
>> 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
>>
>>
>>
>|||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...
>> 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...
>> 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
>>
>>
>>
>|||That would be the next step, but I got stuck at perfmon, because I couldn't
find any counters.
I'll skip to that part now, and hope to find info on the counters in the
mean time. If you have any more info, please let me know.
regards,
Bart
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23jD6leGQHHA.780@.TK2MSFTNGP03.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...
>> 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...
>> 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
>>
>>
>>
>>
>|||I've looked into this, but I don't think this option applies to my
situation. First we are using Window 2003 Server Standard, and second this
is for very large memory sizes. We only have 4 GB. But thanks for the
support. Any other suggestions are welcome.
Regards
Bart
"MB" <MB@.MB.com> wrote in message
news:uedn1jGQHHA.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...
>> 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...
>> 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
>>
>>
>>
>>
>|||Try here: http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.aspx
John
Bart Steur wrote:
> I've looked into this, but I don't think this option applies to my
> situation. First we are using Window 2003 Server Standard, and second this
> is for very large memory sizes. We only have 4 GB. But thanks for the
> support. Any other suggestions are welcome.
> Regards
> Bart
> "MB" <MB@.MB.com> wrote in message
> news:uedn1jGQHHA.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...
>>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...
>>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
>>>
>>
>>
>>
>|||Works like a charm. Thanks John John
"John John" <audetweld@.nbnet.nb.ca> wrote in message
news:OdafzcHQHHA.1380@.TK2MSFTNGP05.phx.gbl...
> Try here: http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.aspx
> John
> Bart Steur wrote:
>> I've looked into this, but I don't think this option applies to my
>> situation. First we are using Window 2003 Server Standard, and second
>> this is for very large memory sizes. We only have 4 GB. But thanks for
>> the support. Any other suggestions are welcome.
>> Regards
>> Bart
>> "MB" <MB@.MB.com> wrote in message
>> news:uedn1jGQHHA.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...
>>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...
>>>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
>>>
>>>
>>>
>>
>>|||You're welcome.
John
Bart Steur wrote:
> Works like a charm. Thanks John John
> "John John" <audetweld@.nbnet.nb.ca> wrote in message
> news:OdafzcHQHHA.1380@.TK2MSFTNGP05.phx.gbl...
>>Try here: http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.aspx
>>John
>>Bart Steur wrote:
>>
>>I've looked into this, but I don't think this option applies to my
>>situation. First we are using Window 2003 Server Standard, and second
>>this is for very large memory sizes. We only have 4 GB. But thanks for
>>the support. Any other suggestions are welcome.
>>Regards
>>Bart
>>"MB" <MB@.MB.com> wrote in message
>>news:uedn1jGQHHA.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...
>>
>>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...
>>>
>>>
>>>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
>>>
>>>
>>>
>
Performance Monitors on 64bit OS
I am using a 3rd party tool to bind to the perf monitors, with no success. I
n
the event log:
Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
64-bit environment.
Contact the file vendor to obtain a 64-bit version.
Alternatively, you can open the 32-bit extensible counter DLL by using the
32-bit version
of Performance Monitor. To use this tool, open the Windows folder, open the
Syswow64 folder,
and then start Perfmon.exe.
I followed and can see the monitors on the local machine using the 64bit
perfmon. (they do not show on the stat > run > perfmon
The question: Any ideas how to force the 64bit monitors to present
themselves rather then the 32bit - which do not have the sql perf monitirs.
Heeeelp.
ThanksOK - I have got myself mixed up.
I need the 32bit (Syswow64) perfmon to respond to the 3rd party software
rather than the 64bit.
Cheers
"Mike Duncan" wrote:
> I am using a 3rd party tool to bind to the perf monitors, with no success.
In
> the event log:
> Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
> 64-bit environment.
> Contact the file vendor to obtain a 64-bit version.
> Alternatively, you can open the 32-bit extensible counter DLL by using the
> 32-bit version
> of Performance Monitor. To use this tool, open the Windows folder, open th
e
> Syswow64 folder,
> and then start Perfmon.exe.
> I followed and can see the monitors on the local machine using the 64bit
> perfmon. (they do not show on the stat > run > perfmon
> The question: Any ideas how to force the 64bit monitors to present
> themselves rather then the 32bit - which do not have the sql perf monitirs
.
> Heeeelp.
> Thanks|||I have been searching the network and I have found nothing to answer
this question. I am having the same problem. Does anybody have an
idea?
ej
Mike Duncan wrote:
> I am using a 3rd party tool to bind to the perf monitors, with no success.
In
> the event log:
> Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
> 64-bit environment.
> Contact the file vendor to obtain a 64-bit version.
> Alternatively, you can open the 32-bit extensible counter DLL by using the
> 32-bit version
> of Performance Monitor. To use this tool, open the Windows folder, open th
e
> Syswow64 folder,
> and then start Perfmon.exe.
> I followed and can see the monitors on the local machine using the 64bit
> perfmon. (they do not show on the stat > run > perfmon
> The question: Any ideas how to force the 64bit monitors to present
> themselves rather then the 32bit - which do not have the sql perf monitirs
.
> Heeeelp.
> Thanks
n
the event log:
Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
64-bit environment.
Contact the file vendor to obtain a 64-bit version.
Alternatively, you can open the 32-bit extensible counter DLL by using the
32-bit version
of Performance Monitor. To use this tool, open the Windows folder, open the
Syswow64 folder,
and then start Perfmon.exe.
I followed and can see the monitors on the local machine using the 64bit
perfmon. (they do not show on the stat > run > perfmon
The question: Any ideas how to force the 64bit monitors to present
themselves rather then the 32bit - which do not have the sql perf monitirs.
Heeeelp.
ThanksOK - I have got myself mixed up.
I need the 32bit (Syswow64) perfmon to respond to the 3rd party software
rather than the 64bit.
Cheers
"Mike Duncan" wrote:
> I am using a 3rd party tool to bind to the perf monitors, with no success.
In
> the event log:
> Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
> 64-bit environment.
> Contact the file vendor to obtain a 64-bit version.
> Alternatively, you can open the 32-bit extensible counter DLL by using the
> 32-bit version
> of Performance Monitor. To use this tool, open the Windows folder, open th
e
> Syswow64 folder,
> and then start Perfmon.exe.
> I followed and can see the monitors on the local machine using the 64bit
> perfmon. (they do not show on the stat > run > perfmon
> The question: Any ideas how to force the 64bit monitors to present
> themselves rather then the 32bit - which do not have the sql perf monitirs
.
> Heeeelp.
> Thanks|||I have been searching the network and I have found nothing to answer
this question. I am having the same problem. Does anybody have an
idea?
ej
Mike Duncan wrote:
> I am using a 3rd party tool to bind to the perf monitors, with no success.
In
> the event log:
> Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
> 64-bit environment.
> Contact the file vendor to obtain a 64-bit version.
> Alternatively, you can open the 32-bit extensible counter DLL by using the
> 32-bit version
> of Performance Monitor. To use this tool, open the Windows folder, open th
e
> Syswow64 folder,
> and then start Perfmon.exe.
> I followed and can see the monitors on the local machine using the 64bit
> perfmon. (they do not show on the stat > run > perfmon
> The question: Any ideas how to force the 64bit monitors to present
> themselves rather then the 32bit - which do not have the sql perf monitirs
.
> Heeeelp.
> Thanks
Performance Monitors on 64bit OS
I am using a 3rd party tool to bind to the perf monitors, with no success. In
the event log:
Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
64-bit environment.
Contact the file vendor to obtain a 64-bit version.
Alternatively, you can open the 32-bit extensible counter DLL by using the
32-bit version
of Performance Monitor. To use this tool, open the Windows folder, open the
Syswow64 folder,
and then start Perfmon.exe.
I followed and can see the monitors on the local machine using the 64bit
perfmon. (they do not show on the stat > run > perfmon
The question: Any ideas how to force the 64bit monitors to present
themselves rather then the 32bit - which do not have the sql perf monitirs.
Heeeelp.
Thanks
OK - I have got myself mixed up.
I need the 32bit (Syswow64) perfmon to respond to the 3rd party software
rather than the 64bit.
Cheers
"Mike Duncan" wrote:
> I am using a 3rd party tool to bind to the perf monitors, with no success. In
> the event log:
> Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
> 64-bit environment.
> Contact the file vendor to obtain a 64-bit version.
> Alternatively, you can open the 32-bit extensible counter DLL by using the
> 32-bit version
> of Performance Monitor. To use this tool, open the Windows folder, open the
> Syswow64 folder,
> and then start Perfmon.exe.
> I followed and can see the monitors on the local machine using the 64bit
> perfmon. (they do not show on the stat > run > perfmon
> The question: Any ideas how to force the 64bit monitors to present
> themselves rather then the 32bit - which do not have the sql perf monitirs.
> Heeeelp.
> Thanks
the event log:
Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
64-bit environment.
Contact the file vendor to obtain a 64-bit version.
Alternatively, you can open the 32-bit extensible counter DLL by using the
32-bit version
of Performance Monitor. To use this tool, open the Windows folder, open the
Syswow64 folder,
and then start Perfmon.exe.
I followed and can see the monitors on the local machine using the 64bit
perfmon. (they do not show on the stat > run > perfmon
The question: Any ideas how to force the 64bit monitors to present
themselves rather then the 32bit - which do not have the sql perf monitirs.
Heeeelp.
Thanks
OK - I have got myself mixed up.
I need the 32bit (Syswow64) perfmon to respond to the 3rd party software
rather than the 64bit.
Cheers
"Mike Duncan" wrote:
> I am using a 3rd party tool to bind to the perf monitors, with no success. In
> the event log:
> Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
> 64-bit environment.
> Contact the file vendor to obtain a 64-bit version.
> Alternatively, you can open the 32-bit extensible counter DLL by using the
> 32-bit version
> of Performance Monitor. To use this tool, open the Windows folder, open the
> Syswow64 folder,
> and then start Perfmon.exe.
> I followed and can see the monitors on the local machine using the 64bit
> perfmon. (they do not show on the stat > run > perfmon
> The question: Any ideas how to force the 64bit monitors to present
> themselves rather then the 32bit - which do not have the sql perf monitirs.
> Heeeelp.
> Thanks
Performance Monitors on 64bit OS
I am using a 3rd party tool to bind to the perf monitors, with no success. In
the event log:
Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
64-bit environment.
Contact the file vendor to obtain a 64-bit version.
Alternatively, you can open the 32-bit extensible counter DLL by using the
32-bit version
of Performance Monitor. To use this tool, open the Windows folder, open the
Syswow64 folder,
and then start Perfmon.exe.
I followed and can see the monitors on the local machine using the 64bit
perfmon. (they do not show on the stat > run > perfmon
The question: Any ideas how to force the 64bit monitors to present
themselves rather then the 32bit - which do not have the sql perf monitirs.
Heeeelp.
ThanksOK - I have got myself mixed up.
I need the 32bit (Syswow64) perfmon to respond to the 3rd party software
rather than the 64bit.
Cheers
"Mike Duncan" wrote:
> I am using a 3rd party tool to bind to the perf monitors, with no success. In
> the event log:
> Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
> 64-bit environment.
> Contact the file vendor to obtain a 64-bit version.
> Alternatively, you can open the 32-bit extensible counter DLL by using the
> 32-bit version
> of Performance Monitor. To use this tool, open the Windows folder, open the
> Syswow64 folder,
> and then start Perfmon.exe.
> I followed and can see the monitors on the local machine using the 64bit
> perfmon. (they do not show on the stat > run > perfmon
> The question: Any ideas how to force the 64bit monitors to present
> themselves rather then the 32bit - which do not have the sql perf monitirs.
> Heeeelp.
> Thanks|||I have been searching the network and I have found nothing to answer
this question. I am having the same problem. Does anybody have an
idea?
ej
Mike Duncan wrote:
> I am using a 3rd party tool to bind to the perf monitors, with no success. In
> the event log:
> Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
> 64-bit environment.
> Contact the file vendor to obtain a 64-bit version.
> Alternatively, you can open the 32-bit extensible counter DLL by using the
> 32-bit version
> of Performance Monitor. To use this tool, open the Windows folder, open the
> Syswow64 folder,
> and then start Perfmon.exe.
> I followed and can see the monitors on the local machine using the 64bit
> perfmon. (they do not show on the stat > run > perfmon
> The question: Any ideas how to force the 64bit monitors to present
> themselves rather then the 32bit - which do not have the sql perf monitirs.
> Heeeelp.
> Thanks
the event log:
Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
64-bit environment.
Contact the file vendor to obtain a 64-bit version.
Alternatively, you can open the 32-bit extensible counter DLL by using the
32-bit version
of Performance Monitor. To use this tool, open the Windows folder, open the
Syswow64 folder,
and then start Perfmon.exe.
I followed and can see the monitors on the local machine using the 64bit
perfmon. (they do not show on the stat > run > perfmon
The question: Any ideas how to force the 64bit monitors to present
themselves rather then the 32bit - which do not have the sql perf monitirs.
Heeeelp.
ThanksOK - I have got myself mixed up.
I need the 32bit (Syswow64) perfmon to respond to the 3rd party software
rather than the 64bit.
Cheers
"Mike Duncan" wrote:
> I am using a 3rd party tool to bind to the perf monitors, with no success. In
> the event log:
> Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
> 64-bit environment.
> Contact the file vendor to obtain a 64-bit version.
> Alternatively, you can open the 32-bit extensible counter DLL by using the
> 32-bit version
> of Performance Monitor. To use this tool, open the Windows folder, open the
> Syswow64 folder,
> and then start Perfmon.exe.
> I followed and can see the monitors on the local machine using the 64bit
> perfmon. (they do not show on the stat > run > perfmon
> The question: Any ideas how to force the 64bit monitors to present
> themselves rather then the 32bit - which do not have the sql perf monitirs.
> Heeeelp.
> Thanks|||I have been searching the network and I have found nothing to answer
this question. I am having the same problem. Does anybody have an
idea?
ej
Mike Duncan wrote:
> I am using a 3rd party tool to bind to the perf monitors, with no success. In
> the event log:
> Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a
> 64-bit environment.
> Contact the file vendor to obtain a 64-bit version.
> Alternatively, you can open the 32-bit extensible counter DLL by using the
> 32-bit version
> of Performance Monitor. To use this tool, open the Windows folder, open the
> Syswow64 folder,
> and then start Perfmon.exe.
> I followed and can see the monitors on the local machine using the 64bit
> perfmon. (they do not show on the stat > run > perfmon
> The question: Any ideas how to force the 64bit monitors to present
> themselves rather then the 32bit - which do not have the sql perf monitirs.
> Heeeelp.
> Thanks
Subscribe to:
Posts (Atom)