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 |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2008-10-21 : 06:30:59
|
| Hi expertsi a have one blank database(beforegoing to give to client deleted all data) when i restored that it has the size 343MB and space available 332.84when i srink the data base it become size 11.19 MD and space available 0.09MBby doing this, is it effect the performance of the datbase |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2008-10-21 : 07:19:43
|
| who cares? Your database isa) So small as to make no differenceb) Empty, so you cannot make any meaningful measurementsYou only have to worry about performance when it is full, not when it is empty. |
 |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-21 : 12:21:22
|
| If your database is static and does not increase over time then it is ok to shrink, but if you know, DB will grow over time than it is best to manage size of database manually and do not shrink and grow continuously as it can cause fragmentatin at OS level which can have negative impact on performance. |
|
|
|
|
|
|
By srinking the data base performance will effect