June 30, 2011 at 1:46 am
Hi all,
I faced one of the production server issue.
Here is the issue:
The disk D on computer USDC8273SQL2B.kih.kmart.com is running out of disk space. The values that exceeded the threshold are 3% free space and 1331 free Mbytes.
But i checked the D drive , it has a lot of space
urgent help
June 30, 2011 at 1:52 am
1-Open the SSMS(Sql Server Management Studio)
2-Right click on the desire database and then click properties
3-In the General TAB on the left side pane then check the Size and Space Available values on the right pane of window
what is it ?
If Space Available value is big one then you dont need to worry because new pages will be create in the current Space Available shown in this window,if this value is small then you have to wory
where did you get this message out of disk space ?
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
June 30, 2011 at 1:58 am
I have only this drive, this drive is only for sql server databases
June 30, 2011 at 1:59 am
where did you get this msg out of disk space ?
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
June 30, 2011 at 2:01 am
I got a mail automatically when ever the space issue occurs
June 30, 2011 at 2:09 am
Do you have restriction on database files growth?
try this
sp_spaceused @updateusage = 'TRUE'
for the specific database
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
June 30, 2011 at 2:43 am
subbkarth (6/30/2011)
I got a mail automatically when ever the space issue occurs
Check the script may be its written worngly. Or show me ll tel you.
what its return xp_fixeddrives.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply