Post reply

any tool for find hitting count of database

  • August 7, 2009 at 11:24 pm

    #140587

    hi..

    I am using asp.net applications.In this I used database to store ,update ,delete and select.

    I want to know how many times hit database my application.

    Any tool for this in database side..

    Thanks
    Dastagiri.D

  • August 8, 2009 at 2:38 am

    #1036390

    Performance Monitor. Look for the Transactions/sec counter.

    Profiler. Look for the RPC:Completed and T-SQL Batch Completed events.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 9, 2009 at 5:24 am

    #1036471

    Try this.

    SELECT object_name(object_id), * FROM sys.dm_db_index_usage_stats

    where object_name(object_id) is not null

    N 56°04'39.16"
    E 12°55'05.25"

Viewing 3 posts - 1 through 2 (of 2 total)

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