| Author |
Topic |
|
Changzhouren
Starting Member
4 Posts |
 Posted - 2010-09-22 : 14:16:07
|
| Hi, everyone, I'm a new comer to this forum. Thank you in advance to any help to my question.We are having a VLDB (over 1TB), how to reduce the size or any ways to improve the backup and performace.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-09-22 : 14:23:46
|
| To reduce the size, you will need to delete data. If you upgrade to 2008 and use Enterprise edition, you can take advantage of compression.Is there free space inside your data file(s)?To improve your backups, you should consider purchasing a third-party backup utility such as Red Gate's SQL Backup or Quest's SQL Litespeed. Both do backup compression. Backups will be about 75% faster and take up to 90% less disk space. You could also upgrade to 2008 and Enterprise edition and use native compression there.As far as performance goes of queries, how many data files do you have in your database? How often do you update statistics?Have you considered table partitioning?Is your schema well indexes? Have you run the missing indexes report? What kind of performance issues are you having? Have you identified the long-running queries via SQL Profiler?I could go on and on about this, so let's start with the above questions.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
Changzhouren
Starting Member
4 Posts |
Posted - 2010-09-23 : 08:52:57
|
| Tara, Thank you very much for your reply.There is not much free space left after shrinking the database once. since there are many image data type, so, it can not be compressed either.still one huge data file in the db.It seems the performance is ok, the only thing is to reduce the disk space. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Changzhouren
Starting Member
4 Posts |
Posted - 2010-09-23 : 13:01:14
|
| Tara,Thanks. It's my bad. I have checked it again. There are one primary data file and four secondary data files on the second clustered server. any good suggestions to reduce the size beside shrinking files or db? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Changzhouren
Starting Member
4 Posts |
Posted - 2010-09-23 : 15:45:03
|
| Thank you very much. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-24 : 03:48:31
|
| "there are many image data type,"That, IMHO, is one of the main problems with putting images in the database.Can you move them out to the filesystem instead? (and store path / name of the image in the DB instead perhaps?) |
|
|
|
|
how to reduce the size of VLDB