slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Database Administration | New Thread

View: Search:

Author

Thread: HELP! 2GB reached... as a result of indexes

Ron Buchanan
Posts: 72

HELP! 2GB reached... as a result of indexes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Feb 08 2:03 PM

Hi guys,
The DB is only 800k, but the indexes are huge. Is there a way to easily reduce the size of the indexes on MSDE2000? I've got 20 guys connected to this remote DB and they're dead in the water.

Thanks,
Ron

[Reply][Quote]

Ron Buchanan
Posts: 72

Re: HELP! 2GB reached... as a result of indexes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Feb 08 2:13 PM

More info... the IndexUpdates has 8,275,321 rows... any idea what I can do about this?

[Reply][Quote]

Yup.
Posts: 126

Re: HELP! 2GB reached... as a result of indexes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Mar 08 3:26 PM

I don't know if you have resolved your issue or not, but here is the link to a decent article on index fragmentation. If there is an abundance of internal fragmentation, you may be able to recover some space there.

http://www.sql-server-performance.com/articles/per/index_fragmentation_p1.aspx

[Reply][Quote]

Steve Garner
Posts: 22

Re: HELP! 2GB reached... as a result of indexes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Mar 08 7:07 AM

IndexUpdates table can be truncated ...

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 4:50:24 PM