No entries show up in SQL Server Profiler trace

Hi,
I have inherited a SQL Server 2000 machine with 59 databases on it,
several of which I suspect are no longer used.
I am setting up a SQL Profiler trace to show me which databases are
still being accessed, and by which machine/user.
There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
7, 2000 and 2005.
The problem I'm encountering is this:
I start the Profiler trace on SQL Server machine A
>From my local machine's Query Analyzer, I then query a table in one of
the suspect databases on machine A, via a linked server entry in my
local SQL Server instance
None of this query activity against the database is logged in Profiler
on machine A
What am I missing?
Thanks in advance-
Jason
I figured it out. I am now monitoring the event class "Security
Audit->Audit Object Persmission Event", and bringing back the data
columns ObjectName, LoginName, and Hostname to know what's being looked
at, by whom, and from what machine.
JasonReber@.gmail.com wrote:
> Hi,
> I have inherited a SQL Server 2000 machine with 59 databases on it,
> several of which I suspect are no longer used.
> I am setting up a SQL Profiler trace to show me which databases are
> still being accessed, and by which machine/user.
> There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
> 7, 2000 and 2005.
> The problem I'm encountering is this:
> I start the Profiler trace on SQL Server machine A
> the suspect databases on machine A, via a linked server entry in my
> local SQL Server instance
> None of this query activity against the database is logged in Profiler
> on machine A
> What am I missing?
> Thanks in advance-
> Jason

No entries show up in SQL Server Profiler trace

Hi,
I have inherited a SQL Server 2000 machine with 59 databases on it,
several of which I suspect are no longer used.
I am setting up a SQL Profiler trace to show me which databases are
still being accessed, and by which machine/user.
There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
7, 2000 and 2005.
The problem I'm encountering is this:
I start the Profiler trace on SQL Server machine A
>From my local machine's Query Analyzer, I then query a table in one of
the suspect databases on machine A, via a linked server entry in my
local SQL Server instance
None of this query activity against the database is logged in Profiler
on machine A
What am I missing?
Thanks in advance-
JasonI figured it out. I am now monitoring the event class "Security
Audit->Audit Object Persmission Event", and bringing back the data
columns ObjectName, LoginName, and Hostname to know what's being looked
at, by whom, and from what machine.
JasonReber@.gmail.com wrote:
> Hi,
> I have inherited a SQL Server 2000 machine with 59 databases on it,
> several of which I suspect are no longer used.
> I am setting up a SQL Profiler trace to show me which databases are
> still being accessed, and by which machine/user.
> There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
> 7, 2000 and 2005.
> The problem I'm encountering is this:
> I start the Profiler trace on SQL Server machine A
> the suspect databases on machine A, via a linked server entry in my
> local SQL Server instance
> None of this query activity against the database is logged in Profiler
> on machine A
> What am I missing?
> Thanks in advance-
> Jason

No entries show up in SQL Server Profiler trace

Hi,
I have inherited a SQL Server 2000 machine with 59 databases on it,
several of which I suspect are no longer used.
I am setting up a SQL Profiler trace to show me which databases are
still being accessed, and by which machine/user.
There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
7, 2000 and 2005.
The problem I'm encountering is this:
I start the Profiler trace on SQL Server machine A
>From my local machine's Query Analyzer, I then query a table in one of
the suspect databases on machine A, via a linked server entry in my
local SQL Server instance
None of this query activity against the database is logged in Profiler
on machine A
What am I missing?
Thanks in advance-
JasonI figured it out. I am now monitoring the event class "Security
Audit->Audit Object Persmission Event", and bringing back the data
columns ObjectName, LoginName, and Hostname to know what's being looked
at, by whom, and from what machine.
JasonReber@.gmail.com wrote:
> Hi,
> I have inherited a SQL Server 2000 machine with 59 databases on it,
> several of which I suspect are no longer used.
> I am setting up a SQL Profiler trace to show me which databases are
> still being accessed, and by which machine/user.
> There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
> 7, 2000 and 2005.
> The problem I'm encountering is this:
> I start the Profiler trace on SQL Server machine A
> >From my local machine's Query Analyzer, I then query a table in one of
> the suspect databases on machine A, via a linked server entry in my
> local SQL Server instance
> None of this query activity against the database is logged in Profiler
> on machine A
> What am I missing?
> Thanks in advance-
> Jason

Newbie-How to tell when Database last used

