Re: SQL Server statistics Counter
From: Gansmeier (markus.gansmeier_at_bfd-r.bayern.de)
Date: 02/04/05
- Next message: Chris: "SQL Hyperthreading"
- Previous message: Jim McDonald: "Re: Loading db from copied files"
- In reply to: Andrew J. Kelly: "Re: SQL Server statistics Counter"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Feb 2005 16:03:22 +0100
Hello,
thank you for this tip and link!
I didn't have the chance to restart the sql server until now, but the
columns waittype and waittime from sysprocesses table
(mentioned in the article) really are always zero.
So i will try check the error log after restarting the sql server on weekend
with open performance console.
thank you again,
Markus Gansmeier
gansmeier@gmx.de
"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> schrieb im Newsbeitrag
news:eNHpu8iCFHA.4072@TK2MSFTNGP10.phx.gbl...
> Most of those commands are undocumented so you won't get a lot of support
> about them in particular. But it sounds like your perfmon counters have
> been blown away. Usually a restart will fix it as long as you don't have
> anything monitoring the counters when you restart. Have a look here as
> well:
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&Product=sql2k
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "test" <test@test.de> wrote in message news:42028362.C95BAEA6@test.de...
> > Hello,
> >
> > does someone know, what may cause the error, that the following
> > dbcc functions alwasy returns 0 (zero)
> >
> > - dbcc cachstats
> > - dbcc sqlperf (,iostats')
> > - dbcc sqlperf (,lrustats')
> > the columns: Cache hit ratio, Cache flushes, free page scan (avg),
> > free page scan (max)
> > - dbcc sqlperf ('netstats')
> > the columns: Command Queue Length, Max Command Queue Length, Worker
> > Threads, Max Worker Threads, Network Threads, Max Network Threads
> > - dbcc sqlperf ('rastats')
> > - dbcc sqlperf ('waitstats')
> >
> > also the performance counter of sql server aren't visible
> >
> > the system:
> > sql server 2000 sp 3 on
> > windows2000 advanced server on
> > aktive - passiv Cluster
> > 4gb ram
> >
> > i would be happy for every usefull suggestions
> >
> > Markus Gansmeier
> > gansmeier@gmx.de
> >
> >
>
>
- Next message: Chris: "SQL Hyperthreading"
- Previous message: Jim McDonald: "Re: Loading db from copied files"
- In reply to: Andrew J. Kelly: "Re: SQL Server statistics Counter"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
