Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


the use history from table


the use history from table

Author
Message
fernandoibarra23
fernandoibarra23
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 7
Hello, I need to know the use history from tables.
Help me, please
Thanks a lot
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11022 Visits: 14858
Can you provide some more details? Do you mean how to use history tables? Do you mean how to find a history of who accessed a table and what they did?



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
fernandoibarra23
fernandoibarra23
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 7
Hi Jack, thanks for your help.
To be more specific, I need to delete unused tables from my Data Base.
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11022 Visits: 14858
There really is not a way to tell which tables have been used. You could set up a server-side trace, but how long would be long enough to run it to know if a table is used or not. Perhaps a table is used only once or twice a year? Unless you have major space issue and can't get more disk space I'd just leave it alone.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Joie Andrew
Joie Andrew
SSC Eights!
SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)

Group: General Forum Members
Points: 970 Visits: 1912
If the tables on your database do not have a timestamp column that you can evaluate you have a few options. The first is what was already posted - run a trace against the database and find out what tables are being used. The downside is that this can take quite a while, and you still cannot be sure there are tables that are not modified yet still used ocassionally. Another option is to either create a change column on each table or a change table for the database and have triggers run to populate it with information on what table was used. Again the same problem is present though. I would say the only way to find out for sure what tables are not in use is to get with the users who use the program and the engineers who designed the database to determine what tables, if any, are no longer needed.

Is the purpose of deleting tables just to clcear up space? Because if that is the case, there are better options available, such as partitioning tables, archiving data, and/or deleting only records that are no longer needed.

Joie Andrew
"Since 1982"
fernandoibarra23
fernandoibarra23
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 7
Hi,
I need to know statistics about the uso from my tables and my store procedura (specialy the stores procedures) becouse I want to update all my SP through a script.
The old (and unused) SP have same not exists column and this may be will fail my script.
Then, if the tables or SP are not used I can make decision.
I don´t need to clear up space, my goal es administration better my Data Base.
Thanks a lot.
Joie Andrew
Joie Andrew
SSC Eights!
SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)SSC Eights! (970 reputation)

Group: General Forum Members
Points: 970 Visits: 1912
Others can correct my thinking if I am wrong, but you may need to get with the engineers/developers who designed and built the system to best determine which stored procedures and/or tables that can be gotten rid of, if any. I would imagine they would know how to determine which ones are in use and which ones can be deleted. It may not be as easy as just seeing which ones have been used last depending on how the database is used.

Joie Andrew
"Since 1982"
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search