SQL Server Performance

When was the last activity on the db

Discussion in 'SQL Server 2005 General DBA Questions' started by patrick1628, Oct 7, 2008.

  1. patrick1628 New Member

    Hi everyone,
    Does anyone know how I can find out when the database was last updated or touched or activity performed. Anytype of activity. I just wanted to see like a last updated date.
    Does anyone know how I can find that is there a script or something? This is in sql server 2005.
    Thanks,
    patrick1628, Oct 7, 2008
    #2

  2. madhuottapalam New Member

    To get these kind of information you need to run Profiler /Trace.
    Madhu
    madhuottapalam, Oct 7, 2008
    #3

  3. smithhs New Member

    If you think the DB isn't being used, one approach we took was to set AUTOCLOSE on; definitely not a good idea for databases you know are actively being used! If anything is hitting the database, when it is opened it is logged to the SQL log and you start run traces then to see what is hitting it and from where.
    Just one approach!
    smithhs, Oct 8, 2008
    #4

  4. MohammedU New Member

    MohammedU, Oct 8, 2008
    #5

Share This Page