Results 1 to 3 of 3

Thread: Sql Perfmon counter

Threaded View

  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
« 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