May 4, 2009 at 8:53 am
Can some one tell me what tools can I use to monitor if the drive is running of out space for leaving db or if the db start growing quickly within days?
Thank you
May 4, 2009 at 9:39 am
xp_fixeddrives can tell you how much space you have left on drives. I believe Red Gate's SQL Response can monitor things like sudden table/database growth.
There are ways to cook your own tools for that kind of thing, but buying is usually a lot more convenient.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 4, 2009 at 11:30 am
What about checking if we have enough space on sql server box where server leaves?
May 6, 2009 at 6:49 am
Krasavita (5/4/2009)
What about checking if we have enough space on sql server box where server leaves?
Not sure what you mean.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 6, 2009 at 8:33 am
I want to monitor if I have enough space on the sql server itself. Thank you
May 6, 2009 at 8:53 am
You can use sp_spaceused to see the space inside a database.
alternatively, track the backup file size and compare that to what size of the data file and you'll have a rough idea of how much free space you have. As the backup file gets close to the data file, you can manually add space to the data files, which is what you should do.
I would recommend when you grow, you add enough space for 1-6 months, depending on what you feel comfortable with.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply