Post reply

Find out, who accesses which Database-Table when

  • September 8, 2014 at 6:52 am

    #310705

    Hallo everybody,

    I have several huge, large, grown databases, I need to know, if they and all of their tables are still in use.

    Can anybody recommend me a tool to find out for databases and tables inside: Who accesses it when (e.g. User, IP, ...)

    I need to analyse for a clean up, what is in use, but the last run could be - worst case - nearly one year ago, because there might be jobs running only once per year.

    Thank you véry much in advance

    Regards

    Christian

  • September 8, 2014 at 7:07 am

    #1743849

    SQL doesn't keep that kind of historical data. To find that out (especially the who accesses it), you'll need to run traces for long periods of time.

    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

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

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