I Inherited a SQL 2000 Server with some databases I think are no longer used.
I'm not sure on some of them what apps may be using them. How can I tell
when a database or any of its tables were last used? I don't really care
what the specific transactions were, just when it was touched. There are
database maint jobs backing up the databases. Does this imply that the
datestamps of the files change when they are backed up, and therefore not a
good indication of when they were last used?
Thanks.
"Coop" <Coop@.discussions.microsoft.com> wrote in message
news:33770A94-B003-400A-88F6-9DE689625A91@.microsoft.com...
>I Inherited a SQL 2000 Server with some databases I think are no longer
>used.
> I'm not sure on some of them what apps may be using them. How can I tell
> when a database or any of its tables were last used? I don't really care
> what the specific transactions were, just when it was touched. There are
> database maint jobs backing up the databases. Does this imply that the
> datestamps of the files change when they are backed up, and therefore not
> a
> good indication of when they were last used?
> Thanks.
There's no easy way to do this.
The timestamp on the file for example only changes when the database is
opened or the file size is changed.
You can setup a profiler to watch the database.
Or simply detach it and see who squawks first.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||Greg D. Moore (Strider) wrote:
> "Coop" <Coop@.discussions.microsoft.com> wrote in message
> news:33770A94-B003-400A-88F6-9DE689625A91@.microsoft.com...
> There's no easy way to do this.
> The timestamp on the file for example only changes when the database is
> opened or the file size is changed.
> You can setup a profiler to watch the database.
> Or simply detach it and see who squawks first.
>
Taking the DB offline may be simplier...

Newbie-How to tell when Database last used

I Inherited a SQL 2000 Server with some databases I think are no longer used.
I'm not sure on some of them what apps may be using them. How can I tell
when a database or any of its tables were last used? I don't really care
what the specific transactions were, just when it was touched. There are
database maint jobs backing up the databases. Does this imply that the
datestamps of the files change when they are backed up, and therefore not a
good indication of when they were last used?
Thanks."Coop" <Coop@.discussions.microsoft.com> wrote in message
news:33770A94-B003-400A-88F6-9DE689625A91@.microsoft.com...
>I Inherited a SQL 2000 Server with some databases I think are no longer
>used.
> I'm not sure on some of them what apps may be using them. How can I tell
> when a database or any of its tables were last used? I don't really care
> what the specific transactions were, just when it was touched. There are
> database maint jobs backing up the databases. Does this imply that the
> datestamps of the files change when they are backed up, and therefore not
> a
> good indication of when they were last used?
> Thanks.
There's no easy way to do this.
The timestamp on the file for example only changes when the database is
opened or the file size is changed.
You can setup a profiler to watch the database.
Or simply detach it and see who squawks first.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Greg D. Moore (Strider) wrote:
> "Coop" <Coop@.discussions.microsoft.com> wrote in message
> news:33770A94-B003-400A-88F6-9DE689625A91@.microsoft.com...
>> I Inherited a SQL 2000 Server with some databases I think are no longer
>> used.
>> I'm not sure on some of them what apps may be using them. How can I tell
>> when a database or any of its tables were last used? I don't really care
>> what the specific transactions were, just when it was touched. There are
>> database maint jobs backing up the databases. Does this imply that the
>> datestamps of the files change when they are backed up, and therefore not
>> a
>> good indication of when they were last used?
>> Thanks.
> There's no easy way to do this.
> The timestamp on the file for example only changes when the database is
> opened or the file size is changed.
> You can setup a profiler to watch the database.
> Or simply detach it and see who squawks first.
>
Taking the DB offline may be simplier...

Newbie-How to tell when Database last used

I Inherited a SQL 2000 Server with some databases I think are no longer used
.
I'm not sure on some of them what apps may be using them. How can I tell
when a database or any of its tables were last used? I don't really care
what the specific transactions were, just when it was touched. There are
database maint jobs backing up the databases. Does this imply that the
datestamps of the files change when they are backed up, and therefore not a
good indication of when they were last used?
Thanks."Coop" <Coop@.discussions.microsoft.com> wrote in message
news:33770A94-B003-400A-88F6-9DE689625A91@.microsoft.com...
>I Inherited a SQL 2000 Server with some databases I think are no longer
>used.
> I'm not sure on some of them what apps may be using them. How can I tell
> when a database or any of its tables were last used? I don't really care
> what the specific transactions were, just when it was touched. There are
> database maint jobs backing up the databases. Does this imply that the
> datestamps of the files change when they are backed up, and therefore not
> a
> good indication of when they were last used?
> Thanks.
There's no easy way to do this.
The timestamp on the file for example only changes when the database is
opened or the file size is changed.
You can setup a profiler to watch the database.
Or simply detach it and see who squawks first.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Greg D. Moore (Strider) wrote:
> "Coop" <Coop@.discussions.microsoft.com> wrote in message
> news:33770A94-B003-400A-88F6-9DE689625A91@.microsoft.com...
> There's no easy way to do this.
> The timestamp on the file for example only changes when the database is
> opened or the file size is changed.
> You can setup a profiler to watch the database.
> Or simply detach it and see who squawks first.
>
Taking the DB offline may be simplier...