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
>
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
> 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...
>
|||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...
>
>
|||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...
>
Saturday, February 25, 2012
Performance Object SQL Server
Labels:
bartim,
click,
counters,
database,
microsoft,
mysql,
nbot,
object,
objectcombobox,
oracle,
perfmon,
perfomance,
performance,
run,
sceen,
server,
sql,
uinderstand
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment