I am attempting to calculate the amount of space that will be needed for our database for the rest of the year as well as next year.
The end-users have provided estimates as to how the tables will increase in rows for the rest of the year as well as next year, from there I am able to calculate...
We have a table that is split across three dbspaces. When it was set up it was given a very large next extent. So when it grabbed the next extent it took the remaining space in all three dbspaces. Is there a way to show how much space is actually being used. The query I have shows the dbpsaces...
My boss, gave the ok to have a test server re-loaded. He did not know that my DTS package was on there.
Is there a file I need to look for on the system backup? Or can I restore this from some other way. Or do I have to start over?
Thanks!
I came across the below statement...
"Monitor the number of extents per table with the following SQL. When a large number of extents have been allocated, schedule a time to perform preventative maintenance on the table. Theoretically, a table could have 200 extents, but realistically...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.