1/24/2008

Your master db is how big?

Caller: My master database is 500mb, and I'm running low on drive space
Kevin3NF: 500mb is small...you're that low on space? What did you create in the master db?
Caller: Nothing
Kevin3NF: What about these three user tables named "Trace1, trace2 and trace3?"
Caller: Oh yeah...forgot about those. I'll delete them.
Kevin3NF: You want fries or a salad with that?

:)

If you are going to save your Profiler trace data to a table, please create a database named "Traces" and save it there...

Master database doesn't accrue much information day to day, so should almost never grow to more than 100mb or so. It is more metadata than anything else.

Kevin3NF

No comments: