DB size is morethan 2 GB how to optimize

Dears,
Is there any other settings for managing DB size is more than 2 GB, it seems
it takes long time to retives the data. please give me idea.
Thanks,
Dinesh Bhandare
Are you using MSDE by any chance? What makes you feel it takes long time ...
I've databases that are more than 8-10 GB in size and they yet perform good
under load ...
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Dinesh Bhandare" <DineshBhandare@.discussions.microsoft.com> wrote in
message news:B42CBC39-EA49-40FD-B6F2-97DAF84CD4FB@.microsoft.com...
> Dears,
> Is there any other settings for managing DB size is more than 2 GB, it
seems
> it takes long time to retives the data. please give me idea.
> Thanks,
> Dinesh Bhandare
|||Dinesh
2gb is not a very large database. You should be able to get very good
performance from it. So many things it could be.
A few things to try. Run profiler to capture your longest running queries.
Put those queries into query anayser and check the execution plans. If there
are problems with the code or lack of correct indexes, it should be easy to
spot. Here are some good tips on using profiler.
http://www.sql-server-performance.co...filer_tips.asp
Run dbcc showcontig on all your tables to check your tables for
fragmentation.
You do keep your database files, transaction logs and backups on seperate
disks, don't you? If you don't try to move them so you do.
Use perfmon to check your memory and disk I/O are not having problems. Here
is a link to a good article on using perfmon.
http://www.sql-server-performance.co...nitor_tips.asp
There are lots of good articles on performance on
http://www.sql-server-performance.com/ have a good look through them and see
if you can identufy which areas may be affecting you.
If you are using a LAN or WAN, might be worth asking your network guys to do
a check, might not be a SQL Server problem at all.
These tips should at least get you started. There are so many things it can
be.
Hope this helps.
John
"Dinesh Bhandare" wrote:

> Dears,
> Is there any other settings for managing DB size is more than 2 GB, it seems
> it takes long time to retives the data. please give me idea.
> Thanks,
> Dinesh Bhandare
|||To add to the other responses, appropriate indexing is an important
performance consideration. Large tables are less forgiving when you don't
have indexes in place to efficiently process queries. Review your query
plans. Columns referenced in joins and predicates may be good candidates
for indexing.
Hope this helps.
Dan Guzman
SQL Server MVP
"Dinesh Bhandare" <DineshBhandare@.discussions.microsoft.com> wrote in
message news:B42CBC39-EA49-40FD-B6F2-97DAF84CD4FB@.microsoft.com...
> Dears,
> Is there any other settings for managing DB size is more than 2 GB, it
> seems
> it takes long time to retives the data. please give me idea.
> Thanks,
> Dinesh Bhandare
sql