Results 1 to 3 of 3

Thread: Sql Perfmon counter

  1. May 23rd, 2012, 06:51 AM #1
    winman
    winman is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Posts
    248

    Sql Perfmon counter

    It is mentioned that Forwarded Records/sec should be < 10 per 100 Batch Requests/Sec, but when I checked the counter I found that the two counters(Forwarded Records/sec & Batch Requests/Sec) are not related
    Below are the values for both coounters at some instances respectively

    Access Methods\Forwarded Records/sec :27.82655124,139.7820692, 288.8344024
    SQL Statistics\Batch Requests/sec 7.39541227,3.661808194,67.26424444

    Please can anyone tell why is this variation?
    Last edited by winman; May 23rd, 2012 at 07:44 AM.
    Reply With Quote Reply With Quote
  2. May 23rd, 2012, 07:20 AM #2
    RhinoBull
    RhinoBull is offline
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,132

    Re: Sql Perfmon counter

    It's either you posted new thread instead of replying to existing, posted in the wrong forum or didn't explain enough... because I have absolutely no clue what you're trying to say/ask.
    Sorry.
    Microsoft MVP - Visual Basic 2006-2013

    Why VB clears the clipboard on startup and how to avoid it? . Filtering Arrays . Save File To Database . Extract File From Database .
    Extract picture from database without using hard drive . Change Menu BackColor . How to use MS Flexgrid . Make Frame Transparent .
    The Easiest Way to Create an NT Service With VB6 . How to comment blocks of code in VB5 and VB6 . How to find and replace missing members of control array
    Visual Basic 6.0 On-Line Documentation . Connection Strings
    Reply With Quote Reply With Quote
  3. May 23rd, 2012, 11:54 AM #3
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Sql Perfmon counter

    Moved To Database Development
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width