Re: Identifying what Apps are using a database

From: Van Jones (anonymous_at_discussions.microsoft.com)
Date: 01/10/05 

Date: Mon, 10 Jan 2005 14:14:21 -0800

>-----Original Message-----
>
>"Van Jones" <anonymous@discussions.microsoft.com> wrote
in message
>news:012401c4f75f$6fe0e520$a601280a@phx.gbl...
>> I'm looking for a little insight on identifying what
apps
>> are updating a particular database. Basically we have a
>> front end developed for the db but some people may have
>> created Access dbs and processes in Access to do
updates.
>> I need to determine if this is happening since we may be
>> moving the db to a different sql server. SQL Profiler
>> would work, but it's hit and miss. Plus I'd have to let
>> it run for a few days which would create a huge trace
>> file. If I did let it run for a few days, I still may
not
>> capture and activity from Access if they didn't happen
to
>> run any Access updates during that time. Is there
>> anything out there that can help me?
>>
>> Thanks,
>>
>> Van Jones
>
>
>I would still go with Profiler. Take a look at the
Filters tab. You can
>do things like: NOT LIKE and add all of the known
applications that will
>log in. You can weed out just about all the activity
that you don't want
>to see. Then your trace file will not be enormous.
>
>The other suggestion is to turn on profiler and ask
everyone to hit the
>server with their updates so that you can capture
everything in one go.
>
>
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>
>
>.
Yea, I figure profiler might be the only way. The problem
is...is that I don't know if anybody has any Access
processes that update the db. I've been told that they
might. If they do, it could be quartly or even year end
processes that I wouldn't capture if I ran a trace for a
few days.

Relevant Pages

  • Re: DBCC TRACEON 3604
    ... Ran the profiler and captured the trace. ... Take a Profiler trace of the server to capture the ... > reporting that SYSTEM is executing DBCC TRACEON 3604. ...
    (microsoft.public.sqlserver.server)
  • Re: Identifying what Apps are using a database
    ... > created Access dbs and processes in Access to do updates. ... I would still go with Profiler. ... Then your trace file will not be enormous. ... server with their updates so that you can capture everything in one go. ...
    (microsoft.public.sqlserver.server)
  • Re: Identifying what Apps are using a database
    ... >>I would still go with Profiler. ... Then your trace file will not be enormous. ... >>server with their updates so that you can capture ...
    (microsoft.public.sqlserver.server)
  • Re: How to Capture data from server side trace to file?
    ... Profiler tool, get a trace running that is capturing what you want, stop it ... Jasper Smith (SQL Server MVP) ... > capture sql traces are written into the file. ...
    (microsoft.public.sqlserver.tools)
  • Re: How to determine what was inserted
    ... updates etc) ... I will try the profiler if I can, but we are concerned by the extra time ... > was done by Replication when it reminds you 3 inserts etc., ... Only possible way is using SQL Profiler to trace ...
    (microsoft.public.sqlserver.replication)
Loading