SQL Server Performance

Perforance monitoring question

Discussion in 'Getting Started' started by reiffs, Apr 21, 2008.

  1. reiffs New Member

    I am running performance test on a SharePoint site, using HP LoadRunner v8.14. I am capturing perfromance data with the SQL server monitor.
    One of the counters I am collecting is Probe sacns/sec. The definition of the counter is :Number of probe scans per second that are used to find at most one single qualified row in an index or base table directly. So I am presuming, that if this is high, say over 5000/sec, that this my not be a good thing....
    On the other hand it may be better the higher the number is... I have not found any information that indicates one way or the other.
    If someone could share their around this that would be great.
    Also If there is somewhere, that not only defines each of the counters but also rates the impact of each that would be great. Most sites I have found do not provide a complete set of defintions.
  2. satya Moderator

    Welcome to the forum!
    I don't see such type of perfmon counter at my end, having sharepoint & sql server.
    In this case can you confirm from where you are trying to see this counter, is it on PERFMON or that load monitoring tool?
  3. reiffs New Member

    This is an Access Method counter. I am using both HP SiteScope and HP Loadrunner to monitor the SQL DB.
    It is one of several counter, the list below if from siteScope, but the same list is also in LoadRunner. Not sure what Perfmon would have, but I agree, I don't recall see it in the Perfmon list.
    SQLServer:Access Methods -- Full Scans/sec -- SINGLE
    SQLServer:Access Methods -- Range Scans/sec -- SINGLE
    SQLServer:Access Methods -- Probe Scans/sec -- SINGLE
    SQLServer:Access Methods -- Scan Point Revalidations/sec -- SINGLE
    SQLServer:Access Methods -- Workfiles Created/sec -- SINGLE
    SQLServer:Access Methods -- Worktables Created/sec -- SINGLE
    SQLServer:Access Methods -- Worktables From Cache Ratio -- SINGLE
    SQLServer:Access Methods -- Forwarded Records/sec -- SINGLE
    SQLServer:Access Methods -- Skipped Ghosted Records/sec -- SINGLE
    SQLServer:Access Methods -- Index Searches/sec -- SINGLE
    SQLServer:Access Methods -- FreeSpace Scans/sec -- SINGLE
    SQLServer:Access Methods -- FreeSpace Page Fetches/sec -- SINGLE
    SQLServer:Access Methods -- Pages Allocated/sec -- SINGLE
    SQLServer:Access Methods -- Extents Allocated/sec -- SINGLE
    SQLServer:Access Methods -- Mixed page allocations/sec -- SINGLE
    SQLServer:Access Methods -- Extent Deallocations/sec -- SINGLE
    SQLServer:Access Methods -- Page Deallocations/sec -- SINGLE
    SQLServer:Access Methods -- Page Splits/sec -- SINGLE
    SQLServer:Access Methods -- Table Lock Escalations/sec -- SINGLE
    SQLServer:Access Methods -- Deferred Dropped rowsets -- SINGLE
    SQLServer:Access Methods -- Dropped rowset cleanups/sec -- SINGLE
    SQLServer:Access Methods -- Dropped rowsets skipped/sec -- SINGLE
    SQLServer:Access Methods -- Deferred dropped AUs -- SINGLE
    SQLServer:Access Methods -- AU cleanups/sec -- SINGLE
    SQLServer:Access Methods -- AU cleanup batches/sec -- SINGLE
    SQLServer:Access Methods -- Failed AU cleanup batches/sec -- SINGLE
    SQLServer:Access Methods -- Used tree page cookie -- SINGLE
    SQLServer:Access Methods -- Failed tree page cookie -- SINGLE
    SQLServer:Access Methods -- Used leaf page cookie -- SINGLE
    SQLServer:Access Methods -- Failed leaf page cookie -- SINGLE
    SQLServer:Access Methods -- LobSS Provider Create Count -- SINGLE
    SQLServer:Access Methods -- LobSS Provider Destroy Count -- SINGLE
    SQLServer:Access Methods -- LobSS Provider Truncation Count -- SINGLE
    SQLServer:Access Methods -- LobHandle Create Count -- SINGLE
    SQLServer:Access Methods -- LobHandle Destroy Count -- SINGLE
    SQLServer:Access Methods -- By-reference Lob Create Count -- SINGLE
    SQLServer:Access Methods -- By-reference Lob Use Count -- SINGLE
    SQLServer:Access Methods -- Count Push Off Row -- SINGLE
    SQLServer:Access Methods -- Count Pull In Row -- SINGLE
    SQLServer:Access Methods -- Count Lob Readahead -- SINGLE
  4. satya Moderator

    Have you seen or referred this on HP site as you are using their tools?

Share This Page