Database History


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Database History

  1. #1
    Paul Guest

    Database History


    Hi,
    I have a acquired a sql server 7.0 db from another group and I want to find
    out if there are people still using it, its uptime etc. I think I used one
    recently but canot remember which and would appreciate if anyone can help.
    Thanks in advance.
    Paul

  2. #2
    P. Shah Guest

    Re: Database History


    "Paul" <pjvaz@hotmail.com> wrote:
    >
    >Hi,
    >I have a acquired a sql server 7.0 db from another group and I want to find
    >out if there are people still using it, its uptime etc. I think I used one
    >recently but canot remember which and would appreciate if anyone can help.
    >Thanks in advance.
    >Paul


    Hi Paul

    You MAY visit sysinternals.com, they have a utility called uptime for calculating
    SERVER UPTIME.

    Windows NT Resource Kit utility has a utility called SRVINFO.EXE which would
    get you server uptime. I am not aware of SQL server uptime. Hope to get more
    info soon.

    Also performance monitor has an object called system and counter called
    System Up time which will get you the required info.

    As to the no. of people using your server, you should be able to have a look
    at sp_who and get good info as to what they are doing, which process they
    are running etc.

    Hope this helps you.

    P. Shah







Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center