question

paulppp2008 avatar image
paulppp2008 asked

Why Lookups/sec is in the millions?

I read a thread here that talks about LooksUp/sec being 150,000 or so and that would be consider normal. I'm trying to figure out why my LooksUp/Sec is coming up to something like this "1,767,576,005,760." Likewise, Batch Requests is in the 2 million, and Reads/Sec is in the 3 million/sec.

This is "millions" per sec. Could this possibly be correct?

Any advice is appreciated. Thank you in advance.

performance
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered

The value is cumulative. To work out a 'rate' you would need to take 2 readings x seconds apart, then divide the difference between the 2 readings by x to get the actual per second rate.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

paulppp2008 avatar image
paulppp2008 answered

Kev, thanks for your reply and info.

Further research has also shown me the following:

  1. When you read out of the DMV -->

SELECT * FROM master.sys.dm_os_performance_counters WHERE counter_name='Batch Requests/sec';

you will get the cumulative number that you were referring to.

The tool "sp_BlitzFirst" however make the translation for you to "batch requests/sec"

EXEC sp_BlitzFirst@ExpertMode=1;

      10 |1200

      Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

      Write an Answer

      Hint: Notify or tag a user in this post by typing @username.

      Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.