September 9, 2009 at 1:31 am
I have one database whose Data file is growing at very fast pace & it’s so huge that the hard disk of server is almost out of space. Now I tried to shrink the database & data file but the results are almost negligible.
So My TeamLead noticed the issue and did something
then just drop a mail like below
----------Mail-----------------
“The data file is large, but not full of data. I have dropped most of the partitions.”
----------Mail End-----------------
Now I got confused with his mail that how he did that. I have only a logic that how he probably do this but I m not sure what query or script he used. ?
can anyone tell me why he dropped the partioned , just to regain space ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 9, 2009 at 4:06 am
Unless he has moved data between partitions perhaps.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 9, 2009 at 4:30 am
can u please describe your thought ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 9, 2009 at 4:35 am
Bhuvnesh (9/9/2009)
I have one database whose Data file is growing at very fast pace & it’s so huge that the hard disk of server is almost out of space. Now I tried to shrink the database & data file but the results are almost negligible.So My TeamLead noticed the issue and did something
then just drop a mail like below
----------Mail-----------------
“The data file is large, but not full of data. I have dropped most of the partitions.”
----------Mail End-----------------
Now I got confused with his mail that how he did that. I have only a logic that how he probably do this but I m not sure what query or script he used. ?
can anyone tell me why he dropped the partioned , just to regain space ?
Request your Team Lead to document what was causing the issue and how did he fix it and make the document available for all the team members so that, if this problem araises again others should be able to fix it.
September 9, 2009 at 4:43 am
It's possible that your team lead merged the existing partitions and dropped some file groups / or shrunk the datafile after merging.
Thanks
Suresh Ramamurthy
September 9, 2009 at 7:49 am
Bhuvnesh (9/9/2009)can anyone tell me why he dropped the partioned , just to regain space ?
1- One or more unwanted partitions have data = are allocating space
2- Team lead purges a.k.a drops these partitions = allocated space gets reclaimed.
I would suggest to check large tables partitioning strategy as well as archive and purge strategies. Most probably some A&P process somebody forgot to launch.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply