-
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
-
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
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|