June 5, 2007 at 12:31 pm
Hello,
starting the Profiler to get all active tables names, have total # of tables maybe like 50 , but not sure if all these tables are in use or I can delete some of them.
In the Filter trying to go by ObjectType (user table) = 'U'. Profiler is not taking that, asking for the number.
OK, found the number = 8277 from the microsoft site.
I know that the Application is very busy , but the profiler does not show any table name or ID.
I got data columns Object name , Object ID, Text data
in the Text data this statement :
select status
from WEBApp
where application = 'APP'
Expecting to see the Object name : WEBApp
Object ID : ....some number...
but nothing is there.
Any ideas? THANKS!
June 5, 2007 at 1:29 pm
What type of events are you capturing? If you select Lock:Acquired, it will show you the ObjectID. You can then get the name from the sysobjects table.
-mr
June 6, 2007 at 9:31 am
I selected EVENT for the object : Object:opened . It says it will work when the object will be in use as in SELECT, INSERT or other statements (but it's not or I did something wrong).
Yes, I know about the Locks - it will show the object ID, but I need to know the active tables just for regular App process.
Thanks!
June 6, 2007 at 9:38 am
Ok, I tried that and it doesn't show anything for me either. I'll post a solution if I find it.
-mr
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply