unreported buffer cache hit ratio

• SQL Galaxy

  One Orange Chip

  Points: 29479

  More actions

  May 7, 2009 at 11:07 pm

  #129868

  Hi friends,

  I am using sql server 2000, i could not find any counter in master sysperfinfo table. what is the worng on this server? please can any one suggestion me.

  I fired the following query for find out buffer hit ratio one of the production server, but it is display nothing

  select [object_name], [counter_name], [cntr_value]

  from master.dbo.sysperfinfo

  where counter_name = 'Buffer cache hit ratio'

  or counter_name = 'Buffer cache hit ratio base'

  (0) rows return

  server config as follows,

  os: windows server 2003 enterprise edtion

  database : SQL server 2000 enterprise edtion

  SP: SP3 for sql server. product version 8.00.760(sp3)

  Total RAM - 3.25 GB, 4 CPU

  currently server using some huge resources

  PF usage 2.09 GB

  sqlservr.exe momory using - 1.680.50

  Database size is 356 GB.

  Thanks.

• Vinay Thankur

  SSCarpal Tunnel

  Points: 4178

  More actions

  May 8, 2009 at 11:49 am

  #991356

  What OS are you using??

  BOL:

  Note The Windows NT Performance Monitor is available only when using Microsoft Windows NT® 4.0 as the operating system.

  Thanx.
  Vinay

  http://rdbmsexperts.com/Blogs/
  http://vinay-thakur.spaces.live.com/
  http://twitter.com/ThakurVinay

• SQL Galaxy

  One Orange Chip

  Points: 29479

  More actions

  May 9, 2009 at 5:05 am

  #991597

  vinay,

  os: windows server 2003 enterprise edtion