Post reply

Client Statistics - incorrect in Management Studio?

  • May 1, 2012 at 7:03 am

    #260234

    I have a SP that returns data, it's actually part of reporting services. It's called 'ObjectExists'.

    When I include execute the query and include Client Statistics it shows bytes received as 1050973, but when I look at the data it only returns 1 row with 65645 bytes. Any ideas why the bytes received is so high? PS the execution plan is off.

    Here is the SP;

    ALTER PROCEDURE [dbo].[ObjectExists]

    @Path nvarchar (425),

    @AuthType int

    AS

    SELECT Type, ItemID, SnapshotLimit, NtSecDescPrimary, ExecutionFlag, Intermediate, [LinkSourceID]

    FROM Catalog

    LEFT OUTER JOIN SecData

    ON Catalog.PolicyID = SecData.PolicyID AND SecData.AuthType = @AuthType

    WHERE Path = @Path

  • May 1, 2012 at 10:35 am

    #1481918

    Just another followup,

    The issue I'm investigating it a lot of network IO wait time. This query executes 25,000+ times per day and at seemingly 1 MB per execution we're moving around 25 GB over the firewall.

    So does anyone know if the Bytes received from server is accurate in the Client statistics and if so why is it so high from returning 1 row?

    Any help would be greatly appreciated!

  • May 1, 2012 at 3:14 pm

    #1482117

    bump - please ....

  • May 1, 2012 at 3:17 pm

    #1482118

    First, we are all volunteers here, giving of our own time. If you have not gotten an answer it may be due to a lack of information or no one who has read your post as an answer at this time.

  • May 1, 2012 at 4:48 pm

    #1482142

    I'm well aware how forums work, I always appreciate any information I receive here. Just hoping someone has experience with this issue.

    Thanks!

    :smooooth:

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply