|
Home > Archive > MS SQL Server > December 2006 > SQL Server Database Size/Free Space Query
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server Database Size/Free Space Query
|
|
| ChrisP 2006-12-05, 7:12 pm |
| I administer 70 separate databases on 3 different servers. Of these
70, 17 are production databases that I must keep the space used to
between 80-90 percent of the space allocated.
If these databases exceed 90% then I increase the allocated space.
Autogrowing the databases in not an option for me due to space
concerns.
I currently sp_spaceused, sp_helpdb or taskpad to base my calculations
on. Has anyone come up with a query that suit this scenario? I might
create a new sp based on sp_spaceused to do this, but am feeling kind
of lazy.
| |
| SGCSNA 2006-12-05, 7:12 pm |
| You could use an alert based on SQL Server Performance Condition (log
file size/data file size) and set the action to be a job which would
grow the file.....
Can't get much lazier than that..... ;)
ChrisP wrote:
> I administer 70 separate databases on 3 different servers. Of these
> 70, 17 are production databases that I must keep the space used to
> between 80-90 percent of the space allocated.
> If these databases exceed 90% then I increase the allocated space.
> Autogrowing the databases in not an option for me due to space
> concerns.
> I currently sp_spaceused, sp_helpdb or taskpad to base my calculations
> on. Has anyone come up with a query that suit this scenario? I might
> create a new sp based on sp_spaceused to do this, but am feeling kind
> of lazy.
| |
| ChrisP 2006-12-06, 7:12 pm |
| Thanks, that does meet my laziness requirement and scenario.
On Dec 5, 2:21 pm, "SGCSNA" <sean.gor...@computershare.com> wrote:[color=darkred
]
> You could use an alert based on SQL Server Performance Condition (log
> file size/data file size) and set the action to be a job which would
> grow the file.....
>
> Can't get much lazier than that..... ;)
>
>
>
> ChrisP wrote:
|
|
|
|
|