Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
natishkc
Starting Member
29 Posts |
 Posted - 2009-02-09 : 05:22:38
|
| What precautions should be taken before Database Shrinking?At Present my DB size is 55 GB. Approx how much time to shrink on intel xeon with 8 GB RAM.Natish |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-02-09 : 12:27:25
|
| Why do you want to shrink your database? It causes massive index fragmentation and will just cause the DB to grow again next time data's inserted. That grow will slow the system down.Please read this, and the articles that are linked at the bottom of the post - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/--Gail ShawSQL Server MVP |
 |
|
|
natishkc
Starting Member
29 Posts |
Posted - 2009-02-09 : 23:12:04
|
| Actually I want to do the shrinking offline, anyhow I gone thorough your provided link I was amazing to make me understand about the shrinking. My problem is that one of My DB table having 10 crore entries. When the query is reaching to this table the Local System Performance as well as Server Performance getting down and as result Run Time error or Time out expired coming. I want to do the purging or something like to reduce the table quantity. Already I have 3 archival servers. I do not want to make any more archival. Please suggest me. It would be highly appreciated.Natish |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-09 : 23:55:04
|
| Do you have appropriate indexes on that table? You can use Partition Views. |
|
|
|
natishkc
Starting Member
29 Posts |
Posted - 2009-02-10 : 01:23:23
|
| How? Can u pls explain in detailsNatish |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-02-10 : 10:26:35
|
| What's a crore of records?Shrinking's going to hinder performance, not help. If you have slow queries, check that your indexes support the queries.--Gail ShawSQL Server MVP |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-10 : 10:29:14
|
quote:
Originally posted by GilaMonster
What's a crore of records?http://en.wikipedia.org/wiki/Indian_numbering_systemShrinking's going to hinder performance, not help. If you have slow queries, check that your indexes support the queries.--Gail ShawSQL Server MVP
|
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-02-10 : 15:35:48
|
| Thanks. I must bookmark that. I keep seeing people post records counts that I just don't understand.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Database Shrinking