Tables used

Question

Post reply

Tables used

vidyap7

SSC-Addicted

Points: 457
More actions
October 16, 2003 at 8:07 am

#176802

Hi,
I would like to get a list of tables which were "touched" in a given time period and see how much space was used by the tables. Does anyone know how to go about doing this?
I have a process I am putting together. The process was run a month ago. So, I need to know which tables were used, so that I can see how much space the tables used. Then I can estimate how much space the total process needs to run again.
Thanks in advance for your help.
VP

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 1

The only way to really do this is either run Profiler or use Entegra from Lumigent.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

vidyap7 SSC-Addicted Points: 457 More actions · Answer 2

Thanks Steve, but isn't Profiler used on things which are running now? The process has been complete for about a month now.

Thanks,

VP

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Hi,

I guess unless you haven't a backup or a copy from that time you're pretty much out of luck

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

vidyap7 SSC-Addicted Points: 457 More actions · Answer 4

Hi,

I guess I haven't explained my problem correctly.

A process was run in my database a month ago. We need to run the same process again. I have been tasked to find out how much space will be needed to run it. The process was an adhoc kind of process - we got the data in, did some slicing and dicing, analyzed it in a dozen ways and then took the results and processed it. The slicing and dicing and analzing used some tables which were not documented. So, I was hoping to get a list of tables that were updated and/or created during the month of september and then do a sp_spaceused on these tables to get an estimate on how much space was used by the process. I can get a list of tables that were created in september. However, some tables were created earlier and were just truncated and the data brought into them. How do I get a list of these kinds of tables?

If I can't get it, I guess I will just have to rely on my team and my memory 🙂

Thanks,

VP