Database Size-Percent of capacity ? 1

[FredWagner]

In SQL 6.5, on the server, I was able to get a graph which showed me the size of the database, and how much of it was filled with data - so I could rebuild the database for more data if necessary. I am having performance problems with SQL2000, and cannot find any measure of database sizing or capacity. Is it still there, or is it totally automated ? How can I tell if I need to re-size a table?

Fred Wagner
frwagne@ci.long-beach.ca.us

 

[tlbroadbent]

Database sizing is dynamic in SQL 78 and 2000. You don't need to size devices as in earlier versions. Of course, you still need to monitor database sizes and available disk space.

You can see databsae sizes in Enterprise Manager. Select a database with a left-click. Right-click on a database and select View | Taskpad. The graphical representation of the database size will be presented.

You an also execute the stored procedure sp_spaceused. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[FredWagner]

Thank you Terry! As it turned out, the problem wasn't database size. After checking out all the network and server possibilities I could think of, I told the department key person to watch for 'events' which happened at the same time as the server delays - I was thinking in terms of people moving furniture and crushing network cables....it turned out the event was one user doing an entirely inappropriate SQL query which was tying up the server generating a 9000 entry reply to the query. The solution turns out to be educating the user on how to do more intelligent queries that don't saturate the server! Will keep in touch in this forum. Thank you again.

Fred Wagner
frwagne@ci.long-beach.ca.us