MS SQL Server - SQL Server Desktop

Author

SQL Server Desktop

OdieTurbo

2006-10-24, 6:30 pm

Hello, I have SQL Server Desktop version 7 running on my laptop. I am
using as a data source for Cognos DecisionStream. The issue I am
having is that my database has grown quite large. Everytime I try to
do anything, my database is EXTREMELY slow. What can I do to increase
the speed/efficiency of my database? Thanks

Todd Q

DB2DOTNETCZAR via SQLMonster.com

2006-10-24, 6:31 pm

Hi Todd,

I would advise you to first take a backup of the current database.

Next , In the Enterprise Manager --> Right click on your database and Choose
All Tasks--> Choose Shrink Database. There choose the percentage you want the
database to be free of ( For example: if your database is 100 MB and you
choose that you want 50% of space available) Choose 50%.

Next once this is done, this solves the space issue.

Now Run the Index Tuning Wizard.

The link provided below is a handy reference

http://www.microsoft.com/technet/pr...6.mspx?mfr=true

Now stop the service and restart and you should see an improvement.

Hope this helps.

--
Best Regards

Anil Mahadev

http://anilm001.myfreewebs.net/index2.php

http://www.db2india.org

Message posted via http://www.webservertalk.com

Sponsored Links