May 28, 2009 at 3:15 am
Hi All
I have a database that contains more than 500 tables, out of which only 10% is been used ( found it out from the apps and SP's), i would like to check all the tables on a database if its been used or not, is there any way with a DDL trigger i can archive this, or is there any other way i can do this, apart from profiler, since i am planning it to run for the next month, so i think trigger is the best option, please suggest me if there are any other alternative ways of doing this 🙂
May 28, 2009 at 6:37 am
There is no SELECT trigger. The best way is what you already have planned, collect the data through a server-side trace (which you can use Profiler to set up). Depending on your system, that's going to be a lot of data. Make plans for aggregating it or cleaning it as you collect it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 28, 2009 at 7:15 am
Thanks Mate 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